Skip to main content

I have a table with a list of articles that need to be written. The fields on the table are; article id, article progress status, author, drive link, Article title, Guidelines and deadline.

I have created a sharable view with which my writers can see which articles they are assigned to and the necessary details without signing in. I collect the articles via a form where they submit the drive URL and the article id with a status (writing done)

Problem is, when they submit the article it always creates a new record and I have to manually transfer the URL and change the status to the original record and delete the row that has been created by the form.

Is there a way, to make it possible that the writers can submit the URL to the original record and change the status? without signing in.

Hi @Tareq_Sojol and welcome to the community!

You could:

  • create a new table with the necessary input fields you require from your authors and add a form there
  • make a prefilled form URL for every article (eg: url to form + article ID prefilled) and put it behind a button field in your article table
  • create an automation that triggers on the submission of a form in the new table, finds the article in your article base, based on the article ID that is included via the (prefilled) form, and then updates that record with the URL and new status

This is also doable with Fillout.

 

 

Instead of your form creating new records, have your form edit existing records.

 

You’ll end up with a unique Fillout link you can send out to your writers. They’ll be able to enter their drive URL and update the status of the original record you created, instead of making a new one.

 

Example Airtable base and Fillout template to get you started:

 

Bryan

Terms & ConditionsAccessibility statement