Ref Column from App Sheet Database and Sheets

[Espegg]

I am trying to create an app with a table from app sheet database and another table from sheet.
Now, in the data source based on app sheet database I would to setup a ref column from sheet but the system return an error of schema.

Maybe it is not possible to setup a ref column from sheets in app sheet database source?

[Markus_Malessa]

Are you trying to setup the REF column directly in the Appsheet Database? If so, you are correct, this functionality does not exist at the moment. However, you could set up this column as TEXT instead in the Appsheet DB, then in the application itself set it up as REF column.

[Espegg]

Hello 

In app sheet database the ref column is as a text column while in app sheet when I try to change it as ref column, the system return an error message to regenerate the schema, and so when then I regenerate the schema, the column return as text column.

So what i am wrong?

[Markus_Malessa]

Can you screenshot the error? The only other suggestion I have is that once you changed the column type in the application, don't regenerate the table. Without seeing the error though I'm not sure if that is a possibility.

[Espegg]

Hello,
this is the error

[Markus_Malessa]

I'm not sure why you are getting this error, but I can tell you that as far as I'm concerned I have a similar setup in one application and I do not get that error.

[Espegg]

I need to build an app with two tables, one in appsheet database and one in sheet (cause I need some Formulas)

So these two tables have to be linked by ref column...

But this is maybe a bug?

[AleksiAlkio]

It sounds a bug. Does it work if you use Enum base of Ref instead of Ref?

[Espegg]

Hi aleksi

You mean if I change this col type in app editor or in app sheet database?

[AleksiAlkio · Accepted solution]

From the App Editor.