Hi,
I’m a relatively new Grist user, and a basic one at that (as in zero Python skills)! I’ve been looking at Trigger Formulas to help clean up data being entered into a table using a form but can’t work out how to string more than one formula together.
To try and explain, I want to make sure that when names are entered (first name and surname in two separate columns) they are converted to title case and have any leading or trailing spaces removed.
I’ve found the right formula for each case (value.strip()
to remove spaces, and value.title()
to convert to title case), but I can’t work out how to apply both to a single column.
Am I missing something really obvious, or is it just not possible?