My company uses Acuity Scheduling to schedule appointments. Right now, the Acuity Appointment Type field has two sets of data in it, separated by a colon. For example, “Room 1: 3 Customers.” I would like to use Zapier to update an AirTable database that has separate fields for “Room” and “# of Customers.” Ideally, Zapier would identify the Acuity reservation being made, “Room 1: 3 Customers” and put everything before the colon into the AirTable “Room” field and only the numeral after the colon into the AirTable “# of Customers” field. Is there a way to have Zapier process the reservation as a colon-separated (or -delimited) field?
Best answer by Danvers
View original