Change link for text

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

1 Like

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

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

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

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

1 Like

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=YXBwTmFtZT1DbGVhbkNpdHlTQTEtMzM0NDE1JnRhYmxlTmFtZT1DQVJHQURBUyZmaWxlTmFtZT1GQyUyMEIlMjAwMDA0LTAwMDE0MjE2LnBkZiZhcHBWZXJzaW9uPTEuMDAwMDI5JnNpZ25hdHVyZT03NWRmMzkyMDJjZDM2MTk3ODdjN2EzNmI1MjZjYWZjNGM1MmVlMWQxYjdiZGQ5ZGJlNDM2NWFiZGJjY2U1YTRhMWQwODNlOGVkNjZkZDdiNzk0NDU1YTVmNTU0ZTFjMzc=
How do I shorten or transform it into clickable-text?

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.

sorry, I do not understand

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

1 Like

evidently not

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

1 Like

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