Target URL disappeared

[Alexandre_Alves]

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

[Steve]

How are you trying to create the external link?

[Alexandre_Alves]

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

[Steve]

The URL would go in the column value.

[Alexandre_Alves]

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

[Steve]

Alexandre_Alves:

In the Gsheet or in the appsheet?

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.

help.appsheet.com

Getting Started: The Essentials

A quick reference guide with all the ways to learn how to use AppSheet

[Alexandre_Alves]

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

[Steve]

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:

[Alexandre_Alves]

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

[Steve]

This should be blank:

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

[Alexandre_Alves]

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

[Alexandre_Alves]

But where do I put the address?

[LeventK]

@Alexandre_Alves
The correct place is Initial Value

[Alexandre_Alves]

Thanks, but don’t work, already tried

[LeventK]

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

[Alexandre_Alves]

@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

[LeventK]

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

[Alexandre_Alves · Accepted solution]

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

[LeventK]

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.

[Alexandre_Alves]

@LeventK
Oh. Once again, thank you very much

[LeventK]

You’re very welcome.

[Alexandre_Alves]

@LeventK
From what I have read on the forum, they say that it is not possible to place a field of our App directly on a web page, for example to put the value of the field “Sopa”

automatically on the google translator page?

[LeventK]

@Alexandre_Alves
Actually you can Try below expression with your Show column URL:

IFS(
	ISNOTBLANK([Sopa]),
	CONCATENATE(
		"https://translate.google.com/#view=home&op=translate&sl=pt&tl=en&text=",
		ENCODEURL([Sopa])
	)
)

[Alexandre_Alves]

I managed it too, but I created a virtual column and put this formula:

[LeventK]

That won’t be clickable I believe. IMHO, Show type column is a better solution.

[Alexandre_Alves]

@LeventK
It is clickable and working. But I believe in your experience, and in terms of programming your way is the correct one.
my id is 814922 you can check

[Alexandre_Alves]

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