Brady
My feedback
-
29 votesOpen for voting · 5 comments · 5 - Nintex Workflow Cloud » Workflow Designer · Flag idea as inappropriate… · Admin →Brady
supported this idea
·
-
24 votes
We’re reviewing this request internally.
Brady
supported this idea
·
-
41 votes
Thank you for your votes and feedback. We are now going to plan for supporting this capability.
Brady
supported this idea
·
-
5 votes
This is currently planned where the Convert a value action will be extended to support string to date.
An error occurred while saving the comment -
9 votesOpen for voting · 3 comments · 5 - Nintex Workflow Cloud » Workflow Designer · Flag idea as inappropriate… · Admin →Brady
supported this idea
·
An error occurred while saving the comment Brady
commented
If that kind of a filter was at least available for the "get a row" action, that would be very helpful. I say "get a row" because I'm not always needing to update something in Smartsheet, but instead just checking if a row is present that meets the criteria. In my original use case, it depends what information I need. If I need to get the entire row or the row id, usually it's looping through each row until I find the one that has the value in a specific column(s) that indicate it's the one I need. That involves knowing the ID of the column you're looking for.
If I need to get a specific cell from a specific row, I still need to do the above steps, but once I have the row I also need to find the particular cell in that row with the desired column id, and get the value (or Display Value) of that cell.
I did realize this can be made much easier with the "Query JSON" action, when using the results from a Get Sheet web request action. (Unfortunately, I can't use my custom Xtension "Get Sheet" action because Nintex always seems to throw slashes before quotes in the results, making it an invalid JSON format....)
$.rows.[?(@.cells..value=='SEARCH VARIABLE' && @.cells..columnId== SEARCH COLUMN ID)].cells.[?(@.columnId== DESIRED COLUMN ID)].value
The above returns the value of a specific column from each row in the sheet that has a specific value in a specific column. This kind of functionality would be awesome if it was built into the existing actions.
An error occurred while saving the comment Brady
commented
Recently, the Smartsheet connector added the "Add a row" and "Update a row" actions, which is awesome! It would be great if we also had the "Get Sheet" action. Right now, there's a "Get Sheets" action, which I believe will return a list of sheets, but not the sheet's contents and rows.
If I wanted to find and apply an update to a row in a sheet, normally I'd follow this set of steps:
1. If not known, determine desired Sheet ID by using "Get Sheets" action and looping through sheets until desired sheet is found, then store the ID
2. Use the Sheet ID to get the contents of the sheet. There is no "Get Sheet" action, so this must be a Web Request or custom Xtension.
3. Loop through rows of sheet return in step 2 until desired row is found, then store the ID of that row.
4. Update the row using the "Update a Row" action.Step 2 is the only part that actually interacts with Smartsheet and doesn't have a built in action to support it.
-
11 votesOpen for voting · 0 comments · 5 - Nintex Workflow Cloud » Dashboard Experience · Flag idea as inappropriate… · Admin →Brady
supported this idea
·
-
235 votesPlanned · 3 comments · 5 - Nintex Workflow Cloud » Form Designer · Flag idea as inappropriate… · Admin →Brady
supported this idea
·
-
Feature to do the bulk operation for user registration, import/export into CSV under User Management
26 votes2 comments · 5 - Nintex Workflow Cloud » Dashboard Experience · Flag idea as inappropriate… · Admin →Thank you for your idea. Opening this idea for voting by other users.
Brady
supported this idea
·
-
2 votes
Thanks for your idea. Opening this for voting.
Brady
supported this idea
·
-
219 votesStarted · 15 comments · 5 - Nintex Workflow Cloud » Dashboard Experience · Flag idea as inappropriate… · Admin →Brady
supported this idea
·
-
6 votesBrady
supported this idea
·
-
1 voteOpen for voting · 0 comments · 5 - Nintex Workflow Cloud » Connectors · Flag idea as inappropriate… · Admin →Brady
shared this idea
·
-
6 votes
Looking into this...
Brady
supported this idea
·
-
3 votes
Great feature suggestion, thank you!
Brady
shared this idea
·
-
24 votes
Although we’re providing an update to the smartsheet connector this month, it unfortunately doesn’t include Start Events.
We’re monitoring this item further to see if we’ll add this support in the future.
Brady
supported this idea
·
-
8 votesOpen for voting · 1 comment · 5 - Nintex Workflow Cloud » Xtensions · Flag idea as inappropriate… · Admin →Brady
supported this idea
·
-
44 votesPlanned · 3 comments · 5 - Nintex Workflow Cloud » Connectors · Flag idea as inappropriate… · Admin →Brady
supported this idea
·
-
15 votesOpen for voting · 1 comment · 5 - Nintex Workflow Cloud » Workflow Designer · Flag idea as inappropriate… · Admin →Brady
supported this idea
·
-
6 votesOpen for voting · 0 comments · 5 - Nintex Workflow Cloud » Workflow Designer · Flag idea as inappropriate… · Admin →Brady
shared this idea
·
Just curious on the upcoming implementation of this as part of the "Convert a value" action.
Will this conversion involve specifying what time format and zone the string represents? If so, can it account for Daylight Savings Time? Currently, when referencing datetimes in a workflow, those will fluctuate by an hour if you observe DST. This requires manually editing and republishing the workflow to adjust for that hour. If this feature could provide a way around that, that would be great.