-
Wildcard Email Address In Form
I currently have a form with a contact list field that allows multiple email addresses. Because of this, users can input values that are not email addresses. It is possible to validate a contact list field that allows multiple email addresses? If you can't, is it possible to input a wildcard so that field requires the…
-
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
-
Where is the "today" default date for forms?
In this updated version of SS I don't see the option for "Today" on the calendar. Has this feature been moved or disabled?
-
Applying a formula for the whole column
Hi! I currently have a formula for a specific cell in a row. I would like to apply that formula to all cells in the same column. I tried dragging the formula down as far as I can go, but when a new row is added from a form, it seems to add way down my sheet (not consecutively after the last entry) and the formula is not…
-
Form drop down selection query
Hi, Is it possible to create a form based off a sheet where you can select an entry already in the primary column which would then allow you to update specific other columns? I would like to have a form where I can select an entry in T Number column, then update Cal Due, In Cal checkbox and comments columns. Is this…
-
Form logic is not working
I submitted to tech support 5 days ago when discovered this and still can't get answers. I have built many many forms in the past however the logic is now not working. I dumped the form and started fresh however still has same issue. Logic is that when customer name is blank only Lot-Unit-Development should show however as…
-
Suppress Parent Row info viewing in Update request?
Users (in a child row) that roll-up are able to see private information (in the parent row) when selecting "Send copy of my response" in update request web form. Is there a way to either limit that view or disable the option for users to "send copy of my response" when completing the automated update request? When users…
-
Form Submitted but never shows up in the sheet
We had a customer submit a form on May 12, 2023 that never populated in our sheet but the submitter received a copy of data they submitted. We've reviewed the history and don't see anything on May 12. We've combed through things carefully and can't find a reason, which is unsettling. How likely is this an issue on our end…
-
Help creating formula to update inventory automatically
The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula that automatically subtracts 100 from Spanish Qty each time the Request Completed is checked, the Request Denied column is…
-
Forms - Heading/Description
Is there a way to apply formatting to a Heading / Description field in a form? In the Description area, it looks like you can apply formatting (Bold, Underline, font color, backgroung, etc...) However, when I change these values, I don't see where this is reflected on any of the fields. As you can see in the screen shot…