What it says on the tin.
Different authors make different amounts, I’d love to add this kind of conditional logic based on what we’re entering in the “numbers” field, and have those prices automatically calculated in the sheet.
Ideally, I would also be able to hide the formula and have it entered in the currency field so I can later filter by author later and have it automatically populate the total at the bottom of the table, but I won’t get picky.
Have a look here:
@William_B, you’re going to have to set your “Payrates” table up horizontally instead of vertically.
Think of each Record (row) in the “Payrates” table as a “Pay Schedule”. Initially, you only need one, your current pay schedule/rates. You’ll need to create a Field (column) for each “Tier” that could be matched against, and it’s percentage value as the Value for that “Pay Schedule”. The advantage of this is that you can change your pay structure in the future by adding a new “Pay…
You’ll want to follow this same general pattern of having a “Pay Schedule” table, just modified a bit to match your schema of “Writers” rather than “Sales Associates”.
Thank you so much
I think I’m more confused than before though
Unfortunately I’m a bit too tied up w/ work at the moment to dive into an explanation.
In the spirit of Airtable’s DIY mission, here are some concepts to read about that are important for building a solid database in Airtable, and in particular to meet your use-case:
Lookup, rollup, and count fields in a table use linked record fields to pull in values from one table to another. By default, these fields will pull in all the linked records from the other table, ...
– those are pretty targeted at key concepts. Here are a couple full-scale guides that might be helpful in just wrapping your head around what’s possible with Airtable when your base is designed well: you might want to just breeze through this beginner’s guide
Welcome to Airtable!
Whether you're opening your own restaurant, designing a clothing line, wrangling cattle, or managing a record label, Airtable helps you create anything you can imagine to do th...
and then move on to this more advanced one
This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.