Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

Hide Intro Register

Conditions for table based on other table that has foreign key to first table

Par

Phil

sur 23/12/2019 10:04 • 1 510 Vues

If you need to set a condition (for example, background color in a list) based on if a row's primary key is the foreign key of a row in another table, how can this be done in Genio?

So, if table A has any rows with a foreign key having a value of the primary key of row X in table B, we set the background color of row X in table B.

Signaler

Répondre
Commentaires
Partager

João Ferro

Activé 23/12/2019 10:16

Hi Phil,

If I understood the problem correctly, I think one way to achieve what you want is to use a related sum (SR) to count the number of A records in B, and use that field in the background condition of your list.

Commentaires
Signaler

Ask a Question

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

15 follower(s)

Stats

Asked: 23/12/2019 10:04
Seen: 1510 times
Last updated: 23/12/2019 10:16