Hello
Looking throughout this community for any additional insight on third party applications with AirTable. In particular exploring better Forms options and capabilities. Through looking at different program applications JotForm seems good, however limited in the ability it cannot use the linked field option to the AirTable base. The other option was On2Air which does appear to have an option to link records within its form.
Limitations we are experiencing and would greatly benefit our current project and future within the company are:
- A form that can be accessed by any user with the link and submit directly into AirTable.
- Current process is using a Google Form that is manually updated into the AirTable table import feature. This process is very manual as well as the linked record fields must be completely done manually.
- A form that allows outside elements, fields or structure to be added to allow a more flowing form. Interface has this option, but going back to the first issue it cant be accessed by anyone to submit new records. View option is only authorized for outside users.
- A form with pre-fill options as well as identify a duplicate upfront before submission. We currently have the setup to pre-fill in some of the form, but this is only one field and makes for a long url. Other pre-fills would be default dates, etc.
- A form with in-form calculations. Currently these calculations are handled through AirTable automations when the form is submitted, but having an in form option would allow the end user to see their submissions with the score calculated already and additionally an option the maybe reverse score (reduces points from the maximum score as checks or options are selected to get to the final score.)
Thank you for any additional insight. I have reached out to AirTable support as the company has an enterprise account with them and they are looking into ideas with the engineering support team.
