Iโm trying to get a list based on selected ref enumlist. Iโve tried this formula but it didnโt return anythig.
SELECT(
Requisiรงรตes[Proposta],
IN(Requisiรงรตes[Requisiรงรฃo], [_THISROW].[Requisiรงรตes]),
TRUE
)
I want to get the values from โPropostaโ column at โRequisiรงรตesโ table that matches with the selected โRequisiรงรตesโ enumlist ref from โRequisiรงรตesโ table. The form is at another table called โCobranรงaโ that has โRequisiรงรตesโ Column (that is a Enumlist with ref to Requisiรงรตes table) and it has a โPropostaโ column that should return what i said before
Solved! Go to Solution.
@Marc_Dillon Wouldnโt a list-dereference work better here? It would certainly be more efficient.
Your original formula:
SELECT(
Requisiรงรตes[Proposta],
IN(Requisiรงรตes[Requisiรงรฃo], [_THISROW].[Requisiรงรตes]),
TRUE
)
could be simplified to
UNIQUE([Requisiรงรตes][Proposta])
Remove this part:
It worked, thanks. I thought i had to specify the table to look this column
I found a problem with my enumlist. When i created it was showing a yellow alert, i was able to โfixโ it by setting a formula at valid_if. But the existing values were still with the yellow alert, they just disappeared when i selected the current value again at the enumlist options. But when i selected it the โPropostaโ value disappeared too.
This image i reselected an existing value and the โPropostaโ column disappeared on my form
And at this image i didnโt updated the existing value, so it was showing the yellow alert but it also shows the โPropostaโ column as expected
Srry for my bad English, itโs not my first language
Iโm not really following which Table you are in with those screenshots. What is the App Formula for the [Propostas] column?
Yellow triangle means the column is supposed to be a Ref to another table, but the selected value does not exist as a Key value for any record in the referenced Table.
https://community.appsheet.com/search?q=yellow%20triangle
If you are specifying a Valid_If expression for Enum/EnumList with base type of Ref. you NEED to do so with SELECT( table[key-column]...)
, which is also equivalent to simply FILTER(table...)
Also understand how Keys and Labels work together.
Actually iโll describe the process of creation from my app because i think i planned it bad. With a Spreadsheet already created and with values, i started creating tables that tracks payments, but we track payments by a number that is on the order table (that i didnโt set at the beginning). Would it be better to fix the reference between order table and the payments table ("Requisiรงรตes and โNotasโ)? Srry about the confusion this is my first app, iโve read a lot and watched the 101 course but as English is not my first languague maybe i let some information pass when i was studying.
Iโm sorry, you havenโt provided near enough information for me to give any sort of sensible response. Screenshots of your table and column definitions would be much more effectiveโฆ
I have three tables, the first one is the order table:
The other is the payment document table:
The last one is the payment dues control:
The payments due control table is a child from Payment Document table, but what iโm trying to do is when adding a new row at payments document table (โNotasDataโ) when i select a โRequisiรงรฃoโ value (that are values from the order table (โRequisiรงรฃoโ table) it will auto compute the โPropostaโ value
@Marc_Dillon Wouldnโt a list-dereference work better here? It would certainly be more efficient.
Your original formula:
SELECT(
Requisiรงรตes[Proposta],
IN(Requisiรงรตes[Requisiรงรฃo], [_THISROW].[Requisiรงรตes]),
TRUE
)
could be simplified to
UNIQUE([Requisiรงรตes][Proposta])
Yeah, i did it, now i think everything itโs okay. But i made this UNIQUE([Requisiรงรตes][Proposta]) as an app formula and at my card view this values disappeared, is it normal? Should i change to a initial value formula?
This the card view that is not showing the Proposta (i made it show as long piece of text)
But at my form it appears
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |