Target URL disappeared

good night
I had previously created an application where I had a link to an external page, at the moment I am creating another one, but the field to put the URL in this version does not exist.
If there is anyone who can help me I appreciate it. Thank you

How are you trying to create the external link?

Right now I only have one URL type field, but I don’t have the address set anywhere, because I don’t know where to put the address

The URL would go in the column value.

In the Gsheet or in the appsheet?
Sorry, i’m a beginner.

Yes. Your app (AppSheet) should have a table that uses a worksheet in your spreadsheet. Any value that goes into the AppSheet table should end up in the worksheet.

1 Like

I already did what you are saying, but then the field does not appear, it says what type of column ‘Url’ has a ‘Spreadsheet Formula’, so the column is being marked as ‘Read only’ and does not appear in the app

Ahhh… In the spreadsheet, remove all formulas from the entire column the URL will be stored in. Then, in the column configuration for the app, clear the Spreadsheet formula property:

image

1 Like

I cleaned the formulas in the spreadsheet, and erased all the data, saved and synchronized the app, re-entered the address and the result was the same

This should be blank:
image

Nothing I wrote in any way suggested you should enter anything here; I explicitly told you to clear the value.

1 Like

Sorry… my english is not so good, I understood, that you should have the address there

But where do I put the address?

@Alexandre_Alves
The correct place is Initial Value

1 Like

Thanks, but don’t work, already tried

@LeventK
Shows the address, but does not activate the link

May I humbly ask what you are trying to achieve? At the end, the URL column will not present a clickable URL in the Form View. You will be able to see in the Detail View. So provided you place your URL either in the initial value or appformula

CONCATENATE("http://www.google.com")

it will get you what you need in the Detail View but not in the Form View

2 Likes

@LeventK
The objective is to put a field (Sopa) that is the key, and there is another field (Soup) that will insert the same data but in English, between these two fields I would like to put a direct link to the google translator


Simples, mas não estou a conseguir

You should than use a Show type column with a base type of URL, not a URL type column

2 Likes

Perfect, I wasted an entire day and it was so simple. I had already made another app for a friend and I put the direct link, but I no longer remember how I did it. Thank you very much
@LeventK
@Steve

1 Like

You’re welcome. But please bear in mind that, provided the user clicks that link, the user will loose the focus on the Appsheet app and the form and will need a restart. Just FYI.

2 Likes