Referenced data and new data entry

[Alexandre1]

I’m creating a product management app.

I have four fields referenced to four different tables:

• Categoria nível 1 PB

• Categoria nível 2 PB

• Categoria nível 3 PB

• Categoria nível 4 PB

The goal is that when data is entered into category 1, it is linked to the data in category 2, and with a filter applied, and so on across all 4 tables.

It works if I only use the data that is already in the database, but when I try to insert new data, it gives an error.

The only formula I’m using is

FILTER(“Categorias N 2”,[Categoria Nivel 1]=[_THISROW].[Cat N1])

in the field VALID IF

thanks

[Syamsudin]

Hi @Alexandre1

Have you recently added a column in Google Sheets? This usually happens when I add a new column between existing columns. Just fix it in your Google Sheet.

[Alexandre1]

Hi @Syamsudin

No, I created the tables and then did the programming, I’ve already restarted the app, but it’s still giving an error.

[Syamsudin]

Hi @Alexandre1

Try checking the column type, maybe it’s not text but number or decimal, if you want text change it to text column type

[Alexandre1]

Hi @Syamsudin

I’ve already identified the error; when I applied the filter, the [Cat N1] field is a virtual column meant to return only the name and not the key, but when I changed it directly to the referenced field, it works perfectly. Thank you very much for your help.

[Syamsudin]

You are very welcome! I’m happy to help.