# Creating a form for hotel check-in **URL:** \ **Category:** Ask for Help\ **Created:** [June 28, 2020, 9:31am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600 "2020-06-28T09:31:38Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Philip\_Lim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/philip_lim/32/5370_2.png) [@Philip\_Lim](https://community.glideapps.com/u/Philip_Lim)\ **Post date:** [June 28, 2020, 9:31am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/1 "2020-06-28T09:31:38Z")
Hello there, I would like to ask if it is possible to create a form for a hotel guest during check-in. So the basic fields like personal details, uploading photo of self and passport, agreeing to terms and Submit. I have created a form, however the phone number & email fields did not have restrictions in keying in the data. So i could type random words and it could still ‘SUBMIT’. I could not find the function to submit photo and agree to terms… Hope someone can help me with some info. Thanks!🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 28, 2020, 9:41am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/2 "2020-06-28T09:41:03Z")
Not sure if the phone & email fields validate in the right way, just to make sure, did you try “phone entry” and “email entry” components instead of “text component”? The “submit photo” is done by the component “image picker”. The “agree to terms” can be done by a combination of: - A link to where you store your terms (or if it’s not too long you can probably make it a text component right on that screen) - A checkbox that requires the user to tick ---
**Author:** ![Philip\_Lim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/philip_lim/32/5370_2.png) [@Philip\_Lim](https://community.glideapps.com/u/Philip_Lim)\ **Post date:** [June 28, 2020, 9:56am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/3 "2020-06-28T09:56:06Z")
Hi ThinhDinh, Thank you for your help. Yes i used email entry and phone entry components. I can type just a few random letters for both fields and SUBMIT. How do i make it restricted to the specific field? Thank you:) ---
**Author:** ![Philip\_Lim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/philip_lim/32/5370_2.png) [@Philip\_Lim](https://community.glideapps.com/u/Philip_Lim)\ **Post date:** [June 28, 2020, 10:02am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/4 "2020-06-28T10:02:13Z")
Thank you, the image picker work perfectly. Is it also possible to ‘ADD’ guest forms for check-in? So 1 guest can fill ‘add’ guests and fill in their forms and submit. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 28, 2020, 10:04am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/5 "2020-06-28T10:04:21Z")
Seems like it’s not validating the right way then, I have seen this issue popped up a few times and at the moment I don’t think there’s a fix for it. Regarding the add function, I think you can do that by creating a new tab that points to your user profiles tab and enable the “Add” option in the settings. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [June 28, 2020, 10:09am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/6 "2020-06-28T10:09:42Z")
@Philip_Lim As always, it is better to avoid formulas in Google Sheets to avoid lag, but there are validation formulas in GS you could use. **Have you tried isemail() for email addresses?** I believe that’s the one but you’d have to check. There’s might be such a formula for phone numbers or you can find it online or create it? **EDIT** Using the formulas in GS will only give you validation _after_ the form is submitted, which is not great use experience. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [June 28, 2020, 10:21am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/7 "2020-06-28T10:21:00Z")
N.B. to my comment above: using the formulas in GS will only give you validation _after_ the form is submitted, which is not great use experience. ---
**Author:** ![Philip\_Lim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/philip_lim/32/5370_2.png) [@Philip\_Lim](https://community.glideapps.com/u/Philip_Lim)\ **Post date:** [June 28, 2020, 10:42am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/8 "2020-06-28T10:42:30Z")
Thanks Nathanael, So how do i put in the **isemail()**? I dont mind giving it a try:) ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [June 28, 2020, 11:33am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/9 "2020-06-28T11:33:34Z")
Column A (for instance): the email addresses Column B (for instance): arrayformula(isemail(A2:A)) In column B you should see boolean values (true / false). Create a component (for instance a text or button component that world say “Please enter a valid email address”) with action=none and visibility is “column B is False”. Again though, the message will only appear after your form would have been submitted, which is not ideal. ---
**Author:** ![Cmstewart42](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cmstewart42/32/7319_2.png) [@Cmstewart42](https://community.glideapps.com/u/Cmstewart42)\ **Post date:** [June 28, 2020, 10:07pm UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/10 "2020-06-28T22:07:59Z")
@Philip_Lim, I have responded to this validation question a few times recently as there is a way you can prevalidate entry fields and then populate the form submission with those values for the user. Essentially. - Have a page with use entry fields (regular entry fields, not in a form) - each field has its own column and a validation column as well. Each validation column will validate it’s respective entry field column - once all entry fields have been validated, a form button appears to submit the info, clicking it then opens the form - On the form page you then show (in non editable fields) all the information from the previous page as a confirmation (at least that is what it will be from the users perspective) and if all looks good the user hits submit. - hidden from user you are using the column component to push the data entered in the previous screen into the form submission for the user. Only caveat (as mentioned above) is if the validation cannot be done in glide columns then doing it in sheets does cause some minor delay. In practice I haven’t found this to be too much of an issue though. If this makes sense and seems usable please let me know if you need a more detailed explanation. ---
**Author:** ![Philip\_Lim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/philip_lim/32/5370_2.png) [@Philip\_Lim](https://community.glideapps.com/u/Philip_Lim)\ **Post date:** [June 29, 2020, 12:36pm UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/11 "2020-06-29T12:36:32Z")
Hi Stewart, thank you for your help. I’m sorry that i’m not familiar with this platform. Will it be possible for you to explain again, so that i can try my best to follow by looking for the words/items on glide builder app? Thanks ---
**Author:** ![Philip\_Lim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/philip_lim/32/5370_2.png) [@Philip\_Lim](https://community.glideapps.com/u/Philip_Lim)\ **Post date:** [June 29, 2020, 12:40pm UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/12 "2020-06-29T12:40:00Z")
I have added quite a few fields to my check-in form. Now i am trying to include a checkbox to agree to hotel rules and terms. Question: How can i include a link to a page with hotel rules? So user can click to read details b4 agreeing. Question: I included a signature component. I signed it and submitted a trial. However, the image that came up on my sheets is black signature on black background. How can i fix this? Thank you ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 29, 2020, 1:37pm UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/13 "2020-06-29T13:37:37Z")
> [@Philip\_Lim](#): > > Question: How can i include a link to a page with hotel rules? So user can click to read details b4 agreeing. Add a button that have a webview action/view link action and points the value to the link you want them to see. > [@Philip\_Lim](#): > > I included a signature component. I signed it and submitted a trial. However, the image that came up on my sheets is black signature on black background. How can i fix this? No current way to fix this as far as I aware. ---
**Author:** ![Cmstewart42](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cmstewart42/32/7319_2.png) [@Cmstewart42](https://community.glideapps.com/u/Cmstewart42)\ **Post date:** [June 29, 2020, 3:39pm UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/14 "2020-06-29T15:39:00Z")
Helo @Philip_Lim, Take a quick look at a past conversation I had concerning validating premium codes [here](https://community.glideapps.com/t/user-verification-solution/11469/2). This only validates a single field for validity and non duplication, but the overall process is the same for what you want to do. Feel free to ask any more specific questions you may have! ---
**Author:** ![Cmstewart42](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cmstewart42/32/7319_2.png) [@Cmstewart42](https://community.glideapps.com/u/Cmstewart42)\ **Post date:** [June 29, 2020, 9:08pm UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/15 "2020-06-29T21:08:40Z")
Hi @Philip_Lim, Please feel free to check [this](https://userpropertyvalidate.glideapp.io/) example out I created. If the flow and function works for you I can share the method behind it. Valid example codes to use ABC, DEF, GHI, JKL, MNO. Just pick one 3 letter code to use Used codes will showup as already used, invalid codes show up as invalid (it is case sensitive). Once a valid code that is not already used is entered you can confirm and submit, then your entered code will be displayed. Just an example of how user input can be validated prior to accepting it. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 30, 2020, 2:50am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/16 "2020-06-30T02:50:02Z")
> [@Philip\_Lim](#): > > black signature on black background What’s your color theme? Are you using ‘Match device theme’? ---
**Author:** ![Philip\_Lim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/philip_lim/32/5370_2.png) [@Philip\_Lim](https://community.glideapps.com/u/Philip_Lim)\ **Post date:** [June 30, 2020, 3:49am UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/17 "2020-06-30T03:49:09Z")
Hello Jeff, Im using the Light theme, default one. And yes, match device is checked. Thanks for your help ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 6, 2020, 11:21pm UTC](https://community.glideapps.com/t/creating-a-form-for-hotel-check-in/11600/18 "2020-07-06T23:21:31Z")
I can duplicate this. The image looks fine in a signature component, but shows as black on black when viewed as an image. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b8b54b8d4b3628eb076a5f4cb5a95344b6f06f0a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/08b55f816e67036ab514fd40e0c0127ea07bd1ac.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ede7d86e3068bf71fe6df532716e011791acf59e.png)