Skip to main content
Nintex Community Menu Bar
Solved

Update smartsheet from Nintex Bot

  • March 31, 2023
  • 5 replies
  • 89 views

schristenson
Forum|alt.badge.img+1

I’m building out actions on bots to automatically update a smartsheet.  I have a few questions on how to make this more automated. 

  1. 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?
  2. 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.
  3. 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 schristenson

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.  

5 replies

Sasan
Nintex Employee
Forum|alt.badge.img+11
  • Nintex Employee
  • March 31, 2023

@schristenson Hi, can you tell us a bit more on upstream event that requires an addition to the sheet?  Want to know if it can be fully automated without a user attending to it or the automation starting point has to be attended by a user. 


schristenson
Forum|alt.badge.img+1
  • Author
  • Novice
  • March 31, 2023

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.


Sasan
Nintex Employee
Forum|alt.badge.img+11
  • Nintex Employee
  • March 31, 2023

@schristenson 😁 ok, let us know if you need help targeting the submit button.


schristenson
Forum|alt.badge.img+1
  • Author
  • Novice
  • Answer
  • March 31, 2023

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.  


Sasan
Nintex Employee
Forum|alt.badge.img+11
  • Nintex Employee
  • March 31, 2023

That’s fantastic and glad that you are all set.