2 Replies Latest reply on Apr 13, 2016 5:04 AM by sbruyere

    list to form view by condition

    sbruyere

      Hello,

      I'm trying to do a script to pass from the list view to the form view of a record but depending of the information in a specific field, it will go in a different layout.  I did it by doing a "IF" and in the calculation I selected the field name = "data".  But this "data" can be a list of about 30 items divided in 2.  Half of them start with a D and the other half start with a P. 

       

      What calculation can I do to consider only the 1st letter of the information in that field.  I already tried "d*" but it doesn't work.