Attendance Tracker
I am trying to build an app that will keep track of attendance by name based on the selected location of the plant. Ideally there is just a multiple-choice field at the beginning of the tracker of th...
Forum Discussion
Mark,
I think the issue is that it is backwards from what you were saying. The pipeline is searching if the Employee ID in this other table does NOT equal (or contain, I tried that as well) the Employee ID from the Multi-Select Field that could potentially have multiple Employee IDs selected.
My other thought with this if the pipeline itself cannot do this is some formula that would parse out the responses of the multi-select field into individual separate text fields, and then I can have the pipeline ensure each of those is not contained in the search. Is that somehow possible?
- MarkShnier__You
Qrew Legend
re this:
The pipeline is searching if the Employee ID in this other table does NOT contain, the Employee ID from the Multi-Select Field
Can't you just flip the two fields in the pipeline filter to check if the multi select field contain the Employee ID?
I am not able to since I am searching the records that are generated from the daily attendance tracker (similar to what you had suggested in the first step) in a table. I am searching each record that was generated each day to see if it matches the area and shift of this other table's form to update all records of that area at once via that second pipeline. So the only filter I can have in this step is for the table of records I am searching, not the original one that I am comparing to. See attached of this step in the pipeline.
- MarkShnier__You
If you like you can email me directly and I will have a quick look with you on zoom. mark.shnier@gmail.com
