--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1c2fa8c6-3f89-46ff-8a3f-76c5ae790647o%40googlegroups.com.
Ross,
It is hard to give you advice if we do not know what the info looks like. Are these yes/no for timeslots or is it a date/time range or something else?
Perhaps it would be good to make a copy of your spreadsheet (anonymized) and share the link here for others to see then we can give you some pointers on how best to approach this.
Do specify:
Am sure there are others with questions on this as well. Will let them chime in.
--
In response, I offer you my special Ross board
🆘 Can someone test this link and tell me if you can open it only for reading? before I post it to the other group. Thank you. 🆘
1) I used the checkboxes to simplify the data entry in the planning and also to simplify the sorting.2) The 'TRI' tab allows you to sort by Course AND by Day3) All Formulas and MEFC are on the 'Formule_Mec' tab4) This table is read, you can make a copy via the 'File' menu.
Le jeudi 3 septembre 2020 19:39:17 UTC+2, Ross a écrit :
Hey all,
I've created a spreadsheet with data input from Google Forms, with the purpose to find members with matching schedules.
Members have their course of study listed in Column A, and their schedule marked by √-marks in Columns C-I (days of the week).
I would like to have the functionality of pairing members with schedules that match 2 or more times.
I'm having a struggle wrapping my head around how best to go about this, any help would be appreciated.
My initial thought is when a new member is entered, get all previous members with matching course of study in Column A.
The new member's Columns C-I would then be compared to the previous course-matched members, but what would be the most efficient way to compare them? And what would be the best way to track having 2 or more values in Columns C-I in common?
The end goal is to have the members in common set to a temporary sheet with all cells in their row present, as the list of matches will be formatted to be emailed to the new member.
Too crazy?
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ed61c28c-d94a-45a0-829e-fc81b9e8bd6fo%40googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.
Hi Emeric, I modified the link yesterday and ALL internet users can read the sheet
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ed61c28c-d94a-45a0-829e-fc81b9e8bd6fo%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/2a8f7521-22d9-4b01-84e5-6fe46354a372o%40googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ed61c28c-d94a-45a0-829e-fc81b9e8bd6fo%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ed61c28c-d94a-45a0-829e-fc81b9e8bd6fo%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.