Is grouping on related tables possible?

[lec]

Hi,

I want to group a view on a column of the related table. Is it possible ?

Thanks.

[WillowMobileSys · Accepted solution]

Yes, but not directly.  You will need to add a column to the top-level table, pulling in (and yes replicating) the grouping value from the related table in your main table.    Then you can Group the main table on the new column.

[lec]

Hi,

While I thought it would be easy to pull the field value from the referenced table, into the main table, I ran into problems doing so.

As an example, I have a created a field in the main table (query) called 'index' of type text and in the referenced table (timeline) there is a field called 'status'.  I want to put the value of field status into index. I used the formula in table query in the index field as timeline.[status]. However the value it pulls is the status value of the first record in timeline table for all index values in the main table, instead of pulling the correct record value for all values in the main table.

How can I pull the corresponding status values for each record instead of the first row value of status being assigned to each record in the main table. I hope this is clear enough to understand.

Thanks.

[Steve]

How would the app know which row to pull the value from?

https://help.appsheet.com/en/articles/2357309-lookup

[lec]

Correct. It is unable to do that which is why it picks the first value of the status column from the timeline table. Will this be only resolved using actions or is there a simpler way for it to be able to identify the correct row?

I would just like to elaborate the table relations.

The two tables query(main)  and timeline(related) are connected using a Ref on client ID which is present in both tables.

query  needs to update -> index column from the Status column in timeline.

Thanks.

.

[lec]

Thank you. It's the replication that I was trying to avoid.