I have two columns
I have the logic but I don’t know how to do it
Not totally sure what the goal is, but a good rule of thumb is to check all the false conditions first, and then handle the true case. Sometimes nesting if else blocks may help get what you want.
Can you tell me how can I get desired output?
So you want the value of ‘Template 1’ returned from the ID array if something finds ‘Account Number’ in the Keyword array, because they are both in position 1 in both arrays? How are you determining that something is found in the Keyword array? Are the array items always in a consistent order? Where are the Lookups coming from? I think we need a lot more information to determine what you need. It seems to me that something is being made more complicated than it needs to be.
I have a Templates table that includes all the information related to each specific template. I’m using a lookup to fetch the entire template. Then, I extract all of its IDs and the specific keywords associated with it.
Each template has unique keywords — for example, a keyword in Template 1 won’t appear in Template 2 or 3. What I want to do is create a conditional statement. For instance, if the detected template is Template 1 and it includes the keyword “Account Number”, then a specific action should be triggered.
So, I’m trying to figure out the best approach to implement this logic. What would be the most effective way to handle this
I think that just confused me more. I’m not understanding the entire flow and what the data looks like.
Thanks for the help guys, I have got it working using a json Object and then using javascript
