# \#for\_loop **URL:** https://community.silverfin.com/tag/for-loop/362.md [Latest](https://community.silverfin.com/latest.md) · [Categories](https://community.silverfin.com/categories.md) · [Tags](https://community.silverfin.com/tags.md) --- ## [Repetitive checks within one period](https://community.silverfin.com/t/repetitive-checks-within-one-period/2626)
**Author:** [@Lohra](https://community.silverfin.com/u/Lohra)\ **Replies:** 5\ **Last updated:** [May 21, 2026, 1:39pm UTC](https://community.silverfin.com/t/repetitive-checks-within-one-period/2626 "2026-05-21T13:39:10Z")
Hi, We are looking for a Silverfin template that allows us to display a series of recurring checks based on the number of quarters or months in a financial year, regardless of the configured reporting frequency (monthly… --- ## [Adding Results Tag to Fori](https://community.silverfin.com/t/adding-results-tag-to-fori/2402)
**Author:** [@JohnF](https://community.silverfin.com/u/JohnF)\ **Replies:** 2\ **Last updated:** [February 7, 2023, 8:04am UTC](https://community.silverfin.com/t/adding-results-tag-to-fori/2402 "2023-02-07T08:04:51Z")
Hi Team, We want to add a Results tag to the following code to allow us to show the SIC code(s) for a company in another reconciliation and also as part of an insight. Any help as to how we do this would be greatly app… --- ## [Account value prior year](https://community.silverfin.com/t/account-value-prior-year/2396)
**Author:** [@FBOG](https://community.silverfin.com/u/FBOG)\ **Replies:** 2\ **Last updated:** [February 2, 2023, 6:38pm UTC](https://community.silverfin.com/t/account-value-prior-year/2396 "2023-02-02T18:38:55Z")
Hi, i’m trying to create a custom report to confirm the balance of the current account. I have 2 issues: 1- I don’t succeed in getting the correct amount for each selected account. The code only makes a sum of all sele… --- ## [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… --- ## [Conditional summing](https://community.silverfin.com/t/conditional-summing/1101)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 0\ **Last updated:** [August 8, 2018, 12:54pm UTC](https://community.silverfin.com/t/conditional-summing/1101 "2018-08-08T12:54:15Z")
Hi, In case one of my colleagues might need to make a conditional sum: Doel: de voorwaardelijke som maken van een array gebaseerd op een andere array {% comment %}A = 25, B = 7, C = 8, D = 3{% endcomment %} {% as… --- ## [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 : … --- ## [Shareholer automatic completion](https://community.silverfin.com/t/shareholer-automatic-completion/2254)
**Author:** [@lieels01](https://community.silverfin.com/u/lieels01)\ **Replies:** 4\ **Last updated:** [March 14, 2022, 11:30am UTC](https://community.silverfin.com/t/shareholer-automatic-completion/2254 "2022-03-14T11:30:23Z")
Hi! I’d like to have an automatic system where the possible shareholders appear (some kind of boolean maybe) and depending on the name that is selected, the name and number of shares of the selected person should be com… --- ## [Nested foriloops with account\_collection](https://community.silverfin.com/t/nested-foriloops-with-account-collection/2208)
**Author:** [@b.dalle](https://community.silverfin.com/u/b.dalle)\ **Replies:** 2\ **Last updated:** [February 11, 2022, 1:34pm UTC](https://community.silverfin.com/t/nested-foriloops-with-account-collection/2208 "2022-02-11T13:34:29Z")
Hello, I am working on a template which requires 2 foriloops in combination with an account\_collection. The code below works, however if I change an inputfield, it also overwrites the same account in the following loop… --- ## [List of VAT periods in a fiscal year](https://community.silverfin.com/t/list-of-vat-periods-in-a-fiscal-year/2194)
**Author:** [@FRV](https://community.silverfin.com/u/FRV)\ **Replies:** 2\ **Last updated:** [January 18, 2022, 9:27am UTC](https://community.silverfin.com/t/list-of-vat-periods-in-a-fiscal-year/2194 "2022-01-18T09:27:06Z")
Dear, Since an update this year, the end of a fiscal year in Silverfin can fall on any day of a month, so it is not necessarily the last day of the month, which I personally find an improvement. However, I run into a p… --- ## [Grouping items in a loop based on similar characters](https://community.silverfin.com/t/grouping-items-in-a-loop-based-on-similar-characters/2177)
**Author:** [@shellldon](https://community.silverfin.com/u/shellldon)\ **Replies:** 3\ **Last updated:** [November 18, 2021, 11:20am UTC](https://community.silverfin.com/t/grouping-items-in-a-loop-based-on-similar-characters/2177 "2021-11-18T11:20:19Z")
I have some code that calls all the journals affecting profit and loss that are not zero, showing the description and amount and works well. However would it be possible to group together all the journals that have the … --- ## [Adding variables inside different loops depending on the iteration](https://community.silverfin.com/t/adding-variables-inside-different-loops-depending-on-the-iteration/2163)
**Author:** [@shellldon](https://community.silverfin.com/u/shellldon)\ **Replies:** 1\ **Last updated:** [October 13, 2021, 3:31pm UTC](https://community.silverfin.com/t/adding-variables-inside-different-loops-depending-on-the-iteration/2163 "2021-10-13T15:31:50Z")
Hello, I am trying to create a custom fixed asset note which loops over the account codes for values depending on if the items are selected (line 42). I am having a problem with the column total (lines 113 - 115). I am … --- ## [CASE: create dropdown and display info chosen element](https://community.silverfin.com/t/case-create-dropdown-and-display-info-chosen-element/1428)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 2\ **Last updated:** [March 15, 2019, 10:28am UTC](https://community.silverfin.com/t/case-create-dropdown-and-display-info-chosen-element/1428 "2019-03-15T10:28:06Z")
Let us built a case in which we want to create a dropdown lit of all shareholders we hve. When selected one, we want to display its relevant info from that selected shareholder: Beneath is how we can approach such ca… --- ## [Export disclosures](https://community.silverfin.com/t/export-disclosures/759)
**Author:** [@svalais](https://community.silverfin.com/u/svalais)\ **Replies:** 11\ **Last updated:** [March 5, 2019, 3:27pm UTC](https://community.silverfin.com/t/export-disclosures/759 "2019-03-05T15:27:25Z")
Hello, We have created a style where we export all the disclosures available in a dossier. The problem is that the unstared disclosures also are esported. Wat can we change in the following code to do this? \`\`{% capt… --- ## [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… --- ## [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… --- ## [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/… --- ## [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… --- ## [CASE: how to display details of an account in a text template?](https://community.silverfin.com/t/case-how-to-display-details-of-an-account-in-a-text-template/275)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 7\ **Last updated:** [February 19, 2018, 1:16pm UTC](https://community.silverfin.com/t/case-how-to-display-details-of-an-account-in-a-text-template/275 "2018-02-19T13:16:36Z")
This was the question last week during our event. And it’s a good question also. Let’s say you make a text template “cover letter” and you want to show the details you gave for the account 747004 : These details wer… --- ## [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… --- ## [Making total with forloop.last](https://community.silverfin.com/t/making-total-with-forloop-last/507)
**Author:** [@Wim](https://community.silverfin.com/u/Wim)\ **Replies:** 9\ **Last updated:** [December 11, 2017, 6:55am UTC](https://community.silverfin.com/t/making-total-with-forloop-last/507 "2017-12-11T06:55:47Z")
Hi, i’m making a total of some calculations but my forloop.last doesn’t seem to work. I can’t find the misstake. Here is my code: \*\*\_Ontrekkingen:\_\*\* |Boekjaar | Onttrekking | | O… [Next page](https://community.silverfin.com/tag/for-loop/362.md?match_all_tags=true&page=1&tags%5B%5D=for_loop)