Forum Discussion
Solved
Extracting custom fields from bookings
Hi trying to setup a booking system for customers attending a site. Due to social distancing, we have to limit the number of spaces available and we have successfully manged to set this up using boo...
AndyfF360 I was able to extract custom field data successfully using Power Automate so in case you have future needs. Karine2411 , sagark92 , maynarp , topcat437 , Steve_Prentice in case you are interested.
Flow Description
This flow runs nightly and extracts user data from events located in a custom account calendar (this account is being used by the Bookings app to schedule appointments) then creates a CSV file stored in a Shared Documents team library. Attached are the details of my solution.
Hope this helps!
~Kimberly
As an update, since the 'old look' of Bookings has been replaced with the 'new look', the Export button is no longer found on the homepage of Bookings. Now, you must go to your chosen Bookings Page, then the Bookings Calendar tab for that page - you will find the Export button on the top-right of the page above the calendar display.
When you export, you define the date range (I've found this to be buggy, as it lists bookings being made on dates that don't add up, so allow for it to search into the past and future around the dates to be sure you capture them!?).
You can open the .TSV with Excel, and you can see responses to custom fields here as well.
When you export, you define the date range (I've found this to be buggy, as it lists bookings being made on dates that don't add up, so allow for it to search into the past and future around the dates to be sure you capture them!?).
You can open the .TSV with Excel, and you can see responses to custom fields here as well.