Multi select Text Functions
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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
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?
- MarkShnier__You
OK, 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?
I have a meeting Form that has all the notes, Videos, from the morning meeting as well as a attendee list ( the multi select field ) to capture who was present for the meeting but the employee list has grown past 200 people recently each location does 1-2 meetings per day every day there is 15 locations and growing
