Currently I have tap called ‘WorkHour’, where people log hours with a form.
Then I have an inline list set to card and restricted to showing only 1 record (I’ve seen other people use cards to show summaries, but not sure this right way around this?)
Finally i tried to make a rollup for salaries - somehow hoping it would automatically split it out pr user - but it off-course rolls everything up. I also played around with filtering, but no matter what I do It does not work.
It’s an integer that represents the Year and Month. ie. for today you will get 202210.
Whenever you’re wanting to match one date to another, it’s always best to first convert them to either integers or a string. This is because dates contain a time component - which isn’t always apparent - so direct comparisons can lead to unexpected results.
Not directly. Again, there are a few ways to get a Month name from a Date. Some people might suggest that you use the Format Date plugin. I won’t do that, because I don’t trust it. But you’re welcome to use it if you want. Here is what I do:
Add a column somewhere (anywhere) that lists the Month names - Jan to Dec in a single column
Determine the Month index number using the following math:
Month(Date) - 1
Add a Single Value column that takes From Start->Month Index, from the column that contains your list of month names.