-
HTML functionality to pre-populate forms
I am working on a solution that requires 30 fields (see illustration #1) to be pre-populated with information. The information that is being populated in the fields is also pretty lengthy. I am running into what looks like a character limitation with the final fields (see illustration #2). I have checked the character…
-
Formula or Automation to Indent Rows from Intake Form?
Is it possible to set up a formula or automation with helper columns in a sheet so that if a box is checked (or some other designation that could be done from an intake form…) it can indicate that a task is a sub-process of a larger task and be indented to indicate that relationship? Trying to find a way around manually…
-
Can you insert a URL Link into a form
I am wanting to put in a form a URL Link instead of an attachment. Is there a way to do is?
-
Creating unique participant IDs
Hi all, I am looking for a way to generate unique IDs for individuals filling out forms. We have a number of events for which we have made registration forms. When a person fills out a form, we would like to have the corresponding sheet automatically generate a unique ID for each person that is de-identified. Is there a…
-
API to modify FORM "Label"
I have to update 250 form labels on a single form. Is there ANY way to do this automatically? I am dreading doing this manually :) There doesn't appear to be any API functionality for forms according to the documentation. Am I just overlooking something or is this not possible? Thanks!
-
A way to archive forms?
I have a sheet where I track sign-ups for different types of interactions (different topics, dates, overall purpose, etc.). When I go to the manage forms section, I have to scroll through to find ones created earlier that are still in use (signing up for a consultation vs the forms for signing up for a one-off event). Is…
-
Merged: forms setup option, retain the last entry
This discussion has been merged.
-
How can I apply logic to a few drop downs in a form without having to apply logic to all options?
I am trying to do conditional logic where I have 35 different manufacturing plant locations and 5 of them are Canadian. The first dropdown I have is for them to select a location, and I want to have conditional formatting for the Canadian plants so that when they enter the dollar amount they get the Canadian dollar box. I…
-
Is it possible to have a multiple line entry using a form?
This could be far-fetched, but is there any way to set up a form to where you can fill it out like this screenshot below? Where it is more than 1 line entry without having to enter 100 different submissions? Currently people email me this excel every week and I have to copy and paste it into a different excel sheet.…
-
Showing Pics or Icons for Drop Down Options
This may be a stretch, but I vaguely remember attending a SmartSheet Webinar where the guest customer speaker had drop downs that were actually pictures vs. words. When asked to explain how to create a drop down like that, he showed how he created a "letter type" or "font"(?) that was the picture and then was able to use…