We have a challenge with our online bookings form which integrates with Zapier and we hope the community can help with this.
- we receive bookings via phone calls, emails and online booking forms.
- All bookings are recorded in Google Sheets
- Each booking is assigned a unique booking ID which is alphanumeric eg. ABC230101
- We would like all bookings received from the online booking forms to automatically generate the next booking ID in the sequence i.e. ABC230102 and populate Column B in our Google Sheet.
- We’ve looked at Formatter and Storage by Zapier however, none of these are working for us.
- With Formatter, we tried the INDIRECT function from Excel/Google Sheets however, it seems this is an unknown function for Zapier.
Any help in resolving this would be much appreciated.
Best answer by nicksimard
View original