using external data in a form and sheet and for validation
Our company has an internal application. I would like to reference this application's data in a form and in a sheet:
- When a user is submitting a form, it lets them select a value from a drop down that is populated from data in this external application
- When a user is submitting a form, it lets them enter free-form text that is cross-referenced/validated against the external data to verify the user entered valid data (an internal ticket ID for example)
- After a user submits a form and a row is added to a sheet, some columns are auto populated with data that comes from the external data
Is this possible using Smartsheet and if so, how?