David Murray 2 Posted March 3, 2020 Posted March 3, 2020 I am told that it is possible to add some conditional logic to a Lookup step inside Scribe Online. It appears that you can drag an if/else block below the Lookup but it isnt clear how to write the formula. Has anyone been able to get this to work
Nick Roelandt Posted May 19, 2020 Posted May 19, 2020 Hi, You can determine your own logic/formulas here. What do you want to achieve exactly Nick
Ash Arendsz Posted June 1, 2020 Posted June 1, 2020 A common pattern used in Scribe is this:(see attached Sample) Do a lookup and right after the lookup, add an IF /Else block to determine if that particular record lookup, was successful or not. You can add as much lookups and If blocks as you need to determine the exact results and actions needed in your App Flow design logic. Result.RecordsMatchedcan have three results: match = 0 ; no match found, in that case the lookupfields are set to NULL, (no use to keep using these resultsets as it will most likely generate errors in the next lookup or update block.)Sometimes this is what you expect in order to do an alternate lookup (i.e. lookup account, if account not found, lookup contact.) match =2 ; meaning multiple matches have been found, this is usually also not a good result, since you will need to use a Fetch block to loop thru all the different match results. (a lookup only shows one resultset, no matter how many matches you have.) match =1 ; usually this is what you expect from a lookup result and this asserts you that your data is ready for the next step in the integration.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now