Help with formula

[Torabi]

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)?

[Torabi]

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)?

[marihirvi4]

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

[Torabi]

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

[Dan_Wroblewski]

You mean to look like this:

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

[Torabi]

Hi Dan,
Thanks for your reply.

No, I mean it like this:

 

[Dan_Wroblewski]

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

[Dan_Wroblewski]

For the spacing, do you mean something like this:

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

[Torabi]

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:

[Dan_Wroblewski]

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. 

[Torabi]

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

[Dan_Wroblewski]

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.

 😺

[Torabi]

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?