Do math in text field (no input) #7193

andreapx · 2023-08-03T06:45:14Z

andreapx
Aug 3, 2023

Hi all,
I need to multiply 2 valued in a text field like this:
Result: {{queries.mysql_specs.data[0].field_1}}*{{components.base.value}}
Is it possible? How can I do that?
Thanks!

Answered by withshubh

Aug 3, 2023

Try this: {{queries.mysql_specs.data[0].field_1 * components.base.value}}

View full answer

withshubh · 2023-08-03T07:01:22Z

withshubh
Aug 3, 2023

Try this: {{queries.mysql_specs.data[0].field_1 * components.base.value}}

3 replies

andreapx Aug 3, 2023
Author

If I have a division, how can I round the result?
I see that it's possible to use JavaScript in the query, but how to use it in a text field?

withshubh Aug 3, 2023

Use this {{Number((queries.mysql_specs.data[0].field_1 / components.base.value).toFixed(2))}}
This will round off the result to 2 decimal places.

andreapx Aug 3, 2023
Author

Thanks!
I'm starting to understand how to use JavaScript in ToolJet.

andreapx · 2023-08-03T07:02:39Z

andreapx
Aug 3, 2023
Author

Thanks a lot!!!

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Do math in text field (no input) #7193

{{title}}

Replies: 2 comments 3 replies

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

Select a reply

Do math in text field (no input) #7193

andreapx Aug 3, 2023

Replies: 2 comments · 3 replies

withshubh Aug 3, 2023

andreapx Aug 3, 2023 Author

withshubh Aug 3, 2023

andreapx Aug 3, 2023 Author

andreapx Aug 3, 2023 Author

andreapx
Aug 3, 2023

Replies: 2 comments 3 replies

withshubh
Aug 3, 2023

andreapx Aug 3, 2023
Author

andreapx Aug 3, 2023
Author

andreapx
Aug 3, 2023
Author