Format property
Special value available in formulas:
Item
The button this property is part of, enabling multiple checked items in the app designer to share the same formula and be updated all at once.
Consider the fields Field1 and Field2, which should
only be considered to be valid if their values are
greater than 4. Without using the Item value, the Valid
property of Field1 would need to use the formula Field1 > 4Field1 > 4 and the Valid
property of Field2 would need to use the formula Field2 > 4Field2 > 4.
Using Item, both formulas can read Item > 4Item > 4. This is useful
if you have many fields and you want to be able to update their
formulas all at once. To do so, click their check boxes in Calcapp
Creator and make sure that a checked field is selected. Then, when you
update a formula for one checked field, you update all the other
checked fields too, which is a great timesaver.
Use Item in exactly the same way you'd use the regular
name. Button1.VisibleButton1,Visible and Item.VisibleItem,Visible are equivalent, for
instance.
What format is used for the report. These are the allowed values:
| Value | Meaning |
|---|---|
EmailReportFormat.Text (default)
|
The field values are included in the email body itself. The values are formatted in the same way as in the app. |
EmailReportFormat.Pdf
|
The field values are included as an attached PDF document. The values are formatted in the same way as in the app. While the document can contain arbitrary text before and after the field values (see below), it cannot contain images or formatted text. Learn how to generate custom-designed PDF documents by reading this tip. |
EmailReportFormat.Dsv
|
The field values are included as an attached file containing delimiter-separated values (DSV). (Files containing comma-separated values are known as CSV files and files containing tab-separated values are known as TSV files.) These files can be imported into spreadsheet programs like Microsoft Excel and Google Sheets and imported into databases. |
Custom text can appear before and after the field values.
Examples
Makes an email report button send the field values as an attached PDF document.
Makes an email report button send the field values as an attached PDF document if the user has selected "PDF" from a text drop-down field named Format, or as text otherwise.
This formula is associated with the OnPress property of a formula button, and causes a report to be sent when the button is pressed. All fields of the app are included, courtesy of the { App }{ App } parameter. The field values are sent as an attached PDF document if the user has selected "PDF" from a text drop-down field named Format, or sends the field values as text otherwise.