Trying to do an initial time by linking my start times to my reference list times. The filter isn’t working. When I do a search for a filter that way it works however I have to format my start date to match my reference date that’s why I was planning on using adv filtering.
it likely is filtering but taking a long time to process due to the complexity of that query
if you are comparing X to a list of 1000 things and formatting 1000 things values before comparing… well that’s quite intensive to do.
rethink how you do the query to simplify the request - possibly bring data forward in the data structure so you don’t need to do a nested advanced filter client side but can instead do a search server side.
Can you provide a bit more context? What are you showing in that table and what are you wanting to do with that initial input’s value?
Also, just a heads up for advanced filters…the ignore empty constraints option does not work. The equivalent would be to append this expression to the advanced filter: or Search for Time - Cards:each item's Start Dates:first item is empty
There’s only one thing in the database at the moment.
I want to display the time card’s start and end dates alongside the corresponding row, based on whether the current user has already submitted a time card.
I’m aiming to create something similar to this: Time Card Calculator | TimeSheet Calculator | Hours Calculator. I’m showing the first value, but I have three key dates: a Reference Date, Start Date, and End Date. The Reference Date is shown in the table. I’m using logic to match the Start Date to the current row’s Reference Date.
When I check the debugger, it shows all the dates correctly, just looks like it ignoring grabbing the first date the corresponds to reference date.