cgdwn
Nintex Newbie

Save variables from each instance in spreadsheet

Jump to solution

We are a publishing company and I would like to find an instance ID through searching a spreadsheet for saved variables, such as a book title or author name, etc. 

 

Is there a way to set up each instance to insert a new row in a spreadsheet or table document and populate data from the workflow?

 

Thank you!

0 Kudos
Reply
2 Replies
Gavin-Adams
Nintex Newbie

Re: Save variables from each instance in spreadsheet

Jump to solution

Hi 

in nintex workflow cloud there are no actions to be able to query a spreadsheet file once you connect to a storage service to download the file.

 

You could potentially look at web service APIs to office 365 / office web apps to interact with a spreadsheet. However your immediately into coding at the point through web service actions.

 

If you have office 365, easiest option is to create a sharepoint online team site and import the spreadsheet into a sharepoint list. Then use the Sharepoint online actions to query the list for the item based on your workflow variables. Then the get item action to get the values for the item found.

 

Second option is some sort of database table with SQL or MySQL that you can execute a query against.

View solution in original post

Reply
butlerj
Community Manager Community Manager
Community Manager

Re: Save variables from each instance in spreadsheet

Jump to solution

@cgdwn Gavin is correct in terms of what is available in NWC today. However I do know that there has been some discussion around improving the interactability with start variables, and I will definitely take this example back to the PM group as an additional example/use case.

0 Kudos
Reply