In the deals module want user to select the number of locations from a picklist or lookup and then have both the number of locations as well as the amount saved to 2 fields in the deals module. Could do this with a function, however the code gets long and it would be easier to just use the table.
See sample below.
Location: select location have value saved here and in price.
Price:
| Locations |
Price |
| 1 |
$240 |
| 2 |
$480 |
| 3 |
$720 |
| 4 |
$960 |
| 5 |
$1,200 |
| 6 |
$1,440 |
| 7 |
$1,680 |
| 8 |
$1,920 |
| 9 |
$2,160 |
| 10 |
$2,400 |
| 11 |
$2,616 |
| 12 |
$2,832 |