Welcome!

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

0

0
Sonia Fernandes
On 11/10/22, 5:23 PM

What you need is a table to store the phase and the sum of the commissions in each phase. 

Please see below the example and see if this helps:


  • Flag

Thank you Sónia!

Thank you Sónia!

Each user should see only his opportunities. Should I create a third table named Fases_Users?

Andre Marques
on 11/11/22, 9:44 AM

How are you defining users? Through the PSW table?

You can use our EPH pattern allowing limit the application's content to the tables associated with a user's login:

https://geniodoc.quidgest.net/patterns/permanent-history-entry-phe

Sonia Fernandes
on 11/11/22, 12:47 PM

Yes, I'm using PHE. Users see only what they insert, but the Main table "Fases" that contains all the sums, users see all sums from all users together :/

Andre Marques
on 11/16/22, 10:42 AM

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

45 follower(s)

Stats

Asked: 11/7/22, 5:32 PM
Seen: 845 times
Last updated: 11/10/22, 5:23 PM