🆘 Complicated formula help please

Forum|Forum|5 years ago
October 1, 2020
29 replies
169 views

+14

RnJ
Inspiring

I have a scheduling base for Volunteers helping at Non-Profits. I am wondering if it is possible accomplish these with a formula?

I have attached a generic base to give you an idea of what i am looking for. I have entered the answers into the fields as an Example via text.

#1. Volunteering with -
If multiple volunteers are on the (same date, same location, same start time, same stop time), I would like column " :raising_hand_man: Volunteering with :raising_hand_man: " to show the names of each volunteer on the same detail.

#2. Double Booked -
If a volunteer is signed up for multiple details the same day I would like a column “ :eyes: Double Booked/Overlapping Shifts :eyes: ”, if they are double booked or have overlapping shifts.

#3. Relieving/Relieved by -
I would like two columns " :handshake: Relieving Volunteer :handshake: " & " :handshake: Relieved By Volunteer :handshake: " to list the names of those volunteers if applicable (ie. If one shift ends and another one starts. Shift one is 8:00am-10:00am, shift two is 10:00am-2:00pm, shift three is 2:00pm-4:00pm, etc.)

Thanks for any help you can provide!

Show first post

This topic has been closed for replies.

1
2

Forum|pagination.label 2 / 2

R

+14

RnJ
Author
Inspiring
Forum|Forum|5 years ago
October 7, 2020

Ok, I just found a little hiccup in the code and am having a tough time finding a solution.

For my “sameShiftRecordsexact” it is pulling in data if the chosen shift is within another shift and not just exactly the same.

I thought this part

    ((triggerValues.start <= x.start && triggerValues.stop >= x.stop)) &&

would just need

==

instead of

<=

but that didn’t work :frowning: Any help is greatly appreciated :slightly_smiling_face:

Like

+27

Kamille_Parks11
Brainy
Forum|Forum|5 years ago
October 7, 2020

Ok, I just found a little hiccup in the code and am having a tough time finding a solution.

For my “sameShiftRecordsexact” it is pulling in data if the chosen shift is within another shift and not just exactly the same.

I thought this part

    ((triggerValues.start <= x.start && triggerValues.stop >= x.stop)) &&

would just need

==

instead of

<=

but that didn’t work :frowning: Any help is greatly appreciated :slightly_smiling_face:

Did you set both <= and >= to ==?

Like

R

+14

RnJ
Author
Inspiring
Forum|Forum|5 years ago
October 7, 2020

Did you set both <= and >= to ==?

Yeah, when I change them both to == it is not recognizing anything for the “sameShiftRecordsExact”.

((triggerValues.start == x.start && triggerValues.stop == x.stop)) &&

Like

R

+14

RnJ
Author
Inspiring
Forum|Forum|5 years ago
October 7, 2020

Yeah, when I change them both to == it is not recognizing anything for the “sameShiftRecordsExact”.

((triggerValues.start == x.start && triggerValues.stop == x.stop)) &&

Disregard. I finally figured it out :slightly_smiling_face: Had to change this block of code to with the “toISOString”

Thanks again.

const sameShiftRecordsExact = shiftRecords.filter(x => {

return (x.start.toISOString() == triggerValues.start.toISOString()&&

    (x.stop.toISOString() == triggerValues.stop.toISOString()&&

    (x.location == triggerValues.location))

)

})

Like

1
2

Forum|pagination.label 2 / 2

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded