Hi everyone I have the following table and I need to fill another table pulling data from this one.
I use:
first column
Attendance[Attendance Category]
second column
Attendance[Attendance Type]
so they can de-ref
I need to fill up another third column as:
Attendance[Attendance]
but I get a N/a result
Can someone help how to do a 3 level de-ref?
This doesn’t make very much sense, please elaborate. Are there expressions involved? What table are you dereferencing to and from? Are you sure you’re using the word “dereference” correctly?
Thanx for your message Marc
you are absolutely right I mean Dependant Dropdown Lists 2 level
I will try to edit the name of the post.
So I want to list the first “Atendance Category” than depending on the selection “Attendance Type” and then depending also on the selection “Attendance” (as shown on the image attached)
how can I do this?
Are you saying what is in this article is not working as it should?
Please provide screenshots of the appropriate column definitions.
As you can See for the first column:
Acompanhamento[Categoria Atendimento]
Acompanhamento[Tipo Atendimento]
Acompanhamento[Atendimento]
there’s an error on he last dropdown
Typically you’ll set up the choices in one Table, then the dependent drop functionality in 2nd Table. I’m not sure what the point of doing it like this is?
Nevertheless I just tried the same setup in a test app, and it seemed to work perfectly fine.
Hmm, wait a sec. “NaN” stands for “Not a Number”. You have some plus signs in the Atendimento column, is there by chance a Spreadsheet Formula in that column’s definition?
No there’s nothing on the Spreadsheet formula…
and I removed all signs and numbers and left just letters
What if you overrode the automatic dependent dropdown functionality, put this into valid_if for Atendimento column:
SELECT( Acompanhamento[Atendimento] , AND( [Categoria…] = [_THISROW].[Categoria…] , [Tipo…] = [_THISROW].[Tipo…] ) )
This did not come from AppSheet:
Highlight ALL cells of all rows below the last cell with a value, then press Delete.
HI Steve,
I done what you requested and still no go…
Oh wait, you ARE working with 2 separate tables. What was with the first spreadsheet that you screenshotted in your first post?
Change it to [_THISROW].[Acompanhamento]
please disregard the first image on the first post, it was just a sample table that I copied from the real one and translated the column names for you to better understand… I already deleted this table
the real one is the one on the last pictures
Marc_Dillon:
SELECT( Acompanhamento[Atendimento] , AND( [Categoria…] = [_THISROW].[Categoria…] , [Tipo…] = [_THISROW].[Tipo…] ) )
The formula works, but the field for “Atendimento” doesn’t show up after all the above options are selected
I am out of ideas, sorry.
thanx any way man… I appreciate the effort
Any idea Steve?
Something’s wrong with your spreadsheet(s). In all of your worksheets, delete all unused rows and columns (don’t just blank them, actually remove them using right-click). Then Regenerate Structure for every table of your app.
I’ll do better, I will build the tables from scratch and start over these 2 tables.
I’ll let you know how it goes
