Looks like @huban beat me to the punch here. I’ll check out that solution… Mine is probably very similar, and I’ll post it here just because I spent a few minutes updating your file as well, and a few more taking notes on what I did. Here’s my post:
Repeater w dropdowns_and totals page-v2.rp (228.9 KB)
As huban points out, one thing to realize when using a repeater is the default row–the arrangement of widgets you set it up in the repeater–is the initial starting point when a row is created. If a widget is visible (in the editor), like your date field widget named “enddate” then it is shown by default, for each and every row, until and unless you hide it. If a widget has text, that text will remain until you change it–and if a widget does not have text, it won’t get text until you set it.
Another important thing to realize is that each time you change a repeater–adding a new row, deleting a row, updating, sorting, filtering, pagination, etc. the repeater gets rebuilt, row by row, starting from the default setup. So, if you change the text of a widget in a repeater dynamically, then add a new row, that text value will be lost–because that row will get rebuilt. If you want to retain an updated text value (or visibility, state, selection, position, etc.) you’ll need a representative column in the repeater dataset, and update that row to store the text value in that column before you change the repeater in any way–like adding a new row.
So, it might sound a little silly and redundant, but to hide the date field by default, you need to hide it by default (in the editor.) Then, in a conditional case in the repeater’s Item Loaded event, show it only if “Acting Pay” is chosen. You have the latter, but you’ll need to refer to the dataset, not “text on widget” --because when a row is created, the text on the “Additional Wage type” is blank–as it should be. Currently, your case reads, If text on Additional Wage type equals "Acting Pay" which will never be true. So the case should be something like, If [[Item.AddWT]] equals "Acting Pay" …and of course you’ll need to update the repeater row when that choice is made in your dropdown, not simply set the text.
Are you ever using Column0 in your repeater? If not, you can remove it.
A tip when referring to repeater properties (or any properties and built-in variables and functions) is to use the Insert Variable or Function… dropdown in the Edit Text dialog. This is more reliable and easier than typing it out manually (at least until you’re very familiar with Axure’s expression syntax.) It also shows you the full range of what’s available. Things like “index”, “isFirst”, and “itemCount” are very useful.
-
I changed the case logic for Case 1 to refer to the AddWT column value.
-
I simplified the actions to change only the elements associated with this.
-
The general things done in every row ("If true") are specified in only one case, to avoid extra work–but also avoid confusion and help with debugging.
-
I changed the "Else if true" to "If true" (right-click on the case to change this.) When you create a new case by default it is an "Else if" but you often need to change this.
-
I removed the "Show enddate" from the "If true" case, otherwise it will always be shown.
-
I added a case of If [[Item.isFirst equals true to initialize the global variable GV_total to 0. this is important, and is the root cause of why your total is not calculated correctly.
-
I added a case of If [[Item.isLast equals true to update the text on the widget, "total" and moved the Set Text total to [[GV_total]] from "If true" to this new case–because you only need to do this once per repeater update, not once per row.
-
I changed the droplist items code to update the row instead of just setting the text on this row’s widgets–because that will be wiped out as soon as a new row is added.
-
I removed “Hide enddate” as this is redundant. Likewise, no need to change the “Dropdown list 1” panel state as it will close when repeater is updated.
