Local variables or constants (a la Hypercard)?

12

@Iyas_AlQasem if your goal to show each person their own rows, you don’t need separate pages for that. You can implement user-specific filters like this:

For everyone else, if one wants to have a thisPage, there’s a trick to do this:

  1. Pick any control in the page or make a named formula with whatever (e.g. a text value with a space so that it looks invisible: " ")

  2. Take that object’s .ObjectLink(). That’s gonna be your page URL. Sure, not really thisPage reference but you can use the URL to discriminate between rows in your master tables and filter by that URL or its /_suXXX part (the short page ID)

  3. Whenever you duplicate the page and everything in it, the copied views will reference the copied object’s link. So no manual editing of formulas or filters will be required.

Finally, there’s no specifically local or global variables but you can easily use

  • new columns of a table to store any row-specific data, including temporary
  • extra tables to store whatever in them, not necessarily business data

Also watch these:

1 Like