topic Re: Help with formula in Application Development and Automation Discussions

Help with formula

Torabi — Tue, 11 Jun 2024 13:10:59 GMT

Hello,

To display today's date, I have used this formula:

The result will be: 11 Jun.
What formula should I use to display tomorrow's date (12 Jun) or yesterday's date (10 Jun)?

Re: Help with formula

marihirvi4 — Thu, 20 Jun 2024 09:45:37 GMT

You can use ADD_DURATION and SUBTRACT_DURATION together with FORMAT_DATETIME_LOCAL to format the date:

Re: Help with formula

Torabi — Fri, 21 Jun 2024 16:01:25 GMT

Hi Marihirvi,
Thanks, it worked perfectly.
I have two more questions please:
1. Now when I use formula in my Soft tabs to display (yesterday, today and tomorrow) dates, (20 Jun, 21 Jun and 22 Jun) is displayed.

What should I add to the formula NOW("D MMM") to display today's date with label: Today?

2. When I launch the app, I want the Today tab to appear in the middle of the screen by default. Right now I have to swipe left to see it.

Thanks in advance for your help

Re: Help with formula

Dan_Wroblewski — Mon, 24 Jun 2024 06:04:58 GMT

You mean to look like this:

NOW("D MMM") + " - Today"

Re: Help with formula

Dan_Wroblewski — Mon, 24 Jun 2024 06:10:31 GMT

For the spacing, do you mean something like this:

If you open the style for the soft tab you can play with the alignment:

Re: Help with formula

Torabi — Mon, 24 Jun 2024 18:35:49 GMT

Hi Dan,
Thanks for your reply.

No, I mean it like this:

Re: Help with formula

Torabi — Tue, 25 Jun 2024 06:57:44 GMT

Thanks for your reply
No, it's not about spacing!
Right now the first tab is visible on the left and after it comes the second tab and third and so on.

What I want is that "Today" should always be visible in the middle of the screen and when you want to see other days, then you can swipe to the right or to the left.
Like this:

Re: Help with formula

Dan_Wroblewski — Tue, 25 Jun 2024 06:24:57 GMT

So can't you just make it static text to "Today"?

Re: Help with formula

Dan_Wroblewski — Tue, 25 Jun 2024 07:24:57 GMT

Hmm, well you can put the softtabs in a scroll view and the user can then see all the tabs by scrolling, but I don't see a way of putting Today in the middle. You can use the Layout > Position property to reposition Today to the middle of the visible area, but then you'd have to create your own scrolling capability (not really scrolling more like moving).

You could simply start with yesterday, today and tomorrow and add a previous button and a later button to, for example, remove the last item and add a new item to the end of the list. This would be pretty easy to do.

As far as I know the position of the scrollview is not retrievable and there is no property to set the position of the scroolview.

Re: Help with formula

Torabi — Fri, 28 Jun 2024 12:59:40 GMT

Thanks Dan for your reply.
Ok, but what formula should I use on the left button and the right button?

Re: Help with formula

Dan_Wroblewski — Fri, 28 Jun 2024 13:41:50 GMT

I'm not clear what you would like to do or how you want the softtab to work or what to display. Perhaps it would be helpful to show a little more of what you want.

In the meantime here is one behavior you could create:

I created a page variable that initially has today's date and the soft tabs use formulas (as Mari showed above) to display yesterday, today and tomorrow. The previous button then simply updates the page variable to yesterday with a "set page variable" flow function and the following formula:

ADD_DURATION(pageVars.CenterDate, -1,"days")

The next button is the same except it is +1.

We could play with the spacing so it does not resize with every new date, or we could show more dates, or we could keep the selected tab more logical, so if the today tab is selected and we click "Next" the first tab would now be selected. You could also have a date picker to move more than 1 day at a time.

I think you can get almost anything you want. Just let me know what precisely you want it to look like, and how the content of tabs should respond, and I'd be happy to help further.

😺

Re: Help with formula

Torabi — Fri, 28 Jun 2024 19:17:52 GMT

Thank you so much Dan for wanting to help me.
What I want to do is connect a Google sheet via rest API to Soft tabs. The connection with rest API works well, but want to connect it to a table and control it via Soft tabs
To give you more understanding about what I want to do, I can send you an example as a gpg-fill.
Where can I send it?