Skip If Condition

  • 15Views
  • Last Post 2 weeks ago
0
votes
Stefanie Rankl posted this 2 weeks ago

Hi,

we currently use the If condition to select a checkbox if the value of a field is correct. Unfortunately, we need a way to skip the condition. 

 

Example:

 

We have the following import csv:

CustomerNumber | Product

Row 1  112                          | 1

Row 2  112                          | 2

Row 3  112                          | 3

 

For every product i have a checkbox on the account in Salesforce 

If i now use the condition Product=="1"?True:False the first row will check the checkbox for the checkbox product 1 on the account, the second row 2 will uncheck it, because the condition is false.

Is there any way to skip the false?   

Regards

 

 

 

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 2 weeks ago

Hello Stefanie,

 

Thank you for contacting our Skyvia Team.

 

Unfortunately not, there is no possibility to skip the false. The conditional operator always returns two arguments: one for True and one for False.

 

Best regards,

Mariia 

0
votes
Stefanie Rankl posted this 2 weeks ago

Hi Maria,

thank you for your answer. Unfortunately that's not the answer I wanted to hear ;-)

Do you have another idea for my problem? 

I need a possibility to keep the target field unchanged if the source field doesn't contain a specific value.

E.g. target_field==true.

Then I import the data and the condition is: if source_field==1 then target_field== true else do_nothing. Because at the moment the result is for source_field != 1 that the target_field switches to false if the condition is not met. But it should not be changed.

I know that won't work with the conditional parameter but is there another possibility?

Thanks in advance for your support!

Best regards

Stefanie

0
votes
Mariia Zaharova posted this 2 weeks ago

Hello Stefanie,

 

 

Thank you for your reply.

 

We understand your scenario and the expected result. Unfortunately, we cannot advise you on any solution for this case for now. However, we will investigate possible solutions and if we find any we will definitely inform you.

 

Best regards,

Mariia 

Close