I have an app that tracks employee hours and auto calculates total wages monthly per each employee.
Now, I would like to dynamicaly rename a column Total Wages whenever employee clocks out and thus recalculates all total wages.
Iโve used a concatenation formula in display field: "Total Wages "& [sum of all employee hours this month].
Iโve created virtual field โ[sum of all employee hours this month]โ which sums all employee total wages for this month.
But instead of column dynamicaly updating into (example):
-----Employee nameโTotal Wages (100 usd)-โClock InโClock Out
I only get Total Wages label.
-----Employee nameโTotal Wages-โClock InโClock Out
I hope I make sense.
Thank you in advance.
Did you โTestโ the column name expression?
In what kind of view are you looking at the column names? If in an โaggregateโ type View (like Table, Deck, Inline, Card, etc) this expression wonโt work. Itโll only work in a single-record view (Detail, Form).
Yes, itโs a Table view, so that means it wonโt work. Thank you for clarifiying this.
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |