Customer to input a date to generate a list relative dates

Jessica, when I log into your app I land on a page that looks like this…

Each of the tiles in the list is a link to an external site/service.
I don’t see any other tabs or navigation options - should there be more?

Have you got any tab-visibility settings that could be keeping other things hidden?

1 Like

Question: Is this something you would want a user to see every time they sign in, or just the first time?

I have just fixed it up. The ‘Key Dates’ tab is only visible when the wedding date has been put in.

I would want the welcome page to be visible permanently, like the first tab they land on, preferably with a link to edit their profile so they can put all the data in they need to experience the wedding calculator function.

Is that possible?

Hi Aymen, I totally understand where you’re coming from! However my app will be used as a marketing tool at a trade show i am presenting at. They receive a printed paper copy of the date guide but if they want access to the digital one, they have to sign up :wink:

1 Like

So you can create another tab to do this. Preferably point the tab to the User Profiles sheet, and add whatever components you need to show case the “Welcome” part.

Then add a button that links to “this item” and show entry components for the “wedding calculator” function. Use conditional visibility as needed to show results.

Ok guys - have a look now, I think I have made it a lot more user friendly and aesthetically pleasing :wink:

Although, sometimes images won’t load in the app. Is there a reason for that?

1 Like

Any specific images? I didn’t notice anything missing when I checked out the app.

Hello, Greetings from Brazil, I have a similar problem, in an APP I need to enter a specific date (Day) and number of months that will be repeated Ex: day 05
repetition 36 months.
Next day 05 will be March 05 2021, this will be repeated for 36 months. I can’t imagine how this sum would do.

Would you want it to write 36 rows of data? I don’t think that would be a good solution because it would probably require some scripting to make that happen.

Instead, I think it would be possible to have a single row with a date column for the event date, a number column that stores the number of times you want an event to be repeated, and a template column that stores today’s date. Then you would need some additional math columns to figure out the number of elapsed months between today and the initial event date, then compare that to the total number of months you want that event to be repeated, and if it’s within that range, it would return the next date of the event. I’ve given this some thought for a side calendar project, but I haven’t really taken the time to work on it yet.

This could also be done with 36 math columns to hold each date. It looks like you’ve already seen my other posts regarding the math behind that.

1 Like

Thanks for the prompt reply Jeff. These lines will be variable as the number of months must be chosen. the rows in that column are on a tab that has more data rows than at 36, specifically. Thinking of an ID of the months adding the dates, but my problem is. how to repeat every day 05. that is
March 05 2021, April 05 2021, May 05 2021 … February 05 2024, … because adding up to 30 days wouldn’t be like that …

As I shared with you a couple of weeks ago, this would be the math to add any number of months to a date.

If I’m understanding you correctly, it sounds like you do want 36 (or any chosen number of months) separate rows. so then scripting would probably be the best way to handle adding additional rows. I would still consider a single row with date math that would dynamically update to the next occurrence of the date once the current date has passed. If I get some free time in the next few days I’ll see if I can come up with an example to explain what I mean. I do something similar in the example below, where an event can have a duration of multiple days. It only writes a single row, but the dates dynamically update every day until the duration has passed. It’s kind of a messy example, so it might be confusing to understand.

1 Like

Tks Jeff,
I don’t know if you understand. Customer chooses the day to win. Like day 05 (fifth day of the month) adding 30 more by default month I have these dates: 2021-04-04T00: 00: 00.000Z 2021-05-04T00: 00: 00.000Z 2021-06-03T00: 00: 00.000Z 2021-07-03T00: 00: 00.000Z 2021-08-02T00: 00: 00.000Z 2021-09-01T00: 00: 00.000Z 2021-10-01T00: 00: 00.000Z 2021-10-31T00: 00: 00.000Z 2021-11-30T00: 00: 00.000Z 2021-12-30T00: 00: 00.000Z 2022-01-29T00: 00: 00.000Z 2022-02-28T00: 00: 00.000Z 2022-03-30T00: 00: 00.000Z 2022-04-29T00: 00: 00.000Z 2022-05-29T00: 00: 00.000Z 2022-06-28T00: 00: 00.000Z 2022-07-28T00: 00: 00.000Z 2022-08-27T00: 00: 00.000Z 2022-09-26T00: 00: 00.000Z 2022-10-26T00: 00: 00.000Z 2022-11-25T00: 00: 00.000Z 2022-12-25T00: 00: 00.000Z 2023-01-24T00: 00: 00.000Z 2023-02-23T00: 00: 00.000Z 2023-03-25T00: 00: 00.000Z 2023-04-24T00: 00: 00.000Z 2023-05-24T00: 00: 00.000Z 2023-06-23T00: 00: 00.000Z 2023-07-23T00: 00: 00.000Z 2023-08-22T00: 00: 00.000Z 2023-09-21T00: 00: 00.000Z 2023-10-21T00: 00: 00.000Z 2023-11-20T00: 00: 00.000Z 2023-12-20T00: 00: 00.000Z 2024-01-19T00: 00: 00.000Z 2024-02-18T00: 00: 00.000Z As you can often see, the day that appears is not the fifth day of the subsequent month. By formula or IF I couldn’t do it.

[image]

Yes I understand. It’s not as simple as adding 30 days. That’s why I came up with that formula that I shared with you a couple of weeks ago and again in the post above. It should allow you to add any number of months or years to a date, but still get the same day number for any future date it calculates.

3 Likes

Jeff,
Greetings from Brazil, thank you very much for your help. But I did it by force, but I did it

1 Like