Hi
when I take an image the app create an image link attached to folder where itโs stored ,for exemple : โfolder/ imageAโ
Now , I create a new column"link" , where I want to SUBSTITUE that word โfolderโ by โapplicationโ โฆ please how can I create this formula
I tried with the SUBSTITUTE FUCTION : I create formula like
Substitue([image],โfolderโ,โapplicationโ) in order to replace the word โfolderโ by โapplicationโ but
I get a link like : https://www.appsheet.com/get/?i=YXBwTmFtZT1pbnRlZ3JhdGUtMTM2MTgwNiZ0YWJsZU5hbWU9YXBwJmZpbGVOYW1lPWFw...
Where do you get that link?
I can replicate getting such a link if the column type is set as URL. What exactly is your goal here?
the nature of columns:
Image is image
link is text
I want that in the coumn link get values from column image but in condition to Substitue the word โ folder โ by โ application โ
I see. Youโre right, a real text column with that substitute expression does ouput an โwww.appsheetโฆโ link. It looks like it works with a virtual column though (but only after a sync, it also shows the โwww.appsheetโฆโ in the form before a sync). Does a virtual column work for you? The other option would be to run the substitute function as a spreadsheet formula.
a virtual column seems good idea but It wonโt be useful for me because the spreadsheet is in used with another app , I want that the values be recorded in the spreadsheet
User | Count |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |