# \#training

**URL:** https://community.silverfin.com/tag/training/222.md

[Latest](https://community.silverfin.com/latest.md) · [Categories](https://community.silverfin.com/categories.md) · [Tags](https://community.silverfin.com/tags.md)

---

## [Intermediate \[Exercise 3: Registers\] (Training slides exercise)](https://community.silverfin.com/t/intermediate-exercise-3-registers-training-slides-exercise/1742)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 2\
**Last updated:** [March 20, 2023, 2:35pm UTC](https://community.silverfin.com/t/intermediate-exercise-3-registers-training-slides-exercise/1742 "2023-03-20T14:35:13Z")

</div>

Create Fixed Asset register with a table and a fori loop to show additions and disposals and add totals at the bottom using registers ($). The table should look like the one below:

---

## [Advanced \[Exercise 6: Adjustment button\] (Training slides exercise)](https://community.silverfin.com/t/advanced-exercise-6-adjustment-button-training-slides-exercise/1750)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 5:22pm UTC](https://community.silverfin.com/t/advanced-exercise-6-adjustment-button-training-slides-exercise/1750 "2020-04-07T17:22:19Z")

</div>

Create an input field to be able to select a range of accounts from the TB, then display a table underneath that will show the account link, a blank input field for description and a blank input field to indicate the adj…

---

## [Advanced \[Exercise 1 & 2: Arrays, updated\_by & updated\_at\] (Training slides exercise)](https://community.silverfin.com/t/advanced-exercise-1-2-arrays-updated-by-updated-at-training-slides-exercise/1744)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 4:36pm UTC](https://community.silverfin.com/t/advanced-exercise-1-2-arrays-updated-by-updated-at-training-slides-exercise/1744 "2020-04-07T16:36:59Z")

</div>

Create a checklist with questions related to VAT declarations (this could be in an infotext e.g.) Several columns: checkbox, the question, option to comment Make sure if checkbox is not done, the template cannot get rec…

---

## [Advanced \[Exercise 5: Rollforward\] (Training slides exercise)](https://community.silverfin.com/t/advanced-exercise-5-rollforward-training-slides-exercise/1749)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 5:19pm UTC](https://community.silverfin.com/t/advanced-exercise-5-rollforward-training-slides-exercise/1749 "2020-04-07T17:19:15Z")

</div>

Create an account template that details purchases and sales for certain shares (types), together with a begin- and end value When copying details in the same book year, everything can be copied. In different book year, …

---

## [Advanced \[Exercise 4: Dropdown with data from drop\] (Training slides exercise)](https://community.silverfin.com/t/advanced-exercise-4-dropdown-with-data-from-drop-training-slides-exercise/1748)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 5:16pm UTC](https://community.silverfin.com/t/advanced-exercise-4-dropdown-with-data-from-drop-training-slides-exercise/1748 "2020-04-07T17:16:42Z")

</div>

Create an input table where name investor, type and amount can be entered Show all investors in a dropdown

---

## [Advanced \[Exercise 3: Reference values\] (Training slides exercise)](https://community.silverfin.com/t/advanced-exercise-3-reference-values-training-slides-exercise/1746)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 5:00pm UTC](https://community.silverfin.com/t/advanced-exercise-3-reference-values-training-slides-exercise/1746 "2020-04-07T17:00:33Z")

</div>

Create a reconciliation that sums up VAT declarations of the book year The handle for this template should be vat\_declaration Also checks if the company is still VAT obligated Create a separate reconciliation templa…

---

## [Intermediate \[Exercise 4: Account collection\] (Training slides exercise)](https://community.silverfin.com/t/intermediate-exercise-4-account-collection-training-slides-exercise/1743)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 1:33pm UTC](https://community.silverfin.com/t/intermediate-exercise-4-account-collection-training-slides-exercise/1743 "2020-04-07T13:33:25Z")

</div>

Create an input field with a data type account\_collection that allows selecting a range for all accounts in the trial balance beginning with 1 and 3 . Then create a table underneath that will show the account link and ac…

---

## [Beginner \[Exercise 6: Iterations\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-6-iterations-training-slides-exercise/1738)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 12:26pm UTC](https://community.silverfin.com/t/beginner-exercise-6-iterations-training-slides-exercise/1738 "2020-04-07T12:26:36Z")

</div>

Create a table with 4 columns (it doesn’t matter which layout you use). Within that table create a fori loop to input the below data related to the company’s investments. The category field should have 3 options: compute…

---

## [Beginner \[Exercise 7: Recap\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-7-recap-training-slides-exercise/1739)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 12:34pm UTC](https://community.silverfin.com/t/beginner-exercise-7-recap-training-slides-exercise/1739 "2020-04-07T12:34:18Z")

</div>

Create a ‘Letter of Representation’ in a document that contains the following items: A title header with the company name on the first line and the VAT identifier underneath. Print the company address below the title a…

---

## [Beginner \[Exercise 4: Input fields\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-4-input-fields-training-slides-exercise/1736)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 10:17am UTC](https://community.silverfin.com/t/beginner-exercise-4-input-fields-training-slides-exercise/1736 "2020-04-07T10:17:08Z")

</div>

Create a table containing the input fields shown below and try entering some data on them. For the currency column, create a dropdown that allows the user to select one of the following currencies: EUR, GBP or USD. The o…

---

## [Beginner \[Exercise 2: Markdown tables\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-2-markdown-tables-training-slides-exercise/1734)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 9:35am UTC](https://community.silverfin.com/t/beginner-exercise-2-markdown-tables-training-slides-exercise/1734 "2020-04-07T09:35:12Z")

</div>

Build a table with 3 columns and 4 rows (5 including the header). The first column should have a width value of 20% and be aligned to the left, the second one of 40% and aligned to the left and the third one should exte…

---

## [Beginner \[Exercise 1: Markdown style\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-1-markdown-style-training-slides-exercise/1733)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 3\
**Last updated:** [February 12, 2021, 4:55pm UTC](https://community.silverfin.com/t/beginner-exercise-1-markdown-style-training-slides-exercise/1733 "2021-02-12T16:55:56Z")

</div>

Create the following text using markdown to structure the document:

---

## [Intermediate \[Exercise 2: Default & Assign\] (Training slides exercise)](https://community.silverfin.com/t/intermediate-exercise-2-default-assign-training-slides-exercise/1741)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 1:17pm UTC](https://community.silverfin.com/t/intermediate-exercise-2-default-assign-training-slides-exercise/1741 "2020-04-07T13:17:02Z")

</div>

Create an input field with the data type ‘currency’ and a default value of zero (remember to use the assign attribute in order to store the default value in the database). If the entered value in the input field is posi…

---

## [Intermediate \[Exercise 1: Linking templates\] (Training slides exercise)](https://community.silverfin.com/t/intermediate-exercise-1-linking-templates-training-slides-exercise/1740)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 1:09pm UTC](https://community.silverfin.com/t/intermediate-exercise-1-linking-templates-training-slides-exercise/1740 "2020-04-07T13:09:17Z")

</div>

Create a reconciliation template and an account template and build a link inside an infotext on each of them that connects to each other. See the image below as an example: Tip: Remember to put a handle when creating …

---

## [Beginner \[Exercise 5: Control flow\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-5-control-flow-training-slides-exercise/1737)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 10:25am UTC](https://community.silverfin.com/t/beginner-exercise-5-control-flow-training-slides-exercise/1737 "2020-04-07T10:25:56Z")

</div>

Create 2 input fields that allow the user to enter a budget value and an actual one and build an if statement that will display the following text depending on the value entered by the user. If both values are blank: …

---

## [Beginner \[Exercise 3: Filters & Drops\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-3-filters-drops-training-slides-exercise/1735)

<div class="topic-metadata">

**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 9:51am UTC](https://community.silverfin.com/t/beginner-exercise-3-filters-drops-training-slides-exercise/1735 "2020-04-07T09:51:08Z")

</div>

Print the following content on a document applying the respective filters: The name of the company in Capital Letters The address of the company, replacing any blank spaces by an underscore (\_) The date of the end of t…
