Jotfrom Table Formulas & Functions

  • Profile Image
    TREF_forms
    Asked on February 10, 2021 at 05:46 PM

    Hello,

    I am currently working on a Jotfrom Tables project. Is it possible to convert a string to a number using a formula? We have a column with numbers but the column type is text. We would like to convert this text into numbers. Additionally, is it possible to move multiple rows to another sheet all at once? We have several filters on our sheet with a dropdown column, it would be fantastic to set all selected rows to have the same column entry.

  • Profile Image
    Jessica_H
    Answered on February 10, 2021 at 09:21 PM

    Hi TREF_forms, thank you for reaching us.

    I believe the string field with numbers will automatically be converted as numbers, which you can use to sum/count as numbers. Or, are you referring to extracting numbers from a string field?


    Additionally, is it possible to move multiple rows to another sheet all at once? We have several filters on our sheet with a dropdown column, it would be fantastic to set all selected rows to have the same column entry.

    Unfortunately, it is currently not possible to move multiple rows to another sheet all at once. However, as a workaround, you may consider export your data as Excel, then import it back in. Kindly noted that importing submissions will be counted against your limit.


  • Profile Image
    TREF_forms
    Answered on February 11, 2021 at 12:38 AM

    One of our text columns (filled with numbers) does not seem to offer the sum summary feature at the bottom of the column. I do believe extracting numbers from a string field would help us accomplish our end goal.

  • Profile Image
    Vick_W
    Answered on February 11, 2021 at 02:21 AM

    Hi there,

    Could you please specify the form URL in question and the field name as well. We can create a clone of your form and conduct tests to check if what you are requesting is possible.

    Looking forward to your reply.

    Thanks

  • Profile Image
    TREF_forms
    Answered on February 11, 2021 at 09:05 AM

    Here is the form URL: https://form.jotform.com/200264722404040

    The numeric spinner submissions appear as text in Jotform tables.

  • Profile Image
    Lorenz_A
    Answered on February 11, 2021 at 10:15 AM

    Hi there,

    It seems like the spinner value returns as a text in the Jotform table, I tested with one of my forms and I'm getting the same behavior.

    I have created another ticket with regards to the spinner which returns the value as text and escalated it to our developers so they can further check.

    You may monitor this ticket https://www.jotform.com/answers/2891616-jotform-table-table-reads-the-spinner-field-as-a-text for any updates.

    In the meantime, the only workaround I can possibly think of would be replacing your spinner with a number field in order to get the summary feature from the Jotform table.

    Thank you.