Jotform Table [Advanced Formula]

  • Profile Image
    hakodesh98
    Asked on November 11, 2021 at 11:43 AM

    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.

  • Profile Image
    Mark_Louis
    Answered on November 11, 2021 at 12:23 PM

    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.

  • Profile Image
    hakodesh98
    Answered on November 11, 2021 at 01:35 PM

    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.

  • Profile Image
    ashwin_d
    Answered on November 11, 2021 at 02:19 PM

    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.

  • Profile Image
    hakodesh98
    Answered on November 11, 2021 at 03:01 PM

    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

  • Profile Image
    VincentJay
    Answered on November 11, 2021 at 03:34 PM

    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

    1636662816_618d7e20510bd_cavb321151.gif

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

  • Profile Image
    hakodesh98
    Answered on November 11, 2021 at 04:06 PM

    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.

  • Profile Image
    VincentJay
    Answered on November 11, 2021 at 04:30 PM

    Sure, I understand.

    First, please add a calculation value to the options.

    1636665950_618d8a5e22bd0_ac5zf22.png

    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.

    1636665985_618d8a81f3f63_va24452.png

    Here's the result:

    1636666161_618d8b316b16d_av53126sa.gif

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