Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 21, 2023 12:49 AM
Hi, sorry in advance if this question has already been answered.
I would like to compare two sets of date from different table, in the Table A I have a field with single select date that i want to compare with the Table B with multiple select, if in the Table B one of the data is the same I want to show the name of the person.
If you need a context, I want to see the mentors that can help a student from a field that they choose, the mentors have given us many area of expertise and the student just one area of expertise, so from those two datas i want to do the matching and see the name of the mentors that can help this student.
Thanks in advance!
Jul 21, 2023 05:32 AM
Hi @Emmasu ,
It is possible with automation.
Automation is triggered when a single select date is entered and updated in Table A (student list).
The mentor must be asked to enter the date in advance.
Automation:
How about this?
Jul 22, 2023 03:39 AM - edited Jul 22, 2023 03:40 AM
You could also try creating a new table called "Expertise" and converting your select fields to linked fields to that table. You can then just add a lookup field in Table A to pull over the Mentors that have that expertise set