Help requested linking a record to a new table

[Kusum_Chanrai]

Hi All! I’m new and I have a basic question. I’m an investor organizing our deals. I need to do the following:

1. In my 1st table, I have a field called “Priority”. One of the options within the Field is: “No Interest”. When I select “No Interest”, I want that record to automatically populate another table called “Deals Declined”.

I’ve looked at the following Help article but unfortunately, I can’t get it to work.

Any help would be MUCH appreciated.

[JonathanBowen]

Hi @Kusum_Chanrai - you could use a service like Zapier to populate another table when the priority changes to “no interest”, but the (easier) Airtable way would be to have multiple views on your deals table. You might have the following views:

All Deals - All deal records, no filters
Deals Declined - deal records where priority = “no interest”
Completed Deals - deal records where priority = “closed - completed” (I made this up)
Open Deals - deal records where priority is not either of “no interest” or “closed - completed”

It all depends upon the options within priority, but you get the gist of my suggestion :winking_face:

Any good?

JB