Is this workflow possible?

Brad Krause_13404
Brad Krause_13404 Member Posts: 374
5 Up Votes First Comment
edited July 2022 in Workflow Automation #1

Two separate deal details fields: A & B 

A is single option and B is multiple option

Only one of the fields can have a value selected for each deal. 

Is it possible to erase the value of A if B has a value and is it possible to erase the value of B if A has a value set?

Or rather set the value to 'none'? Of the other field.

We wouldn't need two separate fields if it was possible to have some of the selection items in that field be only single options and some be able to be selected as multiple options as part of groups in that field. 

 

 

Comments

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,518
    First Anniversary First Answer 5 Insightfuls 5 Up Votes
    edited February 2022 #2

    I think 2 automation flows should help you do this:

    Trigger: Deal Updated

    Condition: Field A has changed and Field B is not empty

    Action: Clear Field B

     

    Create another automation flow and interchange A and B in the above flow.

    I wonder if there will be a recursive loop, and that is why I added the additional condition to check if the other field is not empty. Worth a try.

  • Brad Krause_13404
    Brad Krause_13404 Member Posts: 374
    5 Up Votes First Comment
    edited February 2021 #3

    I think 2 automation flows should help you do this:

    Trigger: Deal Updated

    Condition: Field A has changed and Field B is not empty

    Action: Clear Field B

     

    Create another automation flow and interchange A and B in the above flow.

    I wonder if there will be a recursive loop, and that is why I added the additional condition to check if the other field is not empty. Worth a try.

    Maybe it's because I am on the workflow Beta I am not seeing an option to clear a field or set it as none.