Skip to main content
Nintex Community Menu Bar
Solved

Update smartsheet from Nintex Bot

  • March 31, 2023
  • 5 replies
  • 40 views
  • Translate

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.  

View original
Did this topic help you find an answer to your question?

5 replies

Sasan
Nintex Employee
Forum|alt.badge.img+11
  • Nintex Employee
  • 130 replies
  • 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. 

Translate

schristenson
Forum|alt.badge.img+1
  • Author
  • Novice
  • 2 replies
  • 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.

Translate

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

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

Translate

schristenson
Forum|alt.badge.img+1
  • Author
  • Novice
  • 2 replies
  • 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.  

Translate

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

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

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings