Jotform Table [Advanced Formula]

Is there a in-depth tutorial on how to use the Advanced Formula?

I would like to learn and use it but don't see any tutorials on it.

Hi,

Thanks for reaching out. Unfortunately, we don't have an in-depth tutorial on how to use the Advanced Formula but if you need assistance we are here to help. Thank you.

Okay, I do need assistance.

Jotform Table: https://www.jotform.com/tables/213054811136042

I have a column labeled as "Type of Test". I then have an advanced formula column named "Wording". When a option is selected in Type of Test I want to output certain text in the "Wording Column".

I currently have some just numbers in there as the text to display. When I try it I get a bunch of "FALSE" when I switch from different options. Any help on this would be appreciated.

I am not sure if I have understood your question correctly. Do you mean to say that when a different option is selected in the "Type of Test" field, you want specific text to be displayed in the "Wording" column?

You have 4 options in the checkbox question. Please let us know which text should be displayed in the wording column based on answer in checkbox question and we will take a look. Do you want to achieve this in the table only? It can be easily achieved within the form by taking advantage of our conditions feature.

We will wait for your response.

Yes thats correct, here is what I want down below:

If Accula is chosen display 111

If Cepheid is chosen display 222

If Gale is chosen display 333

If Antigen is chosen display 444

Hello,

May we know why you want to do that on the Jotform Tables? You can try this demo form which can be done in the online form. You can hide the number fields in the form and it will appear only in the Jotform tables.

https://form.jotform.com/213145724038047

Would that work for you or do you want that in the Jotform tables formula?

I need it in the Jotform Tables formula. The people submitting the forms will not see the field "Type of Test" as they are not supposed to. We will have someone from the table view determine which test they will need based off some other factors outside of Jotform. Which is why I want to shorten the amount of work they need to do and have it populate.

A formula would be helpful.

Sure, I understand.

First, please add a calculation value to the options.

After that, use this Formula FX: Field * 1 (one to show the result in the Table column) to show the value based on the answer in the Jotform Table.

Here's the result:

Please give it a try and let us know if you have any questions.