-
Formula Assistance with Linking Sheets
Hi! I have created a sheet that uses a form for requests when my company is wanting a physician to travel. This includes what center/state they're traveling to, their home center/state, the district manager that oversees each center, etc. When a physician is selected I would like for the home center, home state, home…
-
Replacing all special characters in form query string parameters with a formula
Hello everyone! I am excited to be speaking at the "Leveraging the Query String in Forms" session at Engage 23! I wanted to share a formula that a customer and I developed to replace any special characters that could show up in cell when you are building a URL to a form with query string parameters using a formula. This…
-
Best Way to Tailor Forms for a Specific Person on a Contact List?
For example, I have different teams providing updates in a Grid view. I would like to have multiple versions of a form where each person on the contact list gets a form that already has their team selected. Any advice on the easiest way to set this up? Thank you!
-
Is there a new issue with creating and accessing forms?
I've been trying for weeks to access a form I previously created, and I'm also trying to simply create a new form. Neither have been available for some time.
-
Can Form Submission messages contain dynamic content?
We have a Form submission, where submitters need to know the ID generated. Is it an option to put {{Row ID}} into the message to share that info with them immediately on screen? Things are configured to send an e-mail with that info and various other items summarizing what they entered, but the question came up about this…
-
Form Data Validation Against Dataset
The ability to control text form entry against a large dataset. For example, I have a form that went out to 1,500 employees. The primary column is their name. Now when I want to check who has vs. has not completed the form, I have to manually check for false negatives due to slight differences in how they typed their name…
-
Multiple Step Automations
Hi All, I have a form that collects data. Once the form is submitted, it changes a field to "In for Approval". I then have multiple automations set-up to assign 7 different Owner based on certain criteria and 1 to send a request for approval to the newly assigned Owner. Most of the time this seems to be working correctly,…
-
New! Add real-time validation to fields on your form
Hi Community, We just enabled a forms enhancement that many of you have requested: field validation. You can now add real-time validation to Text/Number fields to help collect error-free numbers, percentages, email addresses, and phone numbers. Email validation is also available for Contact fields. We think this will be a…
-
Copy row to another sheet help
I have a Task Request sheet that has a column listing the name of the Project to which the task belongs. When a new task is created (from a form) and the requestor has selected the Project it belongs to, I would like to create an automation that copies the task row to sheet that has the same Project name. If there's a…
-
Best way to file forms
Hi All, I have created a fairly complicated workflow to track productivity and financial data with multiple sheets and reports, I am now looking to ensure access is minimal for each work-level in order to simplify and reduce the number of sheets etc. they see, however I have forms in several sheets and wanted to ask how…
