Change link for text

[FRANCISCO_MARRA]

I have an action to send a file by mail.
but I can’t shorten or change the link.
please help

[Marc_Dillon]

help.appsheet.com

HYPERLINK()

New hyperlink

[FRANCISCO_MARRA]

I read it but I can’t get it to work

[Steve]

What did you try? What was the result? Screenshots would be helpful.

[FRANCISCO_MARRA]

SELECT(CARGADAS[file](HYPERLINK([_THISROW].,“aqui”),
[file name]=[file txt]))
)))

[Steve]

FRANCISCO_MARRARO:

SELECT(CARGADAS[file](HYPERLINK([_THISROW].,“aqui”),
[file name]=[file txt]))
)))

Not a valid expression in any way, shape, or form.

[FRANCISCO_MARRA]

okay I understand…

this expression

CONCATENATE( " Le recordamos que la factura N°" ," “,
LIST([Comp.]), " " , “se encuentra vencida desde el dia:” , " " ,” ",
[Comp. - F. Vto.], " ", “$” ,
[Comp. - Impte. mon. Local] , " “, “Descargue su factura en” , " " ,” ",
SELECT(CARGADAS[file],
[file name]=[file txt]))

generate this

Le recordamos que la factura N° FC B 0004-00014216 se encuentra vencida desde el dia: 04/15/2021 $7000 Descargue su factura en https://www.appsheet.com/get/?i=YXBwTmFtZT1DbGVhbkNpdHlTQTEtMzM0NDE1JnRhYmxlTmFtZT1DQVJHQURBUyZmaWxl...
How do I shorten or transform it into clickable-text?

[Marc_Dillon]

So the

SELECT(CARGADAS[file],
[file name]=[file txt])

part is what generates your URL, so this is what you would use HYPERLINK() on, which expects a URL as its 1st argument.

[FRANCISCO_MARRA]

sorry, I do not understand

[Marc_Dillon]

Do you understand how you would replace “www.anyurl.com” with the text “Click Here”, by using HYPERLINK() ?

[FRANCISCO_MARRA]

evidently not

[Marc_Dillon]

Then you need to review the Help Article posted above more closely.

[FRANCISCO_MARRA · Accepted solution]

thanks for your time.
one more question.
it being a document table can it affect what i am trying to do?