Matching similar time frames between tables

Question

Hi,I'm looking for a possible solution to the following situation.I have a table for providers who have a certain availability, as well as a table for clients that have a certain availability.&nbsp; I'm trying to match up clients with providers, depending on these availabilities.&nbsp;&nbsp;For example, if a provider has an availability from 10am to 4pm, and several clients that have availability in that range, is there a way to show a list (report) of the clients in the providers record?&nbsp; Say I have 30 clients, and 5 of them are available in that time frame, how can I match them up?&nbsp; Of the 5 clients, they fall within that time frame, but not exactly.&nbsp; One might be available from 12pm to 3pm, another 10am to 4pm another from 11am to 2pm, etc.I want to be able to show these possible clients on the provider record, so someone can see if there is a good fit, and assign the client to the provider if they decide to do so.&nbsp;&nbsp;Does anyone have a method they can recommend to accomplish this?&nbsp; Can it be done using native Quickbase features?&nbsp; I realize this isn't a simple task, but I don't want to spend a lot of time trying ideas that would end up going nowhere.&nbsp; Any tips or help would be greatly appreciated.&nbsp;&nbsp;Thanks!------------------------------Dana Hauser------------------------------

markshnier__you · Answer

Are these 1 hour meetings?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

... and do they all start on the hour?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

danahauser · Answer

Hi Mark.&nbsp; They could be an hour, but could be several.&nbsp; The providers are working with autistic clients that have different needs, so the times will vary.&nbsp; They might be there for 2 hours, or it could be 5, etc.&nbsp; It's an ongoing schedule every week.&nbsp; They would go at the same time each week for the same amount of time.&nbsp; Every morning at 9am till noon for instance.&nbsp; The time frame is known, but varies between clients.&nbsp;&nbsp;I basically want to see which clients have time frames that fall within the providers time frame.&nbsp; A provider may work from 9 to 5, but could have several clients.&nbsp; One in the morning, one mid day, and one later.&nbsp; A staff member would look at the potential clients and then manually decide if there is a good fit for the providers schedule.&nbsp;Thanks------------------------------Dana Hauser------------------------------

danahauser · Answer

The start times would be on the hour, or half hour.&nbsp; 3 to 5, 1 to 3:30, that type of thing.------------------------------Dana Hauser------------------------------

Forum Discussion

Matching similar time frames between tables

Related Content

Match date to End of Month (EOM) date

Fuzzy Match / Approximate Match in Pipelines?

Matching text and text list

Create a Dashboard from Multiple Reports with Similar Fields

Matching Fields between tables to populate third field