how to display result from display list with maximum control?
Question

Hi All,


Currently i am doing the Booking system. 

Let say i have table A and table B

Table A is the schedule of timing

08:00

09:00

10:00

11:00


and


Table B is store the appointment

John      08:00

Eric        08:00

Jenny      09:00

Mike    08:00


so, i wan to make it when Table B 08:00 already three booked, it will not list again for Table A when using access to the booking system.

It is urgent, coz i need to do the Covid Swab Test Booking system.


Hopefully you can provide some sample.. it will be easy for me to understand.


Thank you



samplecapture.png

Hi, 


Use the Count aggregate function to SwabAppoinment.Id, and the filter it by group

See example below:


Hope this make sense and helps you!


Regards,

Halo Marco,


thanks for your reply.

After i follow ur method, i got error from the display list. Look like the table and field missing.

What to do next?

thank you for ur help.


Appreciate

samplecapture1.png

small correction to this aggregate : it should be Schedule With or Without Appointment, to make sure Schedule slots that have no appointments yet, also show up.

Hi All,

After i Count aggregate function to SwabAppoinment.Id, and the filter it by group , now my Structure cannot use.

I need to structure to add my checkbox.

any idea?

Hi,

  • For the Date collumn to appear: apply the Group aggregate or Max aggregate fucntion against the Date Column
  • For the Time: apply the Max aggregate function on Time column
  • For the Please Select Column: Add New Attribute as default value False to the aggregation

Hope this help.

 


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.