How to collect data through a table.

  • Profile Image
    SGRXAdmin
    Asked on October 22, 2019 at 05:17 PM

    I am trying to build a form where the respondant will need to fill in the empty cells in this table (for the Local Inventory, Date of Expir., Monthly Use and Doses Requested)

     

    Medication Dose Local Inventory Date of Expiration Monthly Use  Doses Requested
    Meds 1 1 gm        
    Meds 2 2.4 mu syringe        
    Meds 3 vial for injection        
    Meds 4 100mg #14 btl        
    Meds 4 500mg #5 btl        

     

    Ultimately - we would like the ability to download this into csv for import into a database if possible.

     

    I've tried the following widgets:

    Multiple Text Fields

    Data Grid

    Matrix Dynamique

    Configurable List

     

    However I'm not able to capture the data in a good format - do you have any suggestions?

     

    Thank you very much!

  • Profile Image
    BDAVID
    Answered on October 22, 2019 at 06:26 PM

    Thank you for contacting us. I assume that you are referring to this form: https://www.jotform.us/form/92946622179165

    Where you have already set up a dynamic table with the Configurable List widget:

    1571782943configurablelist.png

    If you need it not to look off the form width, you may increase the form width from the designer:

    1571783089increasewidth.gif

    In regards to exporting the data, unfortunately, there is no way to change its format. The data is shown in once cell only. Let us know if you have more questions.