Global variables

Venues

<aside> <img src="/icons/script_gray.svg" alt="/icons/script_gray.svg" width="40px" /> How to automate the relation

  1. Use automation

  2. Use a template

  3. Use a button like this:

    This button allows to create a venue and automatically fills the relation.

  4. Another way is to filter the view on the Global variables:

    Untitled

    Any new venue created in this view will inherit the filter.

</aside>

<aside> <img src="/icons/calculator_gray.svg" alt="/icons/calculator_gray.svg" width="40px" /> Total price (with relation)

prop("Price per guest")*prop("Global variables").map(current.prop("Value")).at(0)

If there are several global variables, the formula can be expanded to something like this:

prop("Price per guest")*prop("Global variables").filter(current.prop("Name") == "No. guests").map(current.prop("Value")).at(0)

</aside>

<aside> <img src="/icons/calculator_gray.svg" alt="/icons/calculator_gray.svg" width="40px" /> Total price (without relation)

prop("Price per guest")*prop("No. guests")

prop("No. guests") is a formula property to define the global variable inside the table. The formula is simply 100

</aside>