Tables are useful when you have lots of data that you need to refer to in your formulas. You can paste them straight from your Excel/Google Docs etc spreadsheet.
Note: Tables should be at most 3-400 rows. If you need really large tables contact us.
Let's say you have this custom pricing, based on the quantity of items ordered:
You would need a Number question (or Slider, Incrementer) called Quantity, and a Formula called Price
When editing the Formula you will see the "Tables" tab above the formula content. In there you can create a table, we can call it Prices (the title is just for your benefit, you will refer to the table as T1 inside formulas)
In the table we will add these columns:
You'll notice 3 things:
In the Quantity columns we only kept the upper limit, since that is the point where the price changes.
In the Price field we removed the "$" sign because we need the clean number
Also in the Price field we removed the comma "," separator because only decimal dots are allowed
(You can do these operations in your spreadsheet - Excel, etc with Find and Replace)
Now that you have the table set up, you can go to the Formula field and type this in the formula content:
At this point you can update your pricing just by going in and editing the Prices table.
As you can see, you use a table column with the expression T1!A
T1 is the table, as you add more tables it will be T2, T3, etc
A,B,C is the column. You can also write T1!1, T1!2, T1!3, etc to achieve the same result.
Advanced Tip: You can use a question value in the Table notation:
Let's say you have this table (truncated) for average baby weights:
|Male Weight (kg)||Female Weight (kg)||Age (months)|
Advanced Tip 2: If for some reason your table had the columns in this order:
|Age (months)||Male Weight (kg)||Female Weight (kg)|
Learn more about the functions you can use in tables:
If you can't find a function you're looking for let us know