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.