Questions about Tables formulas

  • Profile Image
    Folkhalsan
    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
    Yvette_L
    Answered on October 28, 2020 at 07:33 AM

    Thank you for contacting us.

    1.

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

    1603883809_5f995321e4704_image (3).png


    2.

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

    1603883882_5f99536ac70df_asdkas;dlsdl.pn

    3.

    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!