Variables
Variables are the representation of the Easydus database columns in each project. Each cell of a record (row of the database) has its own value within this column. This value can be used in emails, screen messages, documents and conditions to display personalized information or to create personal actions. eg Dear ?firstname? ?lastname?,
Variables appear in the screen when you create emails, messages, documents and styles. (image) You have created them yourself when creating your questions in the Web form. (image)
You can click and paste them at the place you want to obtain the personal information. ( IE9 NOT supported) Do you want to type them yourself, then serve them exactly as you made them with directly before and directly behind each variable a ? (question mark), e.g Dear ?name?,
The variables must be placed between question marks to be able to generate automatically the entered data from the database when sending the email.
Example: Dear ?salutation? ?name? will become dear Sir Jack.
Variables are shown next to mails, screen messages and documents in different colors (see below).
Underlined variables refer to questions which are tagged with the Field value – modified system action
Types of variables:
- Systemvariables (shown in pink in the system)
- Variables frontend form (shown in red in the system)
- Variables backend form (shown in blue in the system)
Systemvariables
These are variables that are generated by the system itself:
| ?ID? | is the registration number, a unique number for every tenderer which you can use for communicationin in an email. |
| ?entryDate? | shows the registration date. |
| ?creationDate? | shows de date of creation of this record by upload a csv file, by manual enter this record or by open registration |
| ?modificationDate? | shows the date of last modification of a record. |
| ?invitedDate? | shows how record has been made: by open registering (empty), or manual entering in the system (not empty). Only when using the condition generator. |
| ?currentDate? | shows current date to use in emails and screen messages. |
| ?entrySource? | shows the way a record appeared in the database. ‘Form’ indicates an record created by a published form, ‘Import’ by an upload of a database in the system in menu Enter, ‘Api’ by either a manual import in menu Enter or by an entry via a webhook or a connected system. |
Available only after creating an invoice:
| ?pD_naamfactuur? | shows the date when the invoice has been paid. |
| ?iN_naamfactuur? | shows the number of the invoice. |
| ?iP_naamfactuur? | shows the price of the invoice. |
| ?iR_naamfactuur? | shows the reference number of payment. |
The reference number is the number that payments on PSP (Payment Service Provider) are known with and with which payments can be checked and that possibly can be exported to import into an external financial package.
The reference number is build on a series of 16 digits as follows:
ABBBBBBBBCCCCCCC
A=controlnumber
BBBBBBBB=projectnumber
CCCCCCC=Document ID
Only available after you made a ticket.
| ?ticketScanned_naamticket? | shows the date of scanning the ticket |
Post your comment on this topic.