Address 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.
Where the data is sent, in the form of an Internet address (a URL). The address should start with
https://
.
(The address can also start with http://
, but that means that
the data is not secure and can be read by a third party while in transit. We
strongly recommend that you use addresses that start with
https://
.)
Apps are often used with a third-party service enabling them to do things like adding a row to a Google Sheets spreadsheet, sending a message to a Slack channel or creating a Salesforce lead, all based on data entered into an app or calculated by the app.
Popular such services include Zapier, Microsoft Power Automate and Zoho Flow.
Once configured, these services provide you with the address you need to use
with a server relay button. It is often something along the lines of
https://hooks.example.com/123
.
Refer to our video tutorial to learn more about using third-party services with your app.
You can also send the data to a server you control, enabling your apps to integrate with any software you may run, including on-premises software. Going this route requires considerable technical expertise. Learn more about processing the data without third-party service.
Entering formulas in the inspector
If you use the inspector to enter a value for this property, you can
incorporate formulas by enclosing them within {{
and
}}
markers.
Behind the scenes, Calcapp converts an inspector value with formulas to a single traditional formula. You can view this formula, or edit it directly, by selecting the Address property from the drop-down menu next to the formula bar.
The examples on this page use traditional formulas, where text strings and
other values are joined together using &. To enter them in the
inspector, be sure to enclose them within {{
and }}
markers. Alternatively, enter them in the formula bar.
Examples
Makes a server relay button send data to
https://hooks.example.com/123
.
Makes a server relay button send data to
https://myserver.example.com/process?id=
, followed by the
value of the Id field. In other words, the address is determined
dynamically, and includes a query parameter taken from a text field in
the app.
This formula is associated with the OnPress property of a formula button, and sends data when the button is pressed to the address contained in the Address field. Once the data has been sent, the message "All done!" appears.