I want to encourage our users to use SharePoint lists instead of Excel, so far there are almost only advantages.
But the users need to enter amounts for accruals for every month. In Excel they have a column for every month, so when they enter the amount for dezember they are able to have a look at the last 11 month what amounts they entered. This is what they need in a nintex formular.
So my form does show some columns they have to enter first (cost center, type of costs, profit center, ...) and then I am displaying the current list they are working on under the form (using the "list lookup"-action in Nintex forms). I want the list to be automatically filtered by one or more of the values the users entered before (cost center --> lookup value; type of costs --> lookup value).
The "list lookup"-action shows me an error when connecting to the lookup values (for instance cost center). I can filter the list by a text value or with CAML, but this is static, I want the list to be dynamically filtered.