I am trying to get a field to be mutli select for a list of employees all the choices are over 100 I'm wondering if there is a way to filter the field by location which would put the field below 100 choices everytime. Is this possible?
Qrew LegendI do not recommend using a multi select field for this purpose as you will be very limited in your future reporting, for example, to be able to report on which employees attended, which meetings.
A better solution is to set up how many to many relationship where one meeting has many meeting attendances and one employee has many Meeting attendances.
Then, on the employee record, you will have an embedded report of their meeting, attendances and of course, on the meeting record, you have a meeting of all the meeting attendances is as well, (the employees who attended)
If you find that adding the employees is too slow there are faster ways to add the employees, but that would require a one-on-one consulting session with me.
Qrew LegendI think your best option here might be to have multiple multi select fields for each location and then use a formula to combine them all into one result when viewing a record
To do this.. would I just need to make a separate table for every Location of employees then use the formula to combine and show results in reports?
Qrew LegendOK, I gather these traces are coming off entries on a table. Me truthfully, the best way to go here is to set up a proper relationship where say one project has many resource assignments and one team member has many resource assignments and then you're adding child records that way. Typically how many assignments are you making?
