Advance Mapping Only perform mapping when:- (Checkbox exception case)

Yash Kumar Salesforce Integration Whiz NetSuite Integration Whiz

• November 08, 2022 12:42

Hello All,

This feature allow us to define when a mapping should be performed without using handlebars. The offered options are:-

Perform mapping while:-

• Creating a record.
• Destination record being updated does not have a value for this field
• Source Record has a value
• Updating a record.

Note -  From my observation, The option "Destination record being updated does not have a value for this field" will not be applicate to destination checkbox fields As a checkbox always carries a value (either True or False).

 

 

 

0

• 

  Courtney Jordan Experience Strategy & Design Director Community moderator

  • November 08, 2022 17:28

  

  

  

  Hi Yash Kumar,
  Thanks for providing this feedback on how we could improve the user experience! I've moved this post to our main Troubleshooting custom flows section, and have let the PM in charge of mapping know about this issue.

  0
• 

  Scott Henderson CTO

  • November 08, 2022 20:51

  

  

  

  Yes, in theory every checkbox field should always be true or false.  That said, there are systems/applications out there where a checkbox field can be undefined/empty/null until someone explicitly sets a value for it.  One example is when you define a new checkbox field for an existing database schema where there is already a bunch of data/rows, and then the checkbox field will be empty for all the existing data/rows until you set a value for it via a separate update query.  Another example is when you add a new custom checkbox field to an application like NetSuite (i.e. or any application where you can define custom fields), and then unless you run a mass update to set the field to an initial value, it might be empty for existing records.

  0

Please sign in to leave a comment.