URL column type

AppSheet AppSheet Q&A
1

Hi community…

Please I have problem with URL, where I tried to make for image record in my App.
I create the expression in image bellow:

2X_8_89c180b4db8dfa55851c194eb1b9d975445facc0.png
2X_8_89c180b4db8dfa55851c194eb1b9d975445facc0.png1366×768 111 KB

I got error when tried to open URL.

2X_e_ec462a8090fd7bca9f927ae9a3edcd383fe17edc.png
2X_e_ec462a8090fd7bca9f927ae9a3edcd383fe17edc.png1366×768 69.2 KB

thank you

2

Is there a space after the dash???

2X_8_8eba2de8d1cf21cd6ba9d64b6815d66d5e53679a.png

I’m thinking there shouldn’t be, and if there IS it needs to be URL encoded.

3

yes, there is space.

4

remove the space. There shouldn’t be one there.

That part of your app is the App ID from appsheet, and these don’t contain spaces.

1 Like
5

I removed the space and same error.
When I test expression in App there is no error. But the url in spreadsheet not open.

6

Hmmm… I’m not sure about this one then. I’d email support@appsheet.com for further assistance at this point, but perhaps someone else in the community has any further ideas.

1 Like
7

Thank you about your responding.

1 Like
8

try this: wrap the whole concatenate() formula in an ENCODEURL()

9

No, no. The only part of the expressions that (in this case) needs to be wrapped in ENCODEURL() is [imag1]:

CONCATENATE(
  "https://www.appsheet.com/template/gettablefileurl?appName=",
  "laborinspection-1012701",
  "&tableName=",
  "sheet1",
  "&fileName=",
  ENCODEURL([imag1])
)

though as a matter of good practice, each of the parameter values should be, too:

CONCATENATE(
  "https://www.appsheet.com/template/gettablefileurl?appName=",
  ENCODEURL("laborinspection-1012701"),
  "&tableName=",
  ENCODEURL("sheet1"),
  "&fileName=",
  ENCODEURL([imag1])
)

None of the rest of it should be included in ENCODEURL(); doing so will break it entirely.

1 Like
10

Oh, I see the problem. The formula you’re attempting to use goes in your spreadsheet, not in your app. Where did you get the formula?

1 Like
11

Thank you steve. yes i used this formula in spreadsheet.
Is this formula wrong?

12

It appears your formula came from the below. I’ve updated the page to use ENCODEURL().

13

Fouad_H_Saad1:

Is this formula wrong?

It doesn’t belong in your app.

14

Steve, I tried to show images as URL in spreadsheet,
So I created column in URL type to save URL for images that record from App and this column isn’t show for users just for App admin.