![]() Instead of setting the Items property to the name of a table, set it to a formula that includes the name of the table as an argument, as in this example: Some controls have been rearranged and enlarged for illustration purposes. The Items property of the screen's Gallery control is automatically set to that table. If the cost of a product in the Catalog table is lowered below the previous minimum, the return value of the Min formula will automatically change to match it.Ĭreate a blank app for a phone, and add a vertical Gallery control that contains other controls.īy default, the screen shows placeholder text from a table named CustomGallerySample. Just as with numbers, formulas that involve tables and records are automatically recalculated as the underlying table or record changes. Other formulas provide whole tables as return values, such as RenameColumns(Catalog, "Price", "Cost"), which returns all the records from the Catalog table but changes the name of the Price column to Cost. You can use names of tables as arguments in some formulas, such as Min(Catalog, Price) to show the lowest value in the Price column of the Catalog table. Similarly, you can use formulas to access and manipulate data in tables and records. In both cases, the calculated value changes automatically if you change the values of the arguments (for example, the number in cell A1 or the value of Slider1).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |