-
Provide list of managed references while editing / creating a formula
When writing a formula where I need to use cross sheet references, I would love to have a list of the already created references on my sheet be available when I select "Reference Another Sheet". It could just be access to the already existent "manage references" list or could be divided based on the sheet that is being…
-
Complex Form Logic Conditions
I really like that forms have some type of conditional logic, so that the users don't have to see fields that aren't relevant. But, it would be nice to add AND/OR logic. For example, the way it is now, conditions can only be based on the selection of a single field. With the addition of AND/OR conditions, we could combine…
-
Form Data Validation that compares fields to each other
I'm hoping for a custom validation option on form fields that compares them to one another. Specifically this is in regards to numeric fields: one field cannot be greater than the other field. To take that a step further, what I really need is the option to prevent the sum of certain fields from (1) exceeding the sum of…
-
Limit Range for Numeric Form Fields
Allow Form creator to select allowable range for entries in numeric Form fields (custom validation). If a number is entered outside the allowable range, show an error message and don't allow the form to be submitted. I have a form that requires entering the FTE (Full Time Equivalent) value for a current employee (the form…
-
Date Logic in Form
In forms it is not uncommon to have a Start and End date for any reason (mine is for PTO). It would be very helpful if there could be some logic added to Date fields to compare with other Date fields. In my case I need to add logic that prevents a user from entering an End Date that is prior to the Start Date. Today this…
-
Ability to add character limits to Text/Number column type
It would be very useful to be able to set a maximum character length in a Text/Number column. A minimum would be good too. Attempts to enter answers outside the character limit(s) would be rejected like entering a non-date into a date field, with a pop-up message & admin override allowed. The settings would be optional, so…
-
Update Request Customization - descriptions and headers like a Form
The update requests are not always easy to explain with the limitations in the column header. It would be very beneficial and extremely useful to allow the user to create update requests like you would a form.
-
Redisign how you merge e-mailed notifications for the same user
When you work with workflows and customized messages in workflows, the automation will generate separate notifications if six or fewer rows are triggered simultaneously. If seven or more rows are triggered at once, the system removes the custom subject and message body -> this merged notification results in the user…
-
Sheet Access Report via API
As we are automating our process to manage users and sheets we are looking for a way to automate pulling the data that is contained in the Sheet Access Report. As an admin using the admin token, I am able to pull a list of sheets and then able to use the API to gather some information on the sheets but am unable to gather…
-
Add Links to WorkApps in Automation Messages
Currently when creating an alert automation you have the option to include Message Only, Link to Sheet and All Fields, or Link to Sheet and Specific Fields. We are trying to promote WorkApps instead of users accessing the source sheet, so it would be better if we had two additional options: Specific Fields with no Link…