-
Hello - looking for help creating my sign in and out form.
I am fairly new (yet familiar with the possibilities available) in Smartsheet. I am in the process of creating a tracking form for my job to see anytime a device is in use and which employee is in possession of a shared device and what location they are working at that moment. I am collecting the employee's name and ID…
-
Form Validation for Negative / Positive Number
The form validation for "Number" should be enhanced to either allow a positive and/or negative number. We leverage number validation for submitters to enter quantities. This number would never be a negative number, and from a data integrity perspective we cannot simply assume the user intended the positive inverse. It's…
-
Autofilling Forms
Currently we can use querystring parameters to autofill form values (e.g. https://app.smartsheet.com/b/form/18f38f1ef40223457f7afe19cc0beba5d15?Field1=Value1%Field2=Value2) , which is an extremely useful feature. However, for authenticated forms, the querystring values are dropped during the authentication process if the…
-
Forms Question:
Does anyone know: How large can PDF attachments be attached to a form? Can you upload a WORD document, if yes how large can the WORD documents be? Is there a line restriction or character restriction when populating a response within a form? If yes, what is the line/character restriction?
-
Automation / Form(?) Help
Hi, I have created an event data sheet that has six columns (event name, date, attendee and then three other informational columns). The first three columns (name, date, attendee) will be filled in by my marketing department. I need to create an automation that emails the attendee and asks them to fill out a questionnaire…
-
What is the best way to add table like data for user to fill in a form?
I am asking people to complete a form when their salary is split between projects/schools. (1) Name (2) Employee ID: (3) Start Date: (4) End Date: More than 1 project? Y/N *if more than one, I need the following for EACH project and some folks have 5-6 projects (5) Project name, (6) flat amount or (7)% of base salary, (8)…
-
Hidden Fields and Update Requests
Hello! Can someone give me an overview of the most practical application for using a "hidden field" on a form? I was trying to figure out if this would be helpful when I am trying to gather information from a stakeholder after they filled out "Part I" of the form- which we only ask questions about half the data I want to…
-
Dynamic Dashboard Calculator/Model
Hello, I'm still learning Smartsheets and wondering if there's a way to create a dynamic "calculator" type dashboard fused with a form. I am hoping folks can fill out a form live and once submit automatically see the produced outcome, based on the form inputs, on the screen. Is that a possibility? Or is the only option to…
-
Project management template packet- Forms Included
Hello, I have generated a 'Project Management Template Packet' to be re-used by Project Managers each time they begin a new construction project. One important item we use is an RFI Form- used by field personnel to generate 'requests for information', which populate a Smartsheet used internally. This information is then…
-
Intake form/Sheets to Document Builder - Font issues
Hello! I created an intake form that captures data onto a sheet. One of the automations I built out is to create a PDF. However, upon creating - I am having issues with the font size that is being populated. The fillable pdf itself has conditional formatting on font size. The smartsheets sheet itself has a formatted font…