ContributionsMost RecentMost LikesSolutionsRe: How to conditionally show a report on a formThis is a great example and explanation, Thanks! Since I'm only capturing First day onsite (FDOS) and Last day onsite (LDOS) I wasn't able to filter all the dates by User then search these to see if they matched my entered dates on the form, I needed all the dates in between as well. To do that I created a new table "Dates", loaded 30 yrs of dates in it. I then use the following query: //Fid6 = First Day Onsite //Dates table = bs2n4hd8k var text Query = "{6.OAF.'"&[First Day Onsite]&"'}AND{6.OBF.'"&[Last Day Onsite]&"'}"; (GetFieldValues(GetRecords($Query,"bs2n4hd8k",6)) This returns all the dates the User is scheduled based on the User entry "FDOS" and "LDOS" on the form. I included this field, "Dates Between FDOS and LDOS" on the form to check it and it shows these dates as soon as the FDOS and LDOS selections are made. The problem now is in searching the table for these dates. Here is the formula I'm trying to make work, it always returns 1 since the FDOS is is always in the list of dates for that record, and the resource name always matches the form entry. I had a version of this formula working, but changed a field or two and now I'm stuck. Formula Text Field: "Is FDOS Already Scheduled" //Fid52 = Resource Name - record picker from "Team Members" table //Fid78 = Dates between FDOS and LDOS - Formula Multi Select Text //Fid82 = ToText FDOS - converts the date field FDOS to text var text Query = "{52.EX.'"&[Resource Name]&"'}AND{85.CT.'"&[First Day Onsite]&"'}"; ToText( Contains( ToText( GetFieldValues(GetRecords($Query),82)),[TOTEXT FDOS])) The plan is to use this field as a trigger for an alert field, setup in Dynamic Form Rules ------------------------------ Jason Stricker ------------------------------ Re: How to conditionally show a report on a formI want to show up to two months of dates for the selected person, is that a ton? I could bring that down to 31 days to make the formula route work. The formula query and followup formula would be the ideal situation, that warning is what I'm after. I'm new to formula queries, I've watched a video and done the official Quickbase post readings in Help. I think I can figure that out. What would the formula look like to search the dates that match the person's name and alert? Does the query create a report? Thanks!! ------------------------------ Jason Stricker ------------------------------ How to conditionally show a report on a formI have a table that populates every day a person is scheduled from form entries. The goal is to show a report on the schedule entry form, so that when a person's name is selected from the dropdown it shows a report of their currently scheduled dates on the form. This is help prevent double booking. The embedded report filtered for: 1) Filtered by the person's name selected from a dropdown I know how to display data from the child table, but I'm stuck on the report. This entry form is in the same table as the scheduled dates Can this be done or will the form need to be saved before any information is populated? Thanks! ------------------------------ J. Striker ------------------------------