I have a table that captures urls to files from another app. This app accepts multiple files and the urls are listed in a single cell in the column, one per line. When I display the column data in AppSheet, the urls are squished together and made into one which breaks them.
Is there a way to display these in a list?
R_Newell:
urls are listed in a single cell in the column, one per line.
You mean the URLs are all in one cell, separated by line breaks? Like this?
If so, the LongText column type is the only one that can handle line breaks in its value. So you’ll need to set the column as LongText. Then, in another column, you can SPLIT() them into a List, using a line break as the delimiter:
SPLIT( [urls] , "
" )
Marc_Dillon:
auto> >
Thanks. That worked to break them out, but it does not create each as a clickable link in the app even though I set the element type to URL.
It seems like there may be no way to accomplish this with clickable links…
If you apply the hyperlink() function to the split values then that should make them clickable.
|
I need to do this in a new virtual column, correct? I tried it and just keep getting invalid inputs.
Should I apply that function in a separate column or within my split value column? This is how the split value column is set up:
One possible workaround is to user Preview Feature, rich text. But this is no longer “No coding” but you construct html manually using virtual column with expressions like this.
substitute(
“<a href=”&text(‘"’)&Substitute(
[Enumlist]," , “, text('”‘)&“>Link , <a href=”&text(’“‘))
&text(’”')&“>Link”,
" , ",
“
”
)
Then turn on preview feature and make this VC to longtext with HTML enabled.
@takuya_miyai
@Steve
I’ve had difficulty with using HTML links to URLs in rich text:
Can you re-phrase your problem? to see if I can help.
Hello. Yes of course.
I have a table with a column that feeds multiple urls to files. These urls are one per line in one cell, like this:
| Submission | URL to files |
|---|---|
| 1 | http://www.example.com/001.pdf http://www.example.com/002.pdf |
When I display them as a file in AppSheet, the urls are combined, breaking both links:
http://www.example.com/001.pdfhttp://www.example.com/002.pdf
I would simply like to display the list of urls as clickable links, if possible.
I tried splitting them into a list then applying the HYPERLINK function in a new column, but I cannot seem to get valid inputs.
Hi @Koichi_Tsuji ! If you are asking me to rephrase the problem, I described it in the post I linked to but the basic idea is that I the URL links didn’t work properly on my phone.
Are you setting the column type to Text instead of Longtext?
Yeah, i had a look at it, but i could not understand. that’s why I asked you to re-phrase for me. Even in Japanese is fine! 
Sorry I didn’t see your earlier replies.
My initial file field is set to lontext
I was splitting them with this column:
I think we’ve all been looking at this problem from the perspective of a list in AppSheet terms. Could you try just entering a space between the links using substitute()? The expression would look like this
Substitute ([File Upload], “pdfhttp”, “pdf http”)
If this does at least display the URLs separated correctly, then we can go a stage further and wrap them in some html like this:
concatenate(
“
substitute( [File Upload], “pdfhttp”,
“pdf” & text(‘"’) & “>Link
text(‘"’) & “>Link
I tried to illustrate the problem on my app but now it is working fine. I’m not sure what happened before but I am no longer experiencing the problem. Sorry to bother you. お騒がせしました。
The substitute works, and also the listing code to separate each url out, but they’re still not clickable.
I just noticed the “
