When to Use this Feature?
In Property Management, when recording water, electricity, and gas meter readings, you need to retrieve the previous readings to calculate consumption and costs.
In Vehicle Management, when recording vehicle mileage, you need to retrieve the previous mileage to calculate fuel consumption and monitor vehicle maintenance status.
In Financial Management, you need to retrieve previously entered income, expenses, or balances to track financial status, create budgets, or generate financial reports.
What does it Look Like?
Take the electricity meter recording scenario as an example, where the previous electricity meter reading is retrieved:
1. Enter the initial meter readings for each room in the Electric Meter Record form.
2. When checking the meter readings regularly, select the room number in the Electric Meter Record form. The system will automatically retrieve the previous meter reading for the room. Then, enter the current meter reading to automatically calculate electricity consumption.
How to Set up?
Take the electricity meter recording scenario as an example:
Step 1 Building the forms
Create an Electric Meter Record form and configure the fields as follows:
Field Name | Field Type | Field Configuration |
Room Number | Single Select | Customize room number options |
Previous Meter Reading | Number |
|
Current Meter Reading | Number |
|
Current Period Electricity Consumption | Number |
|
Step 2 Configuring the Formula
1) Select the Previous Meter Reading field. In Field Properties > Initial Value, select Formula and click Edit below.
2) In the Formula Editor, set the formula as follows:
MAPX("last",Room Number,Room Number,Current Meter Reading)The parameters in the MAPX function are described below:
The first parameter, Room Number, comes from the current form.
In Available Variables, select Current Form, and add the Room Number field.
The second and third parameters, Room Number and Current Meter Reading, come from the Electric Meter Record form.
In Available Variables, switch to the Electric Meter Record form and add the corresponding fields.
3) Use the same method to set the formula for the Current Period Electricity Consumption field:
Current Meter Reading-Previous Meter Reading
This formula calculates the current electricity consumption by subtracting the previous meter reading from the current meter reading.After completing the settings, click OK to save.
