I have a field named Postcode Area which is type formula and has nested IF statements.
Is there any way to add a second action to an IF statement such as:
IF (A=B, (action 1 & action 2), action 3)
I would like to take the value that is returned from the IF statement and paste it into another field within the same table so that I can use it in another lookup.
If there’s no possible way to do that in the IF statement, is there another way to duplicate the value of Postcode Area into another field?
I have done this successfully with a script but I don’t know of a way to trigger the script when a form is submitted.