-
URL String Query for Column Type: Contact List
Hi Smartsheet, I'm trying to help a few new users within my organization by prepopulating a couple fields in commonly used forms with the use of URL String Queries. So far I can seemingly prepopulate almost all fields in a form, but the hurdle I've come across is when the column type is a contact list. The drop down values…
-
Auto populate a form offline with multiple layers
Hello, I run a cookstove project in Africa. We need our field staff to inspect the stoves regularly. Each staff member has their villages to manage. And each of their villages have approx 200 houses. When checking the stoves, we need the user to select their village on the Smartsheet form. It is easy enough for each user…
-
Use a URL query string to prefill and submit a Form
Hi, I've successfully followed the steps here to prefill a form, but I also need this to submit the form. My ultimate goal is to create a staff attendance tracker where we can use specific QR codes for each staff member to scan when they arrive at meetings. By scanning the code, we'd expect it to fill and submit the form…
-
URL Query report options
Create query endpoints for reports so a link can auto filter a sheet when the URL is clicked to do certain things. This would make it much easier to manage reports for weekly/monthly/quarterly, and many other things. In my use case, this would simplify how many separate reports are needed. Below is an example of what could…
