How can I change the data-type when importing from another table?

  • Profile Image
    jeanp27
    Asked on December 24, 2020 at 09:46 PM

    How can I change the data-type when importing from another table? I have a database with date/time format and also with a column with booleans.



    This is a re-post of a comment on How to Get Data From Other Forms in JotForm Tables

  • Profile Image
    Vick_W
    Answered on December 24, 2020 at 09:55 PM

    Hi there,

    Unfortunately, it's not possible to change the type of data on a column. This is because the columns are mapped and synced to the form field types.

    However, you can try the Connection feature on the tables. Add a column and connect it to the existing table. Please check out the guide below for more details.

    https://www.jotform.com/help/1012-how-to-add-and-organize-columns-in-jotform-tables

    Let us know if you have any other questions or concerns.

    Thanks