Set a value of a field, that is calculated, based on field value of related Lookup Object (SF Import

  • 27Views
  • Last Post 13 December 2018
0
votes
Ivo Dimov posted this 10 December 2018

Hi, 
I am trying to upload a file that will create cases in Salesforce. I would like to set up the Status field with a value that would be derived from a related record. For example, if my related record Status = "Red", then my case status = "Apple". If related record Status = "Yellow", then Case Status = "Banana". I tried using Target Lookup, but I can only set the Result Column with the actual value of the field I am referencing, and I would like to perform a calculation from that field and pass it on to my Status.I could potentially build that logic in Salesforce, but is that possible with Skyvia?

 

Thanks

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 12 December 2018

Currently it is impossible to do, however, this functionality is on our roadmap. We will post here the results as soon as any are available.

 

Best regards,

Mariia

0
votes
Ivo Dimov posted this 12 December 2018

Thank you so much for the feedback. Would you happen to have any timetable on when this feature could potentially be available? 
Thanks

0
votes
Mariia Zaharova posted this 13 December 2018

 Unfortunately, we can't tell you any timeframe for this functionality at the moment.

I will definitely inform you when any news is available.

Close