Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Assistance with master table + smaller table(?) for writer submissions

164 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

Our organization produces lots of content and I need a way to:

1. Assign a pool of different writers their assignments and be able to use an interface to give feedback through the development and approval of each piece of content

2. Every new assignment then needs to live in a main repository / master “base table” 

A few thoughts:

1) I’m thinking the article assignments are entered in a separate table for the writers, yet the master base table should have insight into it as well.. Not sure how to proceed. : )

 

2) in addition to me assigning topics to the writers, I also need the writer form to be able to accept pitches from writers so they will need the ability to enter in content into the form as well. 

3) And then when the writers click “status” = “submitted” can Airtable then send me an email notification?

Any guidance or examples would be appreciated!

thank you!

5 Replies 5

Hi, you asked a lot of things, so let's start a little piece by piece.

1) you need one Table for the writers and one for the works/reports/books.

In the Works table, you need to create a column that is linked to writers table, something like that:

20.PNG21.PNG

 

22.PNG

After you can create a form, where you will add the field "Rating". In this way, when they will rate the work, their score will go in a new column. 

You can also receive a copy of the form, if you clicked on "email me at "

23.PNG

After that you need to set up an automation to send the form.

To set up the automation, you need:

- emails in the writers table;

- lookup field in the works table that "take" the emails of writers;

24.PNG25.PNG

- and the link of the form, that you can obtain it in this way:

26.PNG

if you want to send the form at a specific time, you have to do like this:

27.PNG

(This is an example, if you want to send it every 20 days at 9:00am)

or if you want just do once, you have to click on "interval type" and "One time".

After that you need to find the records 

28.PNG

and you have to copy and paste the link of the form in this way:

29.PNG

 

Before continuing with the question, let's see if this part makes sense or if I misunderstood your question. 

Thank you.  I'm actually looking for each writer to be able to submit a form of content.  When they submit it, that info is entered into the main table of all content.  In the form you have above I don't quite understand the association between the writer and the content in the form.