First, I am a hardware guy and this is my first experience with lowcode. I have a table titled staff and a related table called certifications. I want to be able to see the certifications of a particular (selected) staff, member. For the life of me I can't figure out how to display it.
Everything shows properly in the tables themselves but not on the "form"
Hi @JoeF-45e8,
Thank you for reaching out and welcome to the community.
I tried recreating the scenario you mentioned as follows:
I have created two tables: Staff and Certification.
The Staff Member column in the staff table is in contact format.
The certification table has a staff column which is a rowlink and picklist format with source table as Staff.
A screen has been created and a column list added to display a list of all certifications for logged-in users, using a filter expression under the data tab on the far right of the screen. Below is the expression I am using.
=filter(certification,"certification[staff][Staff Member]=$[SYS_USER]")
Below is how it shows the certification of logged in user.
Hope this is helpful. Feel free to reach out to us if you have any further question.
Thank you and this is helpful. However, I need for administrators to see the certifications for any staff member not the user that is logged in.
This is being used to track training for staff members and send alerts when training is due etc...
Joe
