You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In getting this data ready for Jethro import I've resorted to a custom function in google apps script, which looks within column X for occurrences of the phrase Y, and if so puts value Z for Jethro to digest (usually in a 'group' column).
To make it easier for others, Jethro could do this logic for you.
You'd include the untransformed comma-separated data in a column
and set a special column header like this: group[Morning Tea Volunteers 2025]if{Morning tea}
(Interpretation: If the value contains "morning tea", add them to a group "Morning Tea Volunteers 2025")
More sophisticated version group[Men's Ministry Team]if{men's}not{women's}
The text was updated successfully, but these errors were encountered:
When you set up a google form with a "checkboxes" question like this:
then the resulting google sheet has a column with comma-separated values such as
In getting this data ready for Jethro import I've resorted to a custom function in google apps script, which looks within column X for occurrences of the phrase Y, and if so puts value Z for Jethro to digest (usually in a 'group' column).
To make it easier for others, Jethro could do this logic for you.
You'd include the untransformed comma-separated data in a column
and set a special column header like this:
group[Morning Tea Volunteers 2025]if{Morning tea}
(Interpretation: If the value contains "morning tea", add them to a group "Morning Tea Volunteers 2025")
More sophisticated version
group[Men's Ministry Team]if{men's}not{women's}
The text was updated successfully, but these errors were encountered: