Working with Forms with an Airtable Database is about the same as when working with a standard database built in Adalo, but there are a few differences. Currently, sending attachments such as images or other files to a database in Airtable using a form is not supported at this time. When adding a form into your app on Adalo, many fields will automatically appear on your form that will need to be removed.
This includes: - Image properties - Attachment properties - id - Created Time - Relationship properties - Formulas
Update forms
Forms are the primary way your users can edit records in your app's database. Images and attachments cannot be add through forms when using an Airtable database, but you are able to update records that have them. As stated above, image fields must be removed from forms to work properly. If you find that updating these records is removing the images, you will want to make sure that your Endpoints are set up correctly. How to set up your endpoints is covered in the Connecting to Airtable help document.
Airtable Dropdown fields & Validation
If you have a drop down field or Single Select field in Airtable, this field will show up in Adalo as a text field instead of a drop down. However, if used in a form, it will validate with airtable to ensure that the entered text matches one of the options that you set up. This can be tricky for a user since there is no message stating that it doesn't match. Below, I am going to go over how to set up a Airtable Single Select fields in an Airtable database, Single Select fields in Adalo forms, and a few ways to make it clearer to your users that it must match one of the options.
-
Open the Airtable database and table that you would like to add the field to.
-
Select the add field button.
-
Name the new field.
-
Select the drop down where it says A Single line text.
-
Select Single Select.
-
Select the text + Add an Option.
-
Type in what you want the first option to be and then press [Enter].
-
Enter in the rest of the options.
-
Select Save.
-
You can then fill in that field for any existing records using a drop down. Select the new field for the record that you would like to update.
-
Select the desired option from the drop down menu.
As mentioned above, single select fields in Airtable will not show up as drop downs in Adalo. You are able to use it to validate that your users are using the valid options that you set up though. If a user tries to submit a form with text that does not match one of the options for that field, the form will not submit. If they enter matching text, then it will submit. An example of this is shown below.
To help make it clear to your user that the text must match one of the fields, in the Airtable Single Select field, you can change the Placeholder text as well as add an additional text field. A simple example of this is shown below. For more information on customizing your form and changing the placeholder text, please refer to the Forms help document.