Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search
  • 0

Change how forms populate spreadsheet


minnieosc0504

Question

Site URL: https://sealion-dolphin-9xgr.squarespace.com/

This question is one that I don't think anyone on here will necessarily be able to solve by replying on here but I would just like to know if you think it's possible. 

I want to create a booking form for a holiday rental site where customers can enter their required dates, number of people, do they need a travel cot etc etc and for this to populate a spreadsheet - all easily done with no custom work required.

However the thing is there's multiple properties. So the customer will select which property they want from a drop down menu in the form. The tricky bit is that  I want each property to populate a different tab in the excel spreadsheet in the google drive. 

Is this possible??  Is there maybe another way to do this?? 

ALSO we need the dates they put in to  autofill a calendar or go into the spreadsheet in some way which allows for the person organising the booking to quickly see where the gaps are. Rather than just a list of booking dates which makes it tricky to see availability. 

I would be surprised if anyone can help with this but thought it was worth a shot!

Thanks

Link to comment

2 answers to this question

Recommended Posts

  • 0
On 10/20/2020 at 6:43 AM, minnieosc0504 said:

Site URL: https://sealion-dolphin-9xgr.squarespace.com/

This question is one that I don't think anyone on here will necessarily be able to solve by replying on here but I would just like to know if you think it's possible. 

I want to create a booking form for a holiday rental site where customers can enter their required dates, number of people, do they need a travel cot etc etc and for this to populate a spreadsheet - all easily done with no custom work required.

However the thing is there's multiple properties. So the customer will select which property they want from a drop down menu in the form. The tricky bit is that  I want each property to populate a different tab in the excel spreadsheet in the google drive. 

Is this possible??  Is there maybe another way to do this?? 

ALSO we need the dates they put in to  autofill a calendar or go into the spreadsheet in some way which allows for the person organising the booking to quickly see where the gaps are. Rather than just a list of booking dates which makes it tricky to see availability. 

I would be surprised if anyone can help with this but thought it was worth a shot!

Thanks

Website is expired, did you still looking for this?

Greeting, it's BaNgan from BeyondSpace, I am Squarespace dev focus on provide solutions to enhance feature that squarespace.com can't provide.
Feel free to check my current Squarespace Plugins Developement: Enable Pinch/Zoom on lightbox, Delivery Date Picker, Portfolio hover Replace Link Style
If you find my answer fit your need, let's leave a like or upvote so others with the same issue can find their solution. Thank you

Link to comment
  • 0
On 10/20/2020 at 6:43 AM, minnieosc0504 said:

Site URL: https://sealion-dolphin-9xgr.squarespace.com/

This question is one that I don't think anyone on here will necessarily be able to solve by replying on here but I would just like to know if you think it's possible. 

I want to create a booking form for a holiday rental site where customers can enter their required dates, number of people, do they need a travel cot etc etc and for this to populate a spreadsheet - all easily done with no custom work required.

However the thing is there's multiple properties. So the customer will select which property they want from a drop down menu in the form. The tricky bit is that  I want each property to populate a different tab in the excel spreadsheet in the google drive. 

Is this possible??  Is there maybe another way to do this?? 

ALSO we need the dates they put in to  autofill a calendar or go into the spreadsheet in some way which allows for the person organising the booking to quickly see where the gaps are. Rather than just a list of booking dates which makes it tricky to see availability. 

I would be surprised if anyone can help with this but thought it was worth a shot!

Thanks

Just so you know there is solution taking advantage of Google Apps script to twist the Spreadsheet to distribute data the way we wanted

Greeting, it's BaNgan from BeyondSpace, I am Squarespace dev focus on provide solutions to enhance feature that squarespace.com can't provide.
Feel free to check my current Squarespace Plugins Developement: Enable Pinch/Zoom on lightbox, Delivery Date Picker, Portfolio hover Replace Link Style
If you find my answer fit your need, let's leave a like or upvote so others with the same issue can find their solution. Thank you

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...