-
Data validation
How about adding "number only" or "text only" options to the data validation?
-
Prefill a form response from another sheet
I have a project tracker sheet and am trying to set up a flow to send a survey via a form once the status of the project is changed to complete. I would like the survey to prefill with the project name from the source sheet, of the project that was changed to closed. Is this possible? The form results (survey results)…
-
Contacts: Form vs. Grid
Hi - I have a sheet that then has a form attached. When people need something added to my sheet (which we call the 'tracker') I have them use a form. There is a 'Lead' column that is a contact list. When people fill out the form, they select their name from the contact list and it goes into the tracker. However, it…
-
Is there a FORM ID?
I have multiple forms that can be used to submit data to a worksheet, and I'm wondering if there is a FORM ID that could be used in a column so I know which form was submitted. If yes, is there a specific formula I can use in a column to identify the Form ID and Name of the form?
-
Is there a way to see the emails that a form was sent to?
Is there a way to see which emails a form was sent to? It would be great is it's a list of emails that a form was sent to. And who has answered to the form.
-
Table in Forms
It would be extremely helpful to be able to add a data table to a form. I need to be able to ask users to provide details about, for example, grazing in multiple paddocks. My table would look like this: Column 1 Header: Paddock No. Column 2 Header: Crop Type Column 3 Header: Area Please add this to the list of development…
-
Font size
It would be helpful to have the ability to change the font or increase font size in my report and on my forms.
-
Form Submitting Error when attempting to submit with an attachement
Several in my company are expereincing this issue. They can submit the form without the attachment but cannot with the attachement. The file is located on their desktop and is an excel .xlsx file less the 50kb. Have tried this in Chrome and Edge without success and cleared the browsers. It was working yesterday for one of…
-
Allow ISO 8601 Date format for dates (YYYY-MM-DD hh:mm:ss)
ISO 8601 is an international data standard and a part of two national standards in the United States. "The standard provides a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting numeric dates and times when such data is transferred…
-
Auto fill form for status updates
Hi, I am creating a form for our weekly status updates so we can see the history. However, it would be useful to have default values pre populated in the form from last week's update so the PMs can update it instead of writing it again - if applicable. This value needs to be pulled from a sheet based on the region/function…
