Hello, Can someone help me? I want to display the last registration number(Licence plate no.) entered by the driver, but not based on date because Saturday and Sunday the drivers don’t work and I can’t put the condition “Date is within yesterday” in filter data. Only one registration number appear…

Great, I was hoping you would say that. That makes it a bit easier. So here is my suggestion. I’m not 100% certain this will work, but I think it should. You will need to add a column in your table to store the users email address (it’s good practice to do this anyway) Once you have that, in your…

You have a bit of a challenge there, because you are using a Big Table. Before I attempt to offer any solutions, let me ask you something. If you only want the last plate number, why are you offering that in a choice component? Seems a bit pointless to have a choice component with only one option…

I’m still learning, this was a solution for me at that moment. If you have another idea, I want to hear it

Okay, so firstly I would ask why you chose to use a Big Table for this? Generally the only time you would choose a Big Table is if you are expecting tens of thousands of rows to be added. Is that the case?

Okay. Sorry, but I have another question. Will the selected driver always be the user that is submitting the form, or could a user submit and choose any driver?

The selected driver will only be the user that is submitting the form.

I will try, thank you very much. :clap:

woah, that’s great! I’m always a bit nervous when I offer up semi-complex solutions like this without having an opportunity to test. Glad it jot the job done for you :+1:

“semi-complex”…don’t sell yourself short - I would call that complex. JavaScript.returnFirstItem(Joined List of Plates(Query(sorted by date)) = Latest Plate # is a great technique.

Filter data components

Ask for Help

Topic		Replies	Views
Does big table allow you to filter data based on if-else-condition value? (For Show API) Ask for Help	16	185	September 11, 2024
"Inbox" Filtering Ask for Help	3	187	July 10, 2023
Big Tables - I'm trying to create a Registration and Check In process but struggling with Big Tables Ask for Help	14	264	February 23, 2024
Why when I try to add a condition or an action or anything the choice is only to pick from the User Table? Ask for Help	8	32	June 9, 2025
Issue sorting Clients by latest Appointment when using Big Tables Ask for Help	1	20	January 15, 2026

Filter data components

Related topics