SmartForm for Smartsheet
SmartForm automatically updates the dropdown list and contact list options of a field in real-time, based on previous selections made in another field on Smartsheet forms.
Automate Dropdown List Dependencies in Your Smartsheet Form
The Department list will dynamically adjust based on the selected Company, while the Team list will dynamically adjust based on the selected Department. This ensures fast and accurate data entry on Smartsheet forms.
Smartsheet Form Before and After
A normal Smartsheet form previously confused users with a lengthy dropdown list of Department options. With the SmartForm solution, the form now only displays the relevant departments of Company A, simplifying the user experience.
Configuration Sheet
The Configuration sheet is created in Smartsheet to define dependency relationships between the Company, Department, and Team fields.
SmartForm Task
The SmartForm task is created in Gia Thinh Automation Services. The task is declared with information related to the Form URL, Company/Department relationship, and Department/Team relationship.
WeGRID SmartForm extension
The WeGRID SmartForm extension developed by Gia Thinh can be downloaded and installed in your web browsers, enabling the connection between your Forms and Gia Thinh Automation Service.
Click on the links below to download the extension.
SmartForm automatically updates the dropdown list and contact list options of fields in real-time, based on previous selections made in another field on Smartsheet forms.
Key Features
- Utilize a Configuration Sheet as the source list for defining dependency relationships.
- Compatible with Smartsheet forms running on desktop web browsers (Microsoft Edge, Google Chrome) and mobile browsers (Kiwi browser for Android, Orion browser for iOS)
- Automatically updates dropdown list and contact list options of a field in real-time, based on previous selections made in another field on Smartsheet forms.
- Update data in Configuration sheet will automatically update all dropdown options of the Smartsheet forms in real-time.
How to get it:
Contact Gia Thinh to request a trial of SmartForm tailored to your specific needs.
We're here to assist you.