Jump to content
  • 0
valentid

Date Query

Question

Hi All,

I am wondering if someone might be able to help me. I am trying to make a rooming list in Caspio and I am struggling a bit with Syntax of Caspio formulas. I need to put a "1" in each column where the check in date is less than or equal to that night's booking date and check out date is more than that night's booking date. My formula in Excel looks like this:

=IF((AND($D19<=J$1,$E19>J$1)),1,0)

Where D19 is check in date and J1 is the night in question and E19 is Check Out Date.

Is there a way to do this kind of calculation within caspio?

Thank you so much in advance if anyone can help!

Dawn

image.thumb.png.a22f79f673fe737231e06f4640d9b55b.png

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi @Meekeee, 

Thanks for coming back to me. Essentially I just want to have a table that shows a 1 under each date to show that a room is needed for that person on that night. This is the way the hotel expects to receive the rooming list so I would like to try and do this in Caspio rather than manually offline.  So if the check in date is 25th Jan, I need a 1 in a column that's named 25th Jan and then every night until the check out date. 

Hope that makes sense but please let me know if you have any other questions.

Thanks,
Dawn

Share this post


Link to post
Share on other sites
  • 0

Hello @valentid,

I have an application in which I have solved a similar case.

The purpose of this app is to track booking request.  

I have deployed a simplified version of this app at the following site: https://sites.google.com/view/caspio-booking-app/home

This app requires 2 Datapages, 4 Tables, 1 Triggered action.

Datapage:

  • Submission Form - to insert booking request.
  • Calendar Datapage - to show all request made for different users.

Tables:

  • Users_tbl - holds information about users;
  • Booking_request_tbl - holds information about booking requests;
  • Booking_days_tbl - holds information about each day booking was made.
  • Booking_Period_Lu - lookup table used in Triggered action.

Triggered action - used to insert booking period data to Booking_days_tbl as a separate date.

077a0bdf1ac0.png

Hope this helps.

Regards,

vitalikssssss

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...