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?
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โฆ
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.
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โฆ] ) )
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
I am out of ideas, sorry.
thanx any way manโฆ I appreciate the effort
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
FIXED!!!
thanx Steve, it worked out just the way you said!
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |