I’m trying to create a new row in my data base only when the row doesn’t exist. In other words, I want to search for 3 conditions if condition 1, 2 and 3 are all met . I want the next work flow to be edit that row.
However, if conditions 1,2 and 3 do not exist create a new row. Can anyone help me accomplish this
Have 2 workflow actions, 1 that will create the thing if it doesn’t exist, and another that will modify it if it does…
Create a new Entry (with a conditional to only run if an entry doesn’t already exist - use ‘do a search for’ with constraints to match the required fields, then count is 0).
Make changes to a thing (with a conditional to only run if the entry already exists - use the same search as above: count>0), and use the same search again: ‘first item’ to select the entry to modify.
Thank you Adam, I did the 1st action with success. I’m working on the second action, editing the row . However I actually want to take the data (row) if it exists and move it to another screen. The Next screen is where I want to display the data and also make edits to this row.
Any advice…
There’s an action called result from step one that I’m unfamiliar with. Can you explain this process in more detail? Can I uses it to find the row and send it to another page or should I do another search and then send it to the next page.
