Import Data fails with set variable validation

Import Data fails with set variable validation

Hi,

In my app (app name PIM), I currently have a form called 'Categories', which has the following fields:

Root Category
Child Category
Grandchild Category
Website Category     

I want to be able to import this information and set the Website Category automatically based on the following formula:

  1. Website_Category=(((input.Root_Category + if(((input.Child_Category).length()  =  0),"","/")) + input.Child_Category) + if(((input.Grandchild_Category).length()  =  0),"","/")) + input.Grandchild_Category;
I have tried to implement this using two methods:

  1. As a formula field - When I do this, the formula does not get updated when I import and there are multiple blank values in the field.
  2. Using On Add -> Validate as a set variable script but the deluge validation fails.
I have allowed edit access to support and would be grateful if you could assist me.

Thanks

Shaheed