Jill_W - profile

Jill_W · Jul 03, 2020

Hello: I have a multiple select field with one or more dates. I want to count the number of dates and then filter the people with with 2 or more. I also want to eliminate people with whom we have not had contact with in more than 2 months? In if ...

Jill_W · Jul 05, 2020

Thank you for clearing that up Justin. look forward to your response.

Jill_W · Jul 04, 2020

So I have 4 tables in my base: Recipients Volunteers Delivery Dates Pantries PLUS I have one Junction Table, Recipients/Volunteers that links to: Name | Recipients Link | Volunteer Link | Delivery Dates Link a) Do I need to now create a field in the ...

Jill_W · Jul 04, 2020

So that this is as efficient as possible, please allow me to present a scenario: Employees / Volunteers: Ant, Bee, Cheetah Clients: Zed, Yuri, Xavier, Walter Dates of delivery: 5/15, 6/15, 7/15, 8/15 Food Source/Pantries: Location X, Location Y On ea...

Jill_W · Jul 04, 2020

One more thing: In the scenario that you presented, what if I wanted to continue to track the clients who we delivered to/made contact with on specific dates? As in Image B) above…Delivery Dates table?

Jill_W · Jul 04, 2020

I read your notes again and the suggestion of a primary field in the junction table {Contacts}. Would that change after each contact/delivery with a client…since the different employee/volunteer will have contact with a contact on different dates?

User Statistics

User Activity

Manipulating Dates in a field

Re: Manipulating Dates in a field

Re: Manipulating Dates in a field

Re: Manipulating Dates in a field

Re: Manipulating Dates in a field

Re: Manipulating Dates in a field