I have a table called "Clinics" and a table called "Batch Orders". Each clinic has multiple batch orders.
In the table Clinics I have a field called Clinic Account Managers - a user list. This list is unique to each clinic. Each user will have one assigned clinic. In the table Batch Orders, I want to Auto Populate a field's value based on the current user so they do not need to manually do so. The field I want to auto populate is the Clinic Profile Name. Based on the current user, this field would auto populate to the user's assigned clinic, based on the field, "Clinic Account Manager". I do not want to user to have to manually identify which clinic they are assigned to as they will only ever be assigned to one.
I have tried a rule on the form to auto populate this field but it is looking for a manual input of which clinic the batch is assigned to. Is there a way around this??? PLEASE HELP!
How about if you have a dashboard report titled "My Clinics". It will be a report where the filter is that the User List in the clinic record "INCLUDES" the "Current user".
So for each Clinic manager, they will just see one record - their own clinic.
Then include the typically ADD Batch Order button which the relationship created for you on that report. So to add a batch order they would launch off that report and the field [related clinic] will automatically populate for them. That report could also be set as the table home page report for the Clinics table.
Let me know if that answers your question and i will convert this comment to an Answer to close it out.
IF[Clinic Profile - Clinic Account Managers]includes[Current User]then, [Current User's Assigned Clinic] is equal to that[Related Clinic Profile]
I haven't gotten much into IF statements so I know the above is incorrect use but just to give you an idea of where my head is at with this.
The alternative method is more complicated. You would need to set up a table of all your clinic managers with the Key field being their userid. Then make a relationship where 1 clinic has many clinic managers so that Clinic manager table has the information as to which [related clinic] they work at.
Then on the batch orders table make a formula user field called Current User with the formula current user. Then make a relationship back to the Clinic managers table based on the Current user field and do a lookup of that related Clinic field calling it [record ID of the Current User's Clinic].
Then, finally, a form rule thats says, where the [related clinic] is blank, then change the value of the [related clinic] to the value in the field [record ID of Current User's Clinic]