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.
This topic was automatically closed after 70 days. New replies are no longer allowed.