General Discussion

 View Only
  • 1.  Multi-select or Dropdown from Data Source question

    Adopter
    Posted 16 days ago
    Edited by Scott Gilleland 16 days ago
    When using a Multi-select or Dropdown with options from a data source, I get a blank selection choice at the bottom of the popup, like this:


    When selecting this, the following message shows up on the form:


    It doesn't affect the performance of the form in any way.  It won't keep the form from being submitted.  It's just annoying. Is there any way to keep the blank answer from showing up on the popup selections?

    Edit:  This is an uploaded Excel data source.


    ------------------------------
    Scott Gilleland
    Senior Field Service Engineer
    Messer Cutting Systems
    ------------------------------


  • 2.  RE: Multi-select or Dropdown from Data Source question

    Posted 15 days ago

    Hey Scott, 

    I just did some playing around with this and think I have found out why thats happening. 

    When we are parsing through a data source to find the options to display, we will read the rows and then the columns. There is a good explanation here (it says Google Sheets but is also applicable to Excel): https://support.prontoforms.com/hc/en-us/articles/4406631466260-Troubleshooting-Google-Sheets-Data-Source-Multiselect-Question-Showing-Blanks

    It describes how we process the records in a data source and explains why would see a blank value in your drop down. In my test, I have 2 columns that are used for my options. If these 2 columns have different number of options, you will generate a blank value in the list of options because ProntoForms needs to read that row to get the options for the other column and just assumes that "blank" is an option. 

    Example: 

    Data Source with different number of options:
    The app:

    Data source with the same number of options:

    Hope this helps! 



    ------------------------------
    Ian Chamberlain
    Implementation Specialist
    ProntoForms
    ------------------------------



Reminder: Content posted to our Community is public content.  Please be careful not to post Intellectual Property that you do not have permission sharing.  For more information please refer to our Terms Of Use