Broken Reference

[davidPaiva]

As you can see, the "Estado" is with a broken reference, I guess it's because my valid if

But if I try other way...

And since I am using a dependent dropdown here, I can't use estados[ID], since it will broke the sequence.

I have a Estados table (States) the have the list of all states
Then I have the Cidades table (Cities) that have the list of all cities, this table have a column called estado that is a ref to Estados table

[Marc_Dillon · Accepted solution]

>>"And since I am using a dependent dropdown here, I can't use estados[ID], since it will broke the sequence."

That's an easy problem to solve by writing your own SELECT expressions for valid_if, instead of relying on Appsheet's implicit dependent dropdown functionality.

https://help.appsheet.com/en/articles/961554-dependent-dropdown

https://help.appsheet.com/en/articles/2357314-select

However your issue may be more easily solved I think, just by setting your referenced table appropriately:

[davidPaiva]

it's seems the issue was with the type, changed estado and cidade from ref to text

[Marc_Dillon]

Well, no, that wasn't really the issue. But if you don't need the actual references, then sure, using Text will work fine too.

[Joseph_Seddik]

Please show the datasource of your Estados table. Thanks.

[davidPaiva]

I didn't marked it as a PII, probaly it's automatic.
I will test removing the PII from ID

[Joseph_Seddik]

@davidPaiva Please see @Marc_Dillon's reply above. He's already found where your problem is.