I’m building out actions on bots to automatically update a smartsheet. I have a few questions on how to make this more automated.
- requires user to sign-on - I created a message interaction to prompt the user to sign-in. How do others handle this? Should I add credentials and have the users that run the bots store their own personal data and then have logic to get network username to match to know which credential to enter?
- finding the correct folder on smartsheet - I’m having issues getting the bot to find and select the correct folder so I’m having another message interaction to have the user select the folder.
- Once it’s on the correct sheet i have the bot adding a new first row then editing to add the details needed for the time savings, then clicking save and exiting.
Best answer by schristensonView original
I switched gears and made a smartsheet form and allowing activity without smartsheet log-in and can enter everything now except hitting the submit button on the form. Getting closer.
I got it now, I kept using the ‘by pass keyboard and mouse’ which then the form thought a person wasn’t entering the data and didn’t allow for submission. I removed that from my actions and am able to target properly to click submit.
That’s fantastic and glad that you are all set.