Documentation on Advanced Formulas

Hi, where can I find any kind of documentation on the available table fx functions?

Thanks

Hello!

I apologize, but we currently do not have any documentation on the Advanced Formulas.

You can check the documentation about the specific functions for other spreadsheet software such as Excel or Google Sheets - while the syntax may differ in some cases, the functions basically do the same thing in Jotform Tables and other software.

If you have any questions about specific functions, please let us know and we'll do our best to explain them.

The Switch function visible in your screenshot basically works like the Switch function in programming, if you're familiar with that. As the first value, you give an expression to test against - it could be another column in the Table or static text. The following value, comma-separated, will be the text to compare with the expression and the next value will be what to input in the column field if it matches. You can continue adding such pairs of values however many times you'd like. The last value will be what shows in the column field if no match is found.

So, in all, the syntax is as follows:

Here's an example of this function working - as you can see, it checks the column and if the value in the column is test it returns yes, and if the value is test2 it returns no:

Please let us know if you require any further assistance.

Thank you!