Hi, thank you for responding.
Basically, I am trying to retrieve feedback form from formstack, at some point i want to filter feedback form from the last calendar month rather than having every feedback form in formstack, then retrieve parts like tour name, tour manager name, departure date, feedbacks and ratings. after that let open ai to generate two type of summaries, one being summary of a single trip, which can have about 10 feedback forms for a single trip (multiple trips in a month), grouped by tour name, tour manager name and departure date. The second summary being summary of a tour package for that month (for instance a tour to France can be held multiple times), which is group by just tour name.
the following is one example of the output from json parser (I manually removed some sensitive data)
{
“value”: {
“submissions”: [
{
“id”: “1354066448”,
“timestamp”: “2025-06-17 15:35:29”,
“user_agent”: “-----6”,
“remote_addr”: “37.-----0”,
“payment_status”: “”,
“latitude”: “4—8”,
“longitude”: “2—4”,
“read”: “0”,
“data”: {
“82919305”: {
“field”: “82919305”,
“label”: "Name ",
“type”: “name”,
“value”: “first = w—n\nlast = l----”,
“internal_label”: null
},
“82919306”: {
“field”: “82919306”,
“label”: “Email Address”,
“type”: “email”,
“value”: “w--ail.com”,
“internal_label”: null
},
“82919311”: {
“field”: “82919311”,
“label”: “Contact”,
“type”: “text”,
“value”: “----”,
“internal_label”: null
},
“82919312”: {
“field”: “82919312”,
“label”: “Departure Date”,
“type”: “datetime”,
“value”: “01 Jun 2025”,
“internal_label”: null
},
“82919723”: {
“field”: “82919723”,
“label”: “Tour Name”,
“type”: “select”,
“value”: “13D10N ITALY SWITZERLAND GERMANY FRANCE”,
“internal_label”: null
},
“82919724”: {
“field”: “82919724”,
“label”: “Tour Manager Name”,
“type”: “select”,
“value”: “REY----”,
“internal_label”: null
},
“82919751”: {
“field”: “82919751”,
“label”: “1. Where did you hear about --------?”,
“type”: “checkbox”,
“value”: “Friends and/or Family”,
“internal_label”: null
},
“82919765”: {
“field”: “82919765”,
“label”: “2. Why did you choose — programme?”,
“type”: “checkbox”,
“value”: “Itinerary(行程安排)\nConvenient Dates”,
“internal_label”: null
},
“82919882”: {
“field”: “82919882”,
“label”: “3. How would you rate our tour programmes? 5 = Excellent; 4 = Good; 3 = Average; 2 = Poor; 1 = Very Poor”,
“type”: “matrix”,
“value”: “Local Tour Guides = 5\nCoach Driver = 5\nCoaches = 5\nTour Manager = 5”,
“internal_label”: null
},
“82920327”: {
“field”: “82920327”,
“label”: “If you take another holiday, would you choose to book with ---- again?”,
“type”: “select”,
“value”: “Maybe”,
“internal_label”: null
},
“82920340”: {
“field”: “82920340”,
“label”: “I consent — to use my feedback for publicity purposes”,
“type”: “radio”,
“value”: “Yes”,
“internal_label”: null
},
“82921436”: {
“field”: “82921436”,
“label”: “Sightseeing”,
“type”: “matrix”,
“value”: “Included Excursions= 4\nOptional Excursions = 2”,
“internal_label”: null
},
“82921454”: {
“field”: “82921454”,
“label”: “Meals”,
“type”: “matrix”,
“value”: “Local = 5\nWestern = 5\nChinese = 5”,
“internal_label”: null
},
“82921459”: {
“field”: “82921459”,
“label”: “Hotels”,
“type”: “matrix”,
“value”: “Comfort = 5\nService = 5\nLocations = 5”,
“internal_label”: null
},
“82921480”: {
“field”: “82921480”,
“label”: “Other Services”,
“type”: “matrix”,
“value”: “Sales Counter’s Service = 5\nBalance Payment Collection = 5”,
“internal_label”: null
},
“82921483”: {
“field”: “82921483”,
“label”: “Overall”,
“type”: “matrix”,
“value”: “Overall Satisfaction = 5”,
“internal_label”: null
},
“119888056”: {
“field”: “119888056”,
“label”: “When will you like to travel again?”,
“type”: “select”,
“value”: “Not sure”,
“internal_label”: null
},
“119888343”: {
“field”: “119888343”,
“label”: “I agree that — may collect and use my personal data, which I have provided in this form in accordance with the Personal Data Protection Act 2012 and our data protection policy available at our website : http—acy to receive information sent by our organisation about our organisation’s products and services, including updates on our latest promotions and new products and services, via the following channels: Email, Text Message and Phone Call.”,
“type”: “checkbox”,
“value”: “I agree to receive communications from -”,
“internal_label”: null
},
“120366729”: {
“field”: “120366729”,
“label”: “Comments if any”,
“type”: “textarea”,
“value”: "Rhine Fall site seeing is very badly plan, is a 2 hours trip to see the waterfall and way back to Germany. this is not making any sense with or without extra charges. is a waste of time. ",
“internal_label”: null
},
“120366731”: {
“field”: “120366731”,
“label”: “Comments if any”,
“type”: “textarea”,
“value”: "only German restaurant without pork knuckle. need to work on that ",
“internal_label”: null
Let me know if you’d need more information, thank you very much.
