95
edits
Changes
Jump to navigation
Jump to search
</div>
</div>
<div class="mw-collapsible mw-collapsed">
<div class="headline-collapse" >
=== How to collect additional guest details and add to the booking ===
</div>
<div class="mw-collapsible-content">
If you want to collect additional guest information and add this to the booking, you can do this using a Google Form and Make.
Setup a google form with the information/questions you want to collect from a guest, and using Make we will get the response from the form and insert into the correct booking.
In this example we will show you how to collect additional guests information like “First name, Last Name, Id number and birth date. And insert this into the “Info” field of the booking
1. Setup a new google form and name this “Guests Information”
[[Image:Guestinfo1.png|650px|link=]]
[[Media:Guestinfo1.png|view large]]
2. Create the questions
a. Booking ID
b. First Name
c. Last Name
d. Id Number
e. Birth date
[[Image:Guestinfo2.png|650px|link=]]
[[Media:Guestinfo2.png|view large]]
3. Click on “Responses”, and than click on the “Excel Icon”
[[Image:Guestinfo3.png|650px|link=]]
[[Media:Guestinfo3.png|view large]]
4. Select “Create a new Spreadsheet” and click on “create”
[[Image:Guestinfo4.png|650px|link=]]
[[Media:Guestinfo4.png|view large]]
5. Log into Make, and start a new Scenario, the first module we are going to need is Google Forms and set this to “Watch Responces”.
6. Set the connection ( you will need to Allow Make to access your Google account),
a. Choose the “File” this is the same name you gave your “Form” in Google forms.
b. Worksheet, Google forms should create a worksheet in your Google drive, you need to select this here.
c. Maximum number of returned rows, Here, set the maximum number of results that Make will work with during one cycle, You can set this to one, we will make this scenario constantly checking for new responses
[[Image:Guestinfo5.png|650px|link=]]
[[Media:Guestinfo5.png|view large]]
7. After this, it will ask you to “Select the first row” this means the row you want Make to start checking the worksheet, it should normal be set to number ”2” because the first row is used for the column names.
8. Now we will need to add another module, add the “Json” module and set it to “Create Json”
9. You will need to add a “Data Structure.
a. Click on “Add”
b. “Name the data structure” and click on “Generator”
c. Leave the “Content Type = Json
d. On the Sample Data insert
{
"authentication": {
"apiKey": "apiKeyAsSetInAccountSettings",
"propKey": "propKeyAsSetForTheProperty"
},
"bookId": "12345678",
"firstNight": "2014-09-30",
"numAdult": "3",
"invoice": [
{
"invoiceId": "123456789",
"description": "deposit payment",
"status": "",
"qty": "-1",
"price": "23.45",
"vatRate": "10",
"type": "200"
}
],
"infoItems": [
{
"code": "PAYMENT",
"text": "Paid $200"
}
]
}
10. Click on “Save”, you should now see the original “window” with your data structure and it should have a “Authentication” box where you need to insert the API key
[[Image:Guestinfo6.png|650px|link=]]
[[Media:Guestinfo6.png|view large]]
11. You will also need to add under “Notes” the following (See image) above
a. FirstName: - add the Make variable for the First Name
b. Last Name: - add the Make variable for the Last Name
c. Id Number: - add the Make variable for the ID Number
d. Birth Date: - add the Make variable for the Birth Date
12. Set the module HTTP, and set this to “Make a Request”
Set the:
a. URL: https://api.beds24.com/json/setBooking
b. Method:Post
c. Header: Leave blank
d. Query String: Leave blank
e. Body Type: Raw
f. Content Type: JSON
g. Request Content: JSON String ( Its a variable you need to drag and drop).
[[Image:Guestinfo7.png|650px|link=]]
[[Media:Guestinfo7.png|view large]]
After you do this, go to your Google form and fill it in as a “guest” than in Make click on “Run Once” it should retrieve the answers and insert into the booking in the field “Notes”.
Make
,no edit summary
[[Image:push7.jpg|650px|link=]]
[[Media:push7.jpg|view large]]
</div>
</div>
