Use buttons to add lines to a sheet (like a tick sheet)
Id like to build digital "tick sheets" in our production environment very similar to how airports gather satisfaction data with the "happy face" "sad face" buttons in a bathroom.
If we use that as an example, Id like to be able to have a dashboard/portal with a happy face and sad face button. Each time one of those buttons is pushed id like it to create a line on a sheet that has a time stamp and a value (say 1 for happy, -1 for sad) and id like to be able to do this on a tablet. Is there a way to do this? maybe using forms?
Answers
-
Hi Kevin,
Does it have to be a one touch solution?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Ideally yes it would be a 1 touch solution.
-
I can solve it in two! Is that ok?
I'll get back to you if I have a solution for one. 😉
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you! Do you know if there is a way to default fields to what was entered previously? That may help here as well :)
-
@Kevin Ikeda Happy to help! Can you explain more in detail what you mean?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
In a form if someone enters information (ex. part number xyz, and location AB) and hits submit. Then person 2 comes along and has a new part number 123 but the same location AB, they just change the part number and hit submit. The third guy entering the form now sees part number 123 and machine AB as the defaults which is what he needs and just hits submit. I dont want to to default to the same value every time, just to the last entered value if that makes sense.
Is this possible?
-
Ok.
Unfortunately, it's not possible.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives