Oct 12 2020 09:42 AM - edited Oct 12 2020 09:47 AM
Where are the custom fields stored for the past services? Are there any reports I can run to generate these info? Thanks.
Feb 08 2021 05:35 PM
Mar 05 2021 06:51 AM
Mar 09 2021 01:40 AM
Mar 09 2021 09:21 AM - edited Mar 09 2021 09:22 AM
@ddmurrayjrYeah just had a look back through some of my older calendars and some have and some haven't. When they get it though the fields are:
Date Time
Customer Name
Customer Email
Customer Phone
Customer Address
Staff
Service
Location
Duration (mins.)
Pricing Type
Price
Currency
Cc Attendees
Signed Up Attendees Count
Text Notifications Enabled
Custom Fields
Event Type
Booking Id
Jul 21 2021 09:45 AM
Jan 21 2022 04:14 AM
@Kimberly_Huffman Thanks a lot for the documentation. It helps a lot.
The only challenge i have is that it doesnt work with the customs fields. I think the problem is CRLF between the the question and the answer. Any idea how i can get this into the function?
Calendar Event:
Benutzerdefinierte Felder
----------------------
Frage 1–Geburtsdatum
Antwort – 1.12.2021
Frage 2–Ausweisnummer
Antwort – 0
Current workaround:
trim(last(split(first(split(outputs('HTML_zu_Text')?['body'],'Frage 2')),'Frage 1–Geburtsdatum')))
The problem is that the return is --> "Antwort – 1.12.2021"
I tried to use substr, but that doesnt work....
Jan 23 2022 01:19 PM
Jan 23 2022 02:47 PM
@ddmurrayjr update to the export function did finally show up, and I run it through a json transform to pull out the custom fields; works like a charm!