Dynamically updating column

David_Hahn
Participant I

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.

0 2 121
2 REPLIES 2

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.

Top Labels in this Space