Select Options From a Resource

It is now possible to have a select field in your form pull options from a resource.  In this article we'll be giving a walkthrough of how to set this up for your mobile form.

To do this you simply need to upload an excel resource with a basic format

- The first row is the column headers

- The rest of the rows are data

e.g.

 

 

Once you have a resource you can attach it to your Select question in the Designer.

1. First click on your Select question then select "Select options from Resource" in the Field Properties Box on the right hand side.

 

2. Next click on "Select Options Resource" and either upload the excel file or select the resource you uploaded previously from the File List.

 

 

3. Finally just select the Table/Worksheet, the Column to use as the Identifier (what gets sent to the server when you select a value) and the Column to use for the Text (what the user sees on your form)

 

Then save the form, close / refresh the app on your mobile device and you are all done.  If you need to make any edits to your select list, just simply edit your resource and this will take effect on all associated forms.  

This concludes our walkthrough of utilizing a resource in a select question. If you have any questions or comments feel free to send us a message at support@devicemagic.com or leave us a comment below.

 

Have more questions? Submit a request

Comments

  • Avatar
    Hakai Beach Institute

    It would be great if you didn't have to restart the app to update the resource list. One of the best features of Device Magic forms is the automatic updating of forms once an update is saved. I would like to see this functionality in a future app-update

  • Avatar
    private

    I have this option, it worked.

    Now I want to update my selection list, I edited the resource reference with a new xlsx file, expecting my forms to be updated.

    The update doesn't work.

    Please describe how to update the resource.

     

Powered by Zendesk