Unanswered

Checking availability on a date from another table

Like (0) Share

Report

Posted on 6 Feb 2024 12:49:27 by panxkruger

Hi Experts.

I have a desk booking application template from Aprill Dunnam. I wanted to convert it to book cars by the hour, but I can't show the cars available after a given hour in the gallery. Do you know how to fix it?

This is oryginal code:

I tried modifying it this way:

Filter(
 Sort(col_Desks, Title);
 Not(
 Title in 'Desks Reservations'.DeskText
 ) && 
 (
 IsBlank(LookUp(
 'Desks Reservations',
 DeskText = col_Desks.Title &&
 (
 ('Check Out From' >= startTime && 'Check Out From' <= endTime) || 
 ('Check Out To' >= startTime && 'Check Out To' <= endTime) ||
 ('Check Out From' <= startTime && 'Check Out To' >= endTime)
 )
 ))
 )
)

but it still doesn't work, any suggestions?

Thanks 🙂

All responses (2)

Answers (0)

panxkruger on 07 Feb 2024 at 08:50:26

Like (0)

Report

Re: Checking availability on a date from another table

Hi, I don't have a car collection. The tables are called desk in the same way, i.e. Desk Reservation and Desk. Collections are col_desk, col_reservation
Shaheer Ahmad 2,194 Moderator on 06 Feb 2024 at 14:20:28

Like (0)

Report
Re: Checking availability on a date from another table

Try this:
Filter( Sort(col_Cars, Title); Not( Title in 'Cars Reservations'.CarText ) && ( IsBlank(LookUp( 'Cars Reservations', CarText = col_Cars.Title && ( ('Check Out From' >= startTime && 'Check Out From' < endTime) || ('Check Out To' > startTime && 'Check Out To' <= endTime) || ('Check Out From' <= startTime && 'Check Out To' >= endTime) ) )) ) )