GAS begier is stuck with a problem of retrieving all condition-matching values from a loop in Google Apps Script.
One of the columns in my spreadsheet has dates. Conditional operator if (formattedCheckInDate == formattedTodaysDate) { inside a loop for (var i = 0; i < data.length; ++i) { comparing those dates to the current date to check if they match. If they match then get values from other columns in a row with a date matching current date but then continue looking over the dates to check if another date in a column is also equal to a current date.
formattedCheckInDate GuestName
10/08/2016 Aa
09/08/2016 Mary
10/08/2016 David
11/08/2016 Peter
After all current-date-matching values have been recognised I need to send them in a single email:
Hi,
<Other column values of a *first found* current date matching row>
<Other column values of a *second found* current date matching row>
<Other column values of a *third found* current date matching row>
...
<Other column values of a *N found* current date matching row>
Having an example data above, here is what I should finally get inside a single email (i.e, if today is August 10):
Hi,
Aa
David
Hope for your assistance and cooperation. Please give examples of solving my problem.