Question about table reference

[Chosk]

Hi guys, I am trying to do an Table Ref here, based on the official example 

https://www.appsheet.com/Template/AppDef?appName=BasicReferences-96620&appId=BasicReferences-96620#D...

The example works fine, but when I try to replicate on my cenario, the referenced records, only open the first one, see the screenshots below.

tbl_principal_politicas_WF

tbl_principal_politicas_WF

tbl_workflow

When I open the second record as well ( Date 24/02/2023 ) it opens the record with Date 01/03/2023 again.

The table design is this.

I also tried to do the REF based on "Codigo Politica" wich is the unique values as well "Nome da Politica", but no success.

It opens the first record always.

[scott192 · Accepted solution]

You are mixing up Keys with References!

Please expand your screenshot of tbl_Workflow to include the Initial Value column.

It would also help to include a screenshot of your tables inside your sheets.  With the column names and a few rows of data.

[scott192 · Accepted solution]

Thank you for doing that 😊

Your screenshot of clicking a row in the table and not getting the correct detail view for that row has made me decide that this could be an invitation to Appsheet Support to investigate or perhaps another community member can help.

I'm sorry I couldn't help you any further.

[scott192 · Accepted solution]

In your Target formula, change it to this

LINKTOROW([key],"tbl_Workflow_Detail")

[scott192]

I'm not sure that you have set a key in your second table tbl_Workflow?

If you have set a key, then are you certain that the value you have chosen is a unique value?  If you have multiple records all with the same key then Appsheet is showing you the first record in the list.

[Chosk]

Yeah I have set a key on tbl_workflow, that is the "Nome of Politica".

This records on tbl_workflow is repeating only on tbl_workflow, but on tbl_Principal_Politicas ( wich is the main table ), they are not repeating.

I also tried to set the "key" column to be the key ( wich is not repeating, formula uniqueid() ), but results in the same 😕

[Chosk]

I am following the same as the example App, see my main table.

On the example:

On sample app, the "Department" also is repeating wich is the KEY, but why on sample when clicking on different records it works fine? I'm going crazy here already.. hahaha

[scott192 · Accepted solution]

You are mixing up Keys with References!

Please expand your screenshot of tbl_Workflow to include the Initial Value column.

It would also help to include a screenshot of your tables inside your sheets.  With the column names and a few rows of data.

[Chosk]

ok, here it is the screenshot of tbl_workflow ( many records ) settings

Here is the tbl_WorkFlow screenshot

tbl_Principal_WF related

[scott192 · Accepted solution]

Thank you for doing that 😊

Your screenshot of clicking a row in the table and not getting the correct detail view for that row has made me decide that this could be an invitation to Appsheet Support to investigate or perhaps another community member can help.

I'm sorry I couldn't help you any further.

[Chosk]

I figured out what is happening.

The refs are not wrong.

But when clicking on referenced table, this action is bugged.

Since I dont want to edit the records on referenced table, I did this action to only VIEW the records, but this action is only linking to the first row referenced.

When clicking without this action, it works fine!

Maybe someone of AppSheet team can help this, if this behavior is expected.

@Steve 

[scott192 · Accepted solution]

In your Target formula, change it to this

LINKTOROW([key],"tbl_Workflow_Detail")

[scott192 · Accepted solution]

Also, if you don't wish people to have edit functionality on your detail view, just hide the Edit button?  Set the Behaviour to FALSE in the Edit button definition...

[Chosk]

YayYyyyyyyyyyyy

This worked!!!

Thank you so much!!!