Currently on iOS I’m able to group records Monthly automatically by date , is it possible to do by week?
Hi Prashant,
You can do that but you would need to write a Calculation field formula to extract out a week number from the current date, then group on the Calculation field. You can use the DATE() function to format a date into a week.
DATE([Date Field]; "w") for week of year
DATE([Date Field]; "W") for week of month
The second parameter is the date pattern value you can use to tell Tap Forms what part of the date to return.
See this link for more information on what patterns you can use:
http://www.unicode.org/reports/tr35/tr35-31/tr35-dates.html#Date_Format_Patterns
There’s also a link to it on the Calculations topic in the online user manual:
https://www.tapforms.com/help-mac/5.3/en/topic/calculation
Thanks!
Brendan
HI Brendan,
Thanks for reply , this is my first calculation , I’ve tried typing formula , it’s showing me blank , please see two screenshots
Attachments:
You must be
logged in to view attached files.
Have a look at the return type. It should be set to ‘text’.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
HI Daniel,
Setting this to text to works ! Thank you
Also, the [ ] is for fields on the iOS version only. The Mac version doesn’t need that as you’ve discovered because when you double-click on a field, it inserts a token into the formula.
Glad you got this to work.
Also, if you look at the formula editor, you’ll see a list of functions that you can double-click on to insert into your formula. You’ll also notice at the bottom of the formula editor window when you have a function selected, Tap Forms tells you how to use it and also tells you what the Return type of the function is. Use that info to set the Result Type to the correct Number, Date, or Text option.
Hi Brendan,
Thanks for the reply . You are right ,it does say what it returns ! I didn’t pay attention.
.
