Skip to main content

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!

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:

  • When a record is updated
    Watch the date field of Table A
  • Find records
    Find multi-select dates in Table B that contain any of the dates in Table A
  • Update record
    Update list of mentor names in the Single line text field
    or update the list of record IDs in the Record Link field

How about this?

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

Reply


Terms & Conditions