How do I show a Google Doc file in the app?
I have a Terms & Conditions GDoc File that I would like User to view in the App without looking like they are leaving the App.
I made the GDoc Public and inserted the URL in the Initial Value, but after clicking the link, it says โThis site canโt be reachedโ
This is what my Spreadesheet Formula looks like in the app.
hyperlink(โhttps://www.grantsfarm.com/terms-conditions","Terms/Conditionsโ)
I donโt want the long URL to show up in the App, only the โTerms/Conditionsโ
with the link icon.
TYTY!!
HYPERTEXT(LINKTOURL(โYourURLHereโ),โTerms & Conditionsโ) should work for that
Sweet, thanks Bro, trying it now!
TY for excellent suggestions!
I really donโt care if they actually read the T&C, nobody does. This must be very fast and very easyโฆas long as they can have access to my T&C .PDF while they fill out the quick SignUp Form, I would be very happy.
If this app expands to allow the Guests to take many photos around the property, as I am hoping,
I will need your excellent IN() expression so Guest is not asked to enter Birth date and Agree to T&C again.
I might ping you on this again as I expand.
TYSVM!
I just added a table with 41,000 US Zipcodes, City, State, LatLong, Population, TotalWages, AvgWages.
Guest enters Zipcode & I know everything, almost, HAHA!
Hey, do you know of a Zip+4 list available anywhere?
Thx!
AS should hard-code the entire Zip+4 database, would be EXTREMELY powerful for many apps!!
@Stephen_Mattison I believe https://smartystreets.com have an API for that. I believe itโs free up-to a number of queries per month and itโs quite easy to query with a simple webhook scripting
@Stephen_Mattison smartystreets.com - Address Verification APIs Address Verification APIs smartystreets.com
I canโt get this to work, it didnโt like HYPERTEXT or LINKTOURL
Changed to
HYPERLINK & LINKURL and still not getting it to work.
And as I dig into this more, I think I really need to view a PDF in the App, not a GDoc.
I must be missing something big because nothing I am doing seems to be working.
Iโd like a neat and succinct โTerms & Conditionsโ with the Link icon to show up.
I checked out the AS Hyperlinks Sample App and did just like they did, but did not get it to work.
I need new Guests to be able to view the Terms & Conditions PDF while they are filling out New Guest Sign Up in Guests_Detail.
They have a T&C web page available, but I think I want to have Users be able to view a File from the App so they donโt click something at the website and get distracted.
Vast majority will never look at this File, just click Agree/Yes and be done with SignUp, but T&C must be easily accessible, even Downloadable if that is possible.
I need the PDF to then be view-able/Downlaodable if User ever goes back to their file and wants to read the entire T&C.
TYVM!
I have also been checking out the AS Hyperlinks Sample App.
Iโd rather not use a Virtual Column if I donโt have to.
Support Docs seem to suggest that I donโt need a VC if you โmark IsHyperLink to Trueโ Befuddled why I canโt get this to work nice & easy.
AS Support Doc: โHYPERLINK({Address}, {Text}) returns a hyperlink to the given address with the given clickable text. For example, the formula HYPERLINK(โhttp://en.wikipedia.orgโ, โClick here to visit Wikipediaโ) will create a link that looks like this: Click here to visit Wikipedia. If you use the HYPERLINK formula in a non-virtual column, make sure to mark โIsHyperLinkโ to true in the Type Qualifier. This ensures that the value of this column is written as a sheet =HYPERLINK formula.โ
@Stephen_Mattison have you solved the issue or is it still unsolved?
Still unresolved, sorry.
Iโm guessing something new is going on, this App on my Phone just made me โSign in with Googleโ and now I am seeing my URL Links and my PDF File.
How do I get the PDF File to appear with a nice succinct โTerms & Conditions Fileโ instead of the actual file link.
Still learning this stuff,
Not crucial/high priority. Thanks a lot for your help!
@Stephen_Mattison after making structural changes in an app, itโs required that you perform a hard sync rather than a soft sync to notice those changes. If you donโt release a running app from the running memory after closing it, then the app data is brought from the cache instead of the server. Possibly this is the reason why youโre seeing it working now. Glad to hear that itโs resolved now.
OK, yes I got PDF & URL Link working.
Part of my problem was that I wasnโt seeing them appear in the Form View.
I really need User to be able t o click and see my T&C PDF in the Form View as they are signing up for the first time.
Is this possible?
Thanks Mr. K!
@Stephen_Mattison displaying a link for the T&C does not give you a bulletproof idea that they have read it. I can humbly propose to make seperate section with your T&C, place it in a Long Text field, set Editable_if to FALSE and put some kinda โI accept/I readโ button at the end and set it to required. Provided your form is not ending there, you can set a show_if for the next section like [APPROVAL]=โI acceptโ or similar. And you can define if the user is existing in your registration table or not with a simple IN(โฆ) expression in the Valid_if field. You can also use the same function to show/hide your T&C section.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |