Pre-populate Web form with info from Dashboard

Hi everyone, here is what I'm trying to do:

I want to create a dashboard with links to web forms when doing on-site audits. These links will be different sections of items being audited. When I encounter an issue, I would click on the link, fill out the form and then keep going with my walk-through. These forms would be compiling the data into sheets, which would be multi-projects.

(The dashboard is basically just a way of presenting the sheets and not having to go back and forth while on-site. Reports can be run later if I need to have info summarized by projects.)

So each project would have a Dashboard (copied over from the template so links are good).

What I want (finally I'm getting there :-) ) When I get to the form, I would like the Project Number, Project Name being pre-populated. (If I get a lot of deficiencies, I don't want to type this info again and again...)

Any thoughts on how I can achieve this? Thanks

Find more posts tagged with

Construction

Comments

Andrée Starå

Hi,

You could add it to the form and hide the field, or you could add the information in the link to the form.

Which method would you prefer?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

benolecl

Thanks Andrée.

The "thing" is not built yet... But here are a few snapshots that should explain better...

My Sample Dashboard would contain the Links. (In my example, House Keeping and PPE). Clicking on them, would bring the form (which I want to be pre-populated with the job number and name and Today's date.)

These forms would fill out the associated sheets. The House Keeping sheet would contain issues from any jobs. When I need to go to a new project, I would create a copy of the Dashboard, update the widget with Name and Number and I would be good to go.

Your suggestion about passing the info in the URL itself seems good for what I want. Any idea where I could get more info on how to do this?

PrtScr capture_2.jpg

PrtScr capture_5.jpg

PrtScr capture_4.jpg

PrtScr capture_3.jpg

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.