# \#iterations **URL:** https://community.silverfin.com/tag/iterations/361.md [Latest](https://community.silverfin.com/latest.md) · [Categories](https://community.silverfin.com/categories.md) · [Tags](https://community.silverfin.com/tags.md) --- ## [CASE: unreconciled in fori (account templates)](https://community.silverfin.com/t/case-unreconciled-in-fori-account-templates/2398)
**Author:** [@Romy\_Vermeeren](https://community.silverfin.com/u/Romy_Vermeeren)\ **Replies:** 0\ **Last updated:** [February 2, 2023, 8:55am UTC](https://community.silverfin.com/t/case-unreconciled-in-fori-account-templates/2398 "2023-02-02T08:55:49Z")
In this case we are going to have a better look at how unreconciled indicators work in the background, and why it is not ideal to have them included in fori-loops. This only applies to Account Templates though. Reconci… --- ## [CASE: use persisted to hide parts of a loop](https://community.silverfin.com/t/case-use-persisted-to-hide-parts-of-a-loop/1413)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [February 28, 2019, 8:48am UTC](https://community.silverfin.com/t/case-use-persisted-to-hide-parts-of-a-loop/1413 "2019-02-28T08:48:32Z")
There might be some cases into where your fori-loop creates a whole range of inputs that need to be done, like below: If you are like me, you’ll find the extra loop with all of its fields a little bit too much. I wan… --- ## [CASE: create result tag in each loop](https://community.silverfin.com/t/case-create-result-tag-in-each-loop/1200)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 2\ **Last updated:** [June 20, 2022, 12:20pm UTC](https://community.silverfin.com/t/case-create-result-tag-in-each-loop/1200 "2022-06-20T12:20:38Z")
Let’s say we import certain data from a client, and we want to display each value of a certain column in a report template for instance: I’ll need to create a result-tag for each loop where data has been inputted. We… --- ## [CASE: create fori and group on certain values](https://community.silverfin.com/t/case-create-fori-and-group-on-certain-values/1195)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [September 17, 2018, 9:03am UTC](https://community.silverfin.com/t/case-create-fori-and-group-on-certain-values/1195 "2018-09-17T09:03:06Z")
Let’s say we import a whole bunch of data through the automatic reconciliation function in a reconciliation template. To make it simple, I’ll import all parts of a car with their expenses from a certain excel-sheet I’ve … --- ## [FYI Table with fori but with minimum amount of rows in output](https://community.silverfin.com/t/fyi-table-with-fori-but-with-minimum-amount-of-rows-in-output/977)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 0\ **Last updated:** [June 7, 2018, 2:41pm UTC](https://community.silverfin.com/t/fyi-table-with-fori-but-with-minimum-amount-of-rows-in-output/977 "2018-06-07T14:41:41Z")
Hi, I wanted a table with a dynamic amount of rows (in input) but with a certain minimal amount of rows in output. For those who would like to have something similar, this working code could be a starting point: ´´´ {… --- ## [CASE: display values of an object from a collection on one singular line](https://community.silverfin.com/t/case-display-values-of-an-object-from-a-collection-on-one-singular-line/397)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [September 13, 2017, 12:42pm UTC](https://community.silverfin.com/t/case-display-values-of-an-object-from-a-collection-on-one-singular-line/397 "2017-09-13T12:42:22Z")
Got the question just today: I don’t want to list all the directors in my text template. I would rather display them in one singular sentence, like “Tim, Joris, Sven” Is this possible? Yes it is If you take this code : … --- ## [CASE: how to use a fori-loop?](https://community.silverfin.com/t/case-how-to-use-a-fori-loop/277)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [May 24, 2017, 1:04pm UTC](https://community.silverfin.com/t/case-how-to-use-a-fori-loop/277 "2017-05-24T13:04:22Z")
Pretty important case, because our templates are full of fori-loops. First though: what is a fori loop? Let’s say you want to input a list of all the investments you’ve done. If you create following variable : {% inpu… --- ## [Creating a new comment](https://community.silverfin.com/t/creating-a-new-comment/1434)
**Author:** [@Tine1](https://community.silverfin.com/u/Tine1)\ **Replies:** 1\ **Last updated:** [March 21, 2019, 2:04pm UTC](https://community.silverfin.com/t/creating-a-new-comment/1434 "2019-03-21T14:04:32Z")
I would like to make a new comment but it doesn’t work when I try it. it works as a detail within an account but it doesn’t work to put it as an template like liquid assets. How do I need to change this to be able to i… --- ## [Liquidatiereserve reconciliation](https://community.silverfin.com/t/liquidatiereserve-reconciliation/663)
**Author:** [@Julie\_Vandekerckhove](https://community.silverfin.com/u/Julie_Vandekerckhove)\ **Replies:** 3\ **Last updated:** [March 4, 2019, 9:25am UTC](https://community.silverfin.com/t/liquidatiereserve-reconciliation/663 "2019-03-04T09:25:47Z")
Hi For my reconciliation for the liquidation reserves i would like to ad some calculations per selected account. In the code you’ll see below all the variables have the same name so they keep overwriting each other. B… --- ## [Creating a simple loop](https://community.silverfin.com/t/creating-a-simple-loop/1396)
**Author:** [@jhanley](https://community.silverfin.com/u/jhanley)\ **Replies:** 16\ **Last updated:** [February 22, 2019, 9:21am UTC](https://community.silverfin.com/t/creating-a-simple-loop/1396 "2019-02-22T09:21:07Z")
Hi, I’m trying to create a simple loop, where I would like a piece of code to loop X amount of times, based on a number selected in a drop-down field by the user. For example: {% stripnewlines %} {% t "Select number of… --- ## [Stop information being carried forward to next section](https://community.silverfin.com/t/stop-information-being-carried-forward-to-next-section/1381)
**Author:** [@neilmiller](https://community.silverfin.com/u/neilmiller)\ **Replies:** 11\ **Last updated:** [February 14, 2019, 9:19am UTC](https://community.silverfin.com/t/stop-information-being-carried-forward-to-next-section/1381 "2019-02-14T09:19:58Z")
Hi, I have the below coding for a stock rec I am working on. I am hoping to have the stock sheet in sections, e.g. Raw Materials, Cattle, Pigs (we deal with agricultural clients). I like the layout I have set up but am n… --- ## [CASE: how to create a fori-loop within a fori-loop](https://community.silverfin.com/t/case-how-to-create-a-fori-loop-within-a-fori-loop/802)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 6\ **Last updated:** [November 28, 2018, 12:53pm UTC](https://community.silverfin.com/t/case-how-to-create-a-fori-loop-within-a-fori-loop/802 "2018-11-28T12:53:03Z")
Let’s start with a practical example. Say we want to give in multiple persons, and for each person you want to put in several benefits in kind for that person. To create a fori-loop to put in multiple person, you can us… --- ## [CASE: create unique selectable account ranges](https://community.silverfin.com/t/case-create-unique-selectable-account-ranges/1261)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 1\ **Last updated:** [October 29, 2018, 7:00am UTC](https://community.silverfin.com/t/case-create-unique-selectable-account-ranges/1261 "2018-10-29T07:00:12Z")
Let’s say we create a forloop over an array, and each item of that array will be used to create a hashtag to select some accounts, like this: Of course, one account can not be linked to more than one categorie. So, h… --- ## [For loop: accounts do not appear](https://community.silverfin.com/t/for-loop-accounts-do-not-appear/1228)
**Author:** [@fbeirens](https://community.silverfin.com/u/fbeirens)\ **Replies:** 7\ **Last updated:** [October 2, 2018, 4:30pm UTC](https://community.silverfin.com/t/for-loop-accounts-do-not-appear/1228 "2018-10-02T16:30:39Z")
Hey, I adapted one of your templates. However, one of the for-loops (financiële opbrengsten) does not give the desired result: no accounts are shown, neither is the result. the code is shown below: {% t= "Rekening. Nr.… --- ## [How to sum up totals in P&L forecast](https://community.silverfin.com/t/how-to-sum-up-totals-in-p-l-forecast/1032)
**Author:** [@NickS](https://community.silverfin.com/u/NickS)\ **Replies:** 5\ **Last updated:** [September 7, 2018, 7:33am UTC](https://community.silverfin.com/t/how-to-sum-up-totals-in-p-l-forecast/1032 "2018-09-07T07:33:11Z")
Hi Sam, I want to add the following totals in the P & L forecast. Do you know a way I can do that? Operating income = Other operating rev + Change in work + Change in inventory. Gross margin = (Net revenue + Operating… --- ## [Split verslag algemene vergadering / aanwezigheidslijst](https://community.silverfin.com/t/split-verslag-algemene-vergadering-aanwezigheidslijst/1111)
**Author:** [@Evelyne](https://community.silverfin.com/u/Evelyne)\ **Replies:** 2\ **Last updated:** [August 13, 2018, 3:10pm UTC](https://community.silverfin.com/t/split-verslag-algemene-vergadering-aanwezigheidslijst/1111 "2018-08-13T15:10:02Z")
Hi, We would like to split the template of “algemene vergadering” in two templates. Algemene vergadering Aanwezigheidslijst How can we split it without losing any information that’s automatically filled in? Kind reg… --- ## [Foriloop inside a for loop](https://community.silverfin.com/t/foriloop-inside-a-for-loop/1104)
**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\ **Replies:** 4\ **Last updated:** [August 9, 2018, 9:31am UTC](https://community.silverfin.com/t/foriloop-inside-a-for-loop/1104 "2018-08-09T09:31:32Z")
Hi there I am trying to nest a fori loop inside a for loop (2nd level) with independent variables using the following code: {% for a in keys\_array %} {% fori item in custom\[a.key\] %} |{% input item.description %} {%… --- ## [How to assign actuals in a P & L to the correct financial year](https://community.silverfin.com/t/how-to-assign-actuals-in-a-p-l-to-the-correct-financial-year/1006)
**Author:** [@NickS](https://community.silverfin.com/u/NickS)\ **Replies:** 11\ **Last updated:** [June 20, 2018, 9:50am UTC](https://community.silverfin.com/t/how-to-assign-actuals-in-a-p-l-to-the-correct-financial-year/1006 "2018-06-20T09:50:48Z")
I’m building a simple Profit & Loss budget forecast tool. With this tool you can generate a quick scan budget forecast within a few seconds at the main level for a period of 5 years. If you choose, for example, financia… --- ## [Variable amount of custom variables](https://community.silverfin.com/t/variable-amount-of-custom-variables/995)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 2\ **Last updated:** [June 18, 2018, 1:57pm UTC](https://community.silverfin.com/t/variable-amount-of-custom-variables/995 "2018-06-18T13:57:41Z")
Hi there, I’ve got the following issue: in a template that I’m making (‘aandeelhoudersregister’), a first table is created where a variable amount of shareholders are defined (for example 4). On the basis of this inform… --- ## [Fori with pre-defined values](https://community.silverfin.com/t/fori-with-pre-defined-values/937)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 4\ **Last updated:** [May 30, 2018, 7:38am UTC](https://community.silverfin.com/t/fori-with-pre-defined-values/937 "2018-05-30T07:38:34Z")
Hi, Is it possible to add certain values in an input field in addition to certain pre-defined values (from an array)? Example: {% assign str\_ExiWetVer = ‘Christophe|Delphine’ %} {% assign arr\_ExiWetVer = str\_ExiWetVe… --- ## [Forloop with if-statement table layout](https://community.silverfin.com/t/forloop-with-if-statement-table-layout/821)
**Author:** [@Thijs](https://community.silverfin.com/u/Thijs)\ **Replies:** 14\ **Last updated:** [April 13, 2018, 6:29am UTC](https://community.silverfin.com/t/forloop-with-if-statement-table-layout/821 "2018-04-13T06:29:55Z")
The layout of a table is lost with following code: Code : |Wagen|Nummerplaat|Chassis|1e inschrijving|CO2|Fiscaal|Out op {% for wagenpark in company.custom.wagenpark %}{% capture wagenin %}{{ wagenpark.in-0 }}{% endcapt… --- ## [Two table formats in reconciliation template](https://community.silverfin.com/t/two-table-formats-in-reconciliation-template/757)
**Author:** [@Ugis](https://community.silverfin.com/u/Ugis)\ **Replies:** 2\ **Last updated:** [March 23, 2018, 3:36pm UTC](https://community.silverfin.com/t/two-table-formats-in-reconciliation-template/757 "2018-03-23T15:36:15Z")
Hi, I have two tables one next to another with different layout. When period is unlocked template looks fine however when period is locked second table definition is displayed as text and table structure is broken. I … --- ## [Template huurinkomsten](https://community.silverfin.com/t/template-huurinkomsten/535)
**Author:** [@Andrew](https://community.silverfin.com/u/Andrew)\ **Replies:** 16\ **Last updated:** [March 19, 2018, 10:39am UTC](https://community.silverfin.com/t/template-huurinkomsten/535 "2018-03-19T10:39:42Z")
In the template ‘huurinkomsten’ you can just input 1 amount of rent. Is it possible to add another input field if you have changing rentamounts ? Or give me the code so I can change it myself. Ex. Huur januari - juni 2… --- ## [Beroepskosten 2.0 - default accounts with categories](https://community.silverfin.com/t/beroepskosten-2-0-default-accounts-with-categories/543)
**Author:** [@Cedric](https://community.silverfin.com/u/Cedric)\ **Replies:** 14\ **Last updated:** [March 9, 2018, 1:36pm UTC](https://community.silverfin.com/t/beroepskosten-2-0-default-accounts-with-categories/543 "2018-03-09T13:36:11Z")
I’m trying to add default accounts to the cost categories in the template beroepskosten 2.0. I tried to do this by adding an new assign with the account numbers and by adding the ‘default’ in the input custom.some.accou… --- ## [How to retrieve historical information in details](https://community.silverfin.com/t/how-to-retrieve-historical-information-in-details/664)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 8\ **Last updated:** [March 6, 2018, 2:13pm UTC](https://community.silverfin.com/t/how-to-retrieve-historical-information-in-details/664 "2018-03-06T14:13:09Z")
Hi, Suppose I have a template with some details regarding the historical purchase of some stocks. Example: Date Stock Action Amount Cumulative 1/10/2013 A Purchase 100 100 10/10/2013 B Purchase 50 50 1/05/… --- ## [Clear nested fori-loops all at once](https://community.silverfin.com/t/clear-nested-fori-loops-all-at-once/668)
**Author:** [@b.dalle](https://community.silverfin.com/u/b.dalle)\ **Replies:** 3\ **Last updated:** [February 23, 2018, 9:20am UTC](https://community.silverfin.com/t/clear-nested-fori-loops-all-at-once/668 "2018-02-23T09:20:32Z")
Hello, In a template I noticed that I cannot clear the text that has been inputted for all fori-loops all at once. Is there somehow a way to link these two fori-loops so I would be able to clear the entire text of both… --- ## [Counting number of loops](https://community.silverfin.com/t/counting-number-of-loops/556)
**Author:** [@b.dalle](https://community.silverfin.com/u/b.dalle)\ **Replies:** 4\ **Last updated:** [February 21, 2018, 7:11am UTC](https://community.silverfin.com/t/counting-number-of-loops/556 "2018-02-21T07:11:07Z")
Hello again, I have some trouble with the next code: Bestuurder{% if bestuurdersaantal \> 1 %}s{% endif %}: {% assign bestuurdersaantal = 0 %} {% fori x in custom.bestuurders %} {% input x.persoon %}{% assign bestuurder… --- ## [Ifi-statement depending on fori-statement](https://community.silverfin.com/t/ifi-statement-depending-on-fori-statement/565)
**Author:** [@Cedric](https://community.silverfin.com/u/Cedric)\ **Replies:** 1\ **Last updated:** [January 5, 2018, 1:57pm UTC](https://community.silverfin.com/t/ifi-statement-depending-on-fori-statement/565 "2018-01-05T13:57:57Z")
Hi, I’m having some trouble with my ifi-statement in the code below. With the fori statement, nothing will be printed when there’s no content. But in the code below I have a first row that could be seen as title row, t… --- ## [Calculating with registers (amount of shares)](https://community.silverfin.com/t/calculating-with-registers-amount-of-shares/553)
**Author:** [@b.dalle](https://community.silverfin.com/u/b.dalle)\ **Replies:** 4\ **Last updated:** [December 27, 2017, 9:29am UTC](https://community.silverfin.com/t/calculating-with-registers-amount-of-shares/553 "2017-12-27T09:29:46Z")
In a text i’m creating for ‘Notulen’ Im trying to calculate an amount in combination with the total amount of shares by using registers. However, I can’t seem to find an easy way to solve this. So what I’ve done is usin… --- ## [Foriloops with multiple rows](https://community.silverfin.com/t/foriloops-with-multiple-rows/550)
**Author:** [@Cedric](https://community.silverfin.com/u/Cedric)\ **Replies:** 2\ **Last updated:** [December 21, 2017, 9:30am UTC](https://community.silverfin.com/t/foriloops-with-multiple-rows/550 "2017-12-21T09:30:35Z")
I’m having some problems with foriloop. Clearly I can’t use this to create two new lines at a time, but it’s really what it needs to do. Is there any other possibility? This is what I get now. I want to create a new … [Next page](https://community.silverfin.com/tag/iterations/361.md?match_all_tags=true&page=1&tags%5B%5D=iterations)