[GSheets to App] - How to retrieve hyperlinks from a Google Sheet into the app - Forum
[GSheets to App] - How to retrieve hyperlinks from a Google Sheet into the app
Quote from weblogic on April 26, 2022, 11:48 pmHi Luis! I would like to make a website containing a filter & sortable table of chess tournaments, as a personal project. This list will be updated from a Google Sheet almost on a daily basis. Some of the table columns will contain links to external websites.
I quickly tested GSheets2App on a localhost and I love it, but as you said somehow Google Sheets doesn't return my link URL data into the JSON file of the app. Therefore all my links are broken. Only the text is retrieved.
You mentioned a workaround on Codecanyon's comments. Any help will be much appreciated. Thanks!
Hi Luis! I would like to make a website containing a filter & sortable table of chess tournaments, as a personal project. This list will be updated from a Google Sheet almost on a daily basis. Some of the table columns will contain links to external websites.
I quickly tested GSheets2App on a localhost and I love it, but as you said somehow Google Sheets doesn't return my link URL data into the JSON file of the app. Therefore all my links are broken. Only the text is retrieved.
You mentioned a workaround on Codecanyon's comments. Any help will be much appreciated. Thanks!
Quote from luishp on April 27, 2022, 6:57 amHi @weblogic,
Yes, instead of storing the links as clickable text, just insert the whole link URL (ie: "https://google.com" instead of "Google")
Later today I will share here a modified code to use that link.Regards.
Hi @weblogic,
Yes, instead of storing the links as clickable text, just insert the whole link URL (ie: "https://google.com" instead of "Google")
Later today I will share here a modified code to use that link.
Regards.
Quote from luishp on April 27, 2022, 9:44 pm@weblogic I have sent you a new version by WeTransfer. Please check your email.
Now if you want to include links in a column just add "(link)" to the columns name. If you want to include a text to the link, use "::" to separate the text and the link.For example:
Google::https://google.comLet me know if you have any doubts.
Best regards.
@weblogic I have sent you a new version by WeTransfer. Please check your email.
Now if you want to include links in a column just add "(link)" to the columns name. If you want to include a text to the link, use "::" to separate the text and the link.
For example:
Google::https://google.com
Let me know if you have any doubts.
Best regards.
Quote from weblogic on April 28, 2022, 2:12 pm@luishp I already posted a review last night, you're a star!! :))
I'll post the website url here once it is made public.
@luishp I already posted a review last night, you're a star!! :))
I'll post the website url here once it is made public.
Quote from weblogic on April 29, 2022, 6:02 pm@luishp There you go... Click here to see the results.
From concept to website in 1 day with GSheet2app :)
@luishp There you go... Click here to see the results.
From concept to website in 1 day with GSheet2app :)
Quote from michel.verstrepen on April 30, 2022, 1:41 amHello Luis,
do you plan to put the new release on codecanyon ?
Congratulations
Hello Luis,
do you plan to put the new release on codecanyon ?
Congratulations
Quote from luishp on April 30, 2022, 10:16 am@michel-verstrepen yes, as soon as I can. I want to publish new scripts too. Just not enough time.
Please check your email :)
Regards.
@michel-verstrepen yes, as soon as I can. I want to publish new scripts too. Just not enough time.
Please check your email :)
Regards.
Quote from michel.verstrepen on April 30, 2022, 12:49 pm@luishp Thank you Luis !
@luishp Thank you Luis !