How to collect data for single unique ID with several forms?

  • Profile Image
    David Kerr 
    Asked on November 20, 2018 at 09:54 PM

    i want to create a form for demographic data. 

    The structure is this:

    employer name address etc keyed to

    employee name and demographic data. Multiple employees to one employer)

    So there is a one to many relationship. 

    Ideally they entere the employer

    and they add each employee row until done and than submit so each employee is keyed to employer ID. 


    This will than than goto a Azure SQL database. 

    Is the above possible?

    Thanks. 

    David 

    In case you need this I would use the HIPPA compliant tier as I may want to create forms for my dental office. The above question is for our professional organization. 

  • Profile Image
    Victoria_K
    Answered on November 21, 2018 at 03:15 AM

    Hello David,

    Unfortunately, I am not sure if I understand the idea in full. Do you want to collect the data with single form or with several ones? Could you please provide a bit more information?

    If you would like to allow your users adding new sets of fields for the list of employees, you could use Configurable List widget: How-to-Set-Up-the-Configurable-List-Widget

    We will wait for your reply. 

  • Profile Image
    David Kerr 
    Answered on November 21, 2018 at 07:43 AM
    In essence, I need to have it like this.
    Unique Employer ID (assigned by form)Employer name, address
    Employer ID,last name ,first,etc
    There are multiple lines for employees.
    But each entry will have the unique employer ID
    So in the end the form saves to two SQL tables:
    Employer Table
    Employee Table
    These are related by Employer ID
    The second part was if on a form they can start new row so if there were 3 employees they add a line each time for the next employee.
    Hope this helps!
    Thanks
    David
    ________________________________
    ...
  • Profile Image
    Victoria_K
    Answered on November 21, 2018 at 08:54 AM

    I see this implementable if you combine 2 forms. Let's say, first form is collecting information of employers, generates ID for them if needed. After this form is completed, respondent is redirected to next form automatically, where they can enter employees info: Redirecting-Users-to-a-Different-Page

    Unique ID can be passed into second form to keep track of submissions: How-to-Automatically-Pass-Form-Data-to-Another-Form

    Would this work for you?

     

  • Profile Image
    David Kerr 
    Answered on November 21, 2018 at 10:43 AM
    Hi,
    That may work. I will look at over Thanksgiving break.
    David
    ________________________________
    ...