I run a library, where people check out tools and movies.
Borrowed items are due for return after two days, except if the due date falls on Sunday (when we’re closed).
How do I handle this using a custom formula?
One option I thought of is to create a collection of days (Monday through Saturday). But would this be treated as an actual calendar for scheduling purposes?
What you say is true, but then you will be unstuck by something relatively simple that you take for granted in most other applications.
This got simpler with Adalo recently adding more date format options. With formula you might be able to use the unix time stamp, being based on 01/01/1970, which was a Thursday. But as the above works and it’s simple, then why not.
Hi @Rozza ,
Nice solution, another alternative to avoid 2 buttons and visibility conditions on frontend, would be to add 2 click actions with a sometimes condition on both with same premises as you stated but using one button only: