Hi  - Trying to meet a requirement in a Flow to remove/show fields with conditional visibility. 

I'm running into EXPECTED BEHAVIOR (See article (https://help.salesforce.com/articleView?id=flow_considerations_design_conditional_visibility.htm&type=0)), but I need a workaround.

ISSUE
When a field is HIDDEN on a screen component because of Conditional Visibility, 3 scenarios occur:

• Boolean field is HIDDEN, value is FALSE; Flow sends EMPTY STRING. Result: Flow error, data type mismatch
• Boolean field is SHOWN, value is FALSE; Flow send NULL. Result: Good.
• Boolean field is SHOWN, value is TRUE; Flow sends TRUE. Result: Good.

Solution #1:
Created a Flow FORMULA to evaluate the boolean field  - (IF(NOT({!Field}),TRUE,FALSE)

• Scenario 1: Boolean field on record is TRUE
  • Result: INCORRECT field value. Should be FALSE
• Scenario 2: Boolean field on record is FALSE
  • Result. Good.
• Scenario 3: Boolean field on record is TRUE
  • Result. Good. 

Soltuion 2 - this is CRAZY
Created a Flow FORMULA to see if the value from the screen field is EMPTY STRING, and if it is,  then convert to NULL. 
IN SUMMARY:

• I need Conditional visibiliy to meet requirement
• When a field is HIDDEN as expected, it send EMPTY STRING
• When I use formulas to convert it to FALSE, I get two wrong outcomes
  • 1: Sets it to the oppositve of the value needed for boolean
  • 2: if checking for EMTPY STRING, hits error reflecting wrong data type.

SCREEN SHOT 1 - FIELD HIDDEN - SENDS EMPTY STRING


SCREEN SHOT 2 - FIELD SHOWN, BUT BLANK - SENDS FALSE


Here's the "Make Known" criteria in the screen.


Help! What is the best workaround if you do, in fact, need to make 20+ checkboxes visible or hidden based on 7 distinct use cases?

Hi  - Trying to meet a requirement in a Flow to remove/show fields with conditional visibility. 

I'm running into EXPECTED BEHAVIOR (See article (https://help.salesforce.com/articleView?id=flow_considerations_design_conditional_visibility.htm&type=0)), but I need a workaround.

ISSUE
When a field is HIDDEN on a screen component because of Conditional Visibility, 3 scenarios occur:

• Boolean field is HIDDEN, value is FALSE; Flow sends EMPTY STRING. Result: Flow error, data type mismatch
• Boolean field is SHOWN, value is FALSE; Flow send NULL. Result: Good.
• Boolean field is SHOWN, value is TRUE; Flow sends TRUE. Result: Good.

Solution #1:
Created a Flow FORMULA to evaluate the boolean field  - (IF(NOT({!Field}),TRUE,FALSE)

• Scenario 1: Boolean field on record is TRUE
  • Result: INCORRECT field value. Should be FALSE
• Scenario 2: Boolean field on record is FALSE
  • Result. Good.
• Scenario 3: Boolean field on record is TRUE
  • Result. Good. 

Soltuion 2 - this is CRAZY
Created a Flow FORMULA to see if the value from the screen field is EMPTY STRING, and if it is,  then convert to NULL. 
IN SUMMARY:

• I need Conditional visibiliy to meet requirement
• When a field is HIDDEN as expected, it send EMPTY STRING
• When I use formulas to convert it to FALSE, I get two wrong outcomes
  • 1: Sets it to the oppositve of the value needed for boolean
  • 2: if checking for EMTPY STRING, hits error reflecting wrong data type.

SCREEN SHOT 1 - FIELD HIDDEN - SENDS EMPTY STRING


SCREEN SHOT 2 - FIELD SHOWN, BUT BLANK - SENDS FALSE


Here's the "Make Known" criteria in the screen.


Help! What is the best workaround if you do, in fact, need to make 20+ checkboxes visible or hidden based on 7 distinct use cases?

good morning,

 

I'm trying to create a number formula field where we rank cases based on 2 fields:

Budget__c and Queue_sort_order__c (which is another formula field)

 

if a budget is over 20000, then we want to calculate the number given by Queue_sort_order__c by 10% (and add it to the current value in that field), if it's between 10001 and 20000, then calculate the queue_sort_order__c by 7.5% and add to the current value in queue_sort_order_c field, etc.

 

if(Budget__c > 20000, (.10  *  queue_sort_order__c) + queue_sort_order__c,
if(and(Budget__c > 10000, Budget__c<20001),  (.075  *  queue_sort_order__c) + queue_sort_order__c,
if(and(Budget__c > 5000, Budget__c<10001), (.05  *  queue_sort_order__c) + queue_sort_order__c,
if(Budget__c < 5001, (.025  *  queue_sort_order__c) + queue_sort_order__c
))))

 

but the formula is giving a syntax error on the decimal places in the formula ("." on .10, "." on .075, etc)....is there another way to express percentage in the arithmetic formula

(formula field output will have no decimal places)

 

thanks