Jon_Swerens - profile

Jon_Swerens · Jan 06, 2023

Hello! I run a weekly publication and we have a number of freelancers who get paid different amounts for stories and columns. I have an Airtable table with their names and rates.So in my payments table, I have a Single Select field which chooses the ...

Jon_Swerens · Jan 26, 2022

I am trying to convert grid of information with different prices for different writers into a workable Airtable solution that I can use every week for payment to them. Here is an example of the grid in the Excel file we’re currently using: So, say t...

Jon_Swerens · Jan 09, 2023

All right! This is the way. Worked perfectly. I'm able to copy and thus archive everything into my Closed Payments table once I click a new field called "Closed" in my payments table.Feeling inspired, I also added a view that looks at the past 14 day...

Jon_Swerens · Jan 09, 2023

The lookup fields are all of the kinds of articles that our freelancers could possibly write.I'm going to read through and consider your solution above. I have to think through how this is going to work! Thanks!

Jon_Swerens · Jan 06, 2023

Oh, the Payment formula looks like this:SWITCH({Type}, "Feature", Feature, "Pick", Pick, "Column", Column, "Album Review", {CD Review}, "Local Album", {Local CD}, "Movie Review", {Movie Review}, "Book Review", {Book Review}, "Blurb", Blurb, "Theater ...

Jon_Swerens · Jan 06, 2023

I sure can share the formula, but right now I am working on this solution.Since I should track what I used to pay freelancers anyway, what I will do is create a "new" freelancer when I give a raise. I'll mark one instance as the "current rate" so I c...

Jon_Swerens · Jan 26, 2022

Would Dynamic Variables do the trick for me? Or is there another solution? Lookup reference to a different table with multiple active conditions Ask the community Airtable rolled out “Dynamic Variables” to their automation...

User Statistics

User Activity

Keeping SWITCH formula number frozen for old invoices

Referencing grid of different prices for different freelancers

Re: Keeping SWITCH formula number frozen for old invoices

Re: Keeping SWITCH formula number frozen for old invoices

Re: Keeping SWITCH formula number frozen for old invoices

Re: Keeping SWITCH formula number frozen for old invoices

Re: Referencing grid of different prices for different freelancers