Hello! I am really hoping someone can help me. I need to create an app where my customers can put in their wedding date and it will calculate important dates leading up to their wedding. Ie: Wedding Date 25/11/2021 Makeup & Hair trial (-2 Months from wedding date) 25/9/2021 First Facial Treatmen…

Hey ! First of all, welcome on board the Glide Community ! If you need assistance, our friendly members will always do their best to help you ! (Help us help you :slight_smile:) About your issue, I think that the following link can give you some valuable advice :arrow_down: [image] …

Thank you this has helped a little although I am still really confused on how to make the data interactive for the user. Ideally there would be a date selector on the app where once putting in their wedding date, a list of suggested appointment dates would appear. Is that even possible?

What is the logic you want for the “suggested dates”?

So I am trying to design a 12 month guide based on the wedding date. EG. Last facial waxing - 2 weeks before wedding date Hair & Makeup trial - 2 months before wedding date Last Hair Colour & Cut - 6 weeks before wedding date Initial skin consultation with beauty therapist - 8 months before wed…

@Jeff_Hager would your trick here work with this? [image] Fun with Dates Project Showcase I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right no…

"Calling @Jeff_Hager , calling @Jeff_Hager ! :loudspeaker: :loudspeaker: Date Math assistance required in aisle 13!! :loudspeaker: :loudspeaker: " @Jessica_Vegas this will be possible using the Glide Math Column . I’m sure our resident expert will show you how :slightly_smiling_face:

Thank you - I really hope I can get this to work as the one I created on Grid looks so dated and unprofessional. SNED HELP :frowning:

So… subtracting any number of weeks from a given date is easy. When you subtract 1 from a date in Glide (using a Math Column ), you get the previous day. So to subtract a week, it’s -7, etc. [image] Jessica_Vegas: Last facial waxing - 2 weeks before wedding date That would look something like…

[image] Jessica_Vegas: Hair & Makeup trial - 2 months before wedding date Actually, a much better approximation would be to use 365/12 as one month (that’ll only be slightly off if a leap year is involved). So this column would be: [Screen Shot 2021-02-12 at 1.31.38 PM] And this one… […

Customer to input a date to generate a list relative dates

Ask for Help

ThinhDinh February 12, 2021, 1:41am 7

@Jeff_Hager would your trick here work with this?

Topic		Replies	Views
🆕 Date-time Math General data-editor	126	14080	September 27, 2023
Travel App w/ Trips, Days and Activities Ask for Help	62	319	July 17, 2025
Fun with Dates Project Showcase	156	6940	April 19, 2022
Create recurring calendar events in mobile calendars Feature Requests	23	3014	June 23, 2022
🆕 Format Date Plugin General	58	2557	August 22, 2022

Customer to input a date to generate a list relative dates

Related topics