-
Multilingual forms
Hi, I`d like to embed/ insert form to a web page that has multiple languages. Is it possible to create multiple versions of form that will be showed based on the web page language? Or what is best practice in this situation? Thanks for the answer. Best, Beata
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Validation Phone prefix countries missing
When adding a Field in a Form and adding a Validation Phone, there are several missing countries: Croatia, Indonesia, Mauritius, Morocco, Nigeria, Philippines, Serbia, Taiwan, Thailand, Turkey, Vietnam, Uruguay and others. Would it be possible to check and update?
-
How to have separate data table for a new version of the form?
Hi All, I created a copy of the form I used so far, to ask a bit different questions and to collect the data in a bit different way. After the pilot stage I want to decide which version 1st or 2nd of the form will be used as the final version. But I see that the data punched into this 2nd version of the form are collected…
-
Contact list in forms
My sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options. I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of available options - but the same feature is not available on through a form. Is there a…
-
Can we apply rules to repeat form use?
Hi, I have created a sheet to collate feedback on the completion of projects. I've added a copy of this sheet to each project I have, and then set up automation so that each submission feeds into a Master Sheet for PM's to review. It's a pretty basic sheet with only 5 columns, but I'd like the facility to repeat the…
-
URL Query String with Dynamic Data Connected to QR Code?
I recently built out an inventory system that generates a custom URL query string for each item that partially pre-fills out a form to check items in/out of inventory. The form is meant to include a "current stock level" value so the person knows how much they are able to check out of inventory, but the team using it wants…
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
Notification When Forms NOT Completed
I'm trying to set up a notification that goes to a manager each Monday morning informing him which technicians have not completed a vehicle inspection report the previous week. The link to the form is emailed to each technician Monday morning (eg April 15). They open the form, select their vehicle number from a dropdown…