Questions about Tables formulas

  • Profile Image
    Asked on October 28, 2020 at 05:32 AM

    1) Can I join two columns? If I have gathered i.e. first name and last name as separate columns and want to join them? Or if I want to join state and city?

    2) Is there a description of what formulas are available?

    3) the link to "create rollup" and "create lookup" does not seem to work.

    This is a re-post of a comment on How to Add and Organize Columns in JotForm Tables

  • Profile Image
    Answered on October 28, 2020 at 07:33 AM

    Thank you for contacting us.


    You can concatenate 2 columns by using formulas under Advanced, please see screenshot below:

    1603883809_5f995321e4704_image (3).png


    There's currently no description just yet of what formulas are available, but you can certainly find them under Add > Formulas > Advanced Formulas > Functions:



    May I please ask you what are your requirements, so I can have a look and see if they work correctly?

    I hope this helps, looking forward to your reply, thank you!