Skip to main content

Functions

19 articles
How to Convert Date&Time to a Number Format
Converting Between Text and Date FormatsThis case introduces how to convert between text and date formats by using functions.
Date Validation Cases of Form SubmissionThis article will introduce how to set date-related validations through Validations on form submission and apply them to common business scenarios.
Date Addition and Subtraction CalculationsThis case introduces how to perform addition and subtraction calculations on Date&Time fields, such as adding a specified number of days, months, or years to a date to obtain a…
How to Allow Each Member to Submit Only One Record per Day?
Duplicate Validation for Multi-Day Reservations
Using the VALUE Function with Text Strings
Nested Applications of the IF Function
Multi-condition Application of the MAPX Function
MAPX Application: Retrieve the Previously Entered ValueIntroduce how to use the MAPX function to retrieve and apply the previously entered value in the current form.
MAPX Application: Display the Latest Record in a FormIntroduce how to use the MAPX function to display the latest record in a form.
BOM (Bill of Materials)
Two-Level BOM Material Usage ListThis article explains how to build a Two-Level BOM Material Usage List.
Three-Level BOM Material Usage ListThis article walks you through how to build a Three-Level BOM Material Usage List.
How to Calculate Leave Days Excluding Holidays and Weekends?
Generating a Serial Number When a Form Is Opened
Choosing Whether to Generate a Serial Number
Generating Serial Numbers Based on Date (with Refresh Option)
Generating Serial Numbers Based on Project Name (with Refresh Option)