Limit Drop-down list to group entries
Limit Drop-down list to group entries
Hi, what do I put in the where clause of the sql query to limit the drop-down list of employees to only retrieve employees that were entered by users in my group. e.g. SELECT * from Employees WHERE `membership_userrecords`.`groupID` = [My Group]. What's the script for [My Group]?
Re: Limit Drop-down list to group entries
Hi,
you can have dependent lookup fields. Do not enter the first usergroup by hand, but select if in a lookup. In the next lookup you are able to see only those values having a match in the other lookup: https://www.youtube.com/watch?v=XQh-9S7yd34
Olaf
you can have dependent lookup fields. Do not enter the first usergroup by hand, but select if in a lookup. In the next lookup you are able to see only those values having a match in the other lookup: https://www.youtube.com/watch?v=XQh-9S7yd34
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Limit Drop-down list to group entries
Thanks for the response. However, there's no dependency like the Category/Books example. And, it's more tedious for the user to select his group for each entry. There is a relation between the Employee table and the `membership_userrecords` by the recordID (EmployeeID). I'm seeking to match the groupID from the latter with that of the current user's group. How do I get the current user group?
Re: Limit Drop-down list to group entries
Hi,
well, sounds like my question here: viewtopic.php?f=2&t=4098 which pbötcher said it's not possible
Please check the feature request (and comments) as well: viewtopic.php?f=6&t=4119
Olaf
well, sounds like my question here: viewtopic.php?f=2&t=4098 which pbötcher said it's not possible
Please check the feature request (and comments) as well: viewtopic.php?f=6&t=4119
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Limit Drop-down list to group entries
Cheers, I checked out the posts. Thank you