This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
The new pivot tables in interfaces should give you this. In various bases we take the primary date field and then create subfields with formulas for some combo of year-month, and then we are able to use those fields in selecting and grouping.
There's definitely a bug in the forms in the interface at the moment, we have an interface which presents a form for the add record button, but it is not the form that is available to edit when editing the interface, nor is it the form that we have s...
Brilliant @kuovonne - thank you for doing the leg work.For anyone else looking for an extension of this formula that would cover a typical vacation of up to 24 days here's the expansion, using fields simply named Start and End:REGEX_REPLACE(CONCATENA...
