Users (name, role, group)
Sessions (session_id, name, qty)
Production Jobs (session_id, sku, qty, group)
I’d like to display a list of Sessions for the logged_in user. I’m struggling with this as group is a field in users and in production jobs but not in Sessions.
The link between users and sessions is only via Production Jobs but I don’t want to display each production job, just the sessions where a user has a production job - if that makes sense?
I’d be so grateful for any help - this is my first post and I’m a new user.
Are you linking the Sessions and Production Jobs as well? Or are the name fields just the same?
I’d recommend using SKU as the name field for production jobs, then having a relationship to Sessions. That’ll let you filter all of your lists to Users>Production Jobs>Sessions.
Who input production jobs data entry (total to make) ? Is it an admin of production department ? or production staffs that produce ?
Does group consist of production staffs (bobbie,alex,coco) or produced items (teal yrs 1-3,grey-marle,teal-adult)
session-sku is a summary of production jobs ?
session is a summary of session-sku by date ?
Just to make sure, that users collection hold credentials for accessing app, not necessarily used as data for data entry.
If your app is accessed by an admin of production department, then you need to create just for this user in users collection, while production staffs which may or may not belong to group can be recorded in other collection, such as production staff collection and production group collection.
In summary, users collection in Adalo refer to access to the app, such as data entry and viewing.
