A system for managing grants,
subsidies and participatory budgets

Write to us

Overview of codes for generating data

Updated

Entity namename
Formatted addressformatted_address
Streetstreet
House numberstreet_number
Street and numberformatted_street
Conscription numberreg_number
Orientation numberbuilding_number
Municipalitymunicipality
Postcodepostal_code
Districtregion
IČOcin
VAT IDvatin
DIČtin
Legal formlegal_form
Registration numberregistration_number
Registration authorityregistration_office
Date of registrationestablished_on
Countrycountry

Statutory representative: full name (first in order)statutory[0].full_name
Statutory representative: full name (second in order)statutory[1].full_name
Statutory representative: full name (third in order)statutory[2].full_name
Statutory representative: position (first in order)statutory[0].type
Statutory representative: street (first in order)statutory[0].street
Statutory representative: orientation number (first in order)statutory[0].building_number
Statutory representative: conscription number (first in order)statutory[0].reg_number
Statutory representative: postcode (first in order)statutory[0].postal_code
Statutory representative: municipality (first in order)statutory[0].municipality

Code for the application number{application_number}
Code for the contract number{agreement_no}
Code for the programme name{program_name}
Code for the project title{project_name}
Code for numbering contracts from a specific number{sum(counter,62)}

Code for the approved amount{granted_sum}
Code for the approved amount without the “€” sign{currency(granted_sum, “#”)}
Code for the approved amount – in words{nospaces(spell(granted_sum, “”))}
Code for calculating 10% of the approved amount{percent(granted_sum,10)}
Code for calculating 10% of the approved amount in the 0,00 format{number_format(percent(granted_sum,10),2,”,”,””))}
Code for calculating 10% of the approved amount – in words{nospaces(spell(percent(granted_sum,10) “”))}

Code for the application submission date{submitted}
Code for the application submission date (without the exact time){date(“d.m.Y”,submitted)}
Code for the current date{date(“d.m.Y”,now())}
Code for the final report submission date{@final.submitted}
Code for the final report submission date (without the exact time){date(“d.m.Y”,@final.submitted)}

Code for the manager’s full name{active_user.full_name}
Code for the manager’s first name{active_user.first_name}
Code for the manager’s surname{active_user.surname}
Code for the manager’s email address{active_user.email}
Code for the manager’s telephone number{active_user.phone}