I have an array in a spreadsheet I need to reference

  • Profile Image
    nsdisability
    Asked on April 06, 2019 at 09:21 AM

    I have a spreadsheet that has a list of medical specialties in Column A with their ages in Row 1.  The subsequent array will then show a list of prices based on those two data points.  How can I get my form to automatically populate the rate from the spreadsheet if they answer these two questions (specialty and age)?

    1554556842Capture.JPG

  • Profile Image
    jherwin
    Answered on April 06, 2019 at 10:58 AM

    We have a spreadsheet to form widget that can pull data from the spreadsheet via a unique code. However, the user should know their unique code to in able to get the data in that spreadsheet.

    Guide: How-to-Use-the-Spreadsheet-to-Form-Widget

    However, it seems that widget will not meet your needs because you want to automatically pre-populate the fields if the question is answered. If the spreadsheet data is not large or long, I think it can be achieved through conditional logic.

    Guide: 

    Conditional-Logic-for-Online-Forms

    How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

  • Profile Image
    nsdisability
    Answered on April 06, 2019 at 11:20 AM

    It's definitely pretty large.  There's 1,100 possible outcomes unfortunately.

  • Profile Image
    Victoria_K
    Answered on April 06, 2019 at 01:01 PM

    I see there are many rows with same rates:

    It is likely that the only option would be to use conditional logic and to set up calculations on a form. Do you have a formula that was used to generate the rates?