Skip to main content
Solved

Out of stock items moving to a separate table so they are not included in the main one?


Not 100% sure where this should go but:

I am using airtable as a database for the teas we have in stock. However, when a tea goes out of stock, I would like to mark the item as “finished” and relocate it to a new table automatically so it isn’t included in the main count and doesn’t clutter up the table. While I know I can do that using a filter, people who are unfamiliar with airtable (or even spreadsheets/databases) have found this difficult.

I don’t want to lose the information entirely since it lets me know if something we got didn’t go over well and we don’t want to purchase again or if it’s something we really enjoyed, I want to be able to quickly add it back to the main table.

Please let me know if this is possible? I’d rather avoid manually moving this data but understand if that’s the only way.

Best answer by _Zo

Smote_Mote1 wrote:

I’ll give these a look! I’m not sure how to set up a custom script block but I’ll dig into that as well. Thank you!


Sounds good!

Also if you decide to go the automation route, I have a short video where I demo migrating records to a different table and an entirely different base.

View original
Did this topic help you find an answer to your question?

8 replies

_Zo
Forum|alt.badge.img+5
  • Inspiring
  • 6 replies
  • July 28, 2020

Hey there,

The only way to ‘move’ records across tables and bases would be either via a custom script block or a tool like Integromat or Zapier

Keep in mind you will lose record comments but if you dont use those you are good to go!


kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • July 30, 2020

Welcome to the Airtable community!

You have already discovered that filtering is the best way to show and hide “finished” items. You can save the different filtering settings (filtered and not filtered) to different views.

Teaching your fellow collaborators how to use different views is much less complicated than teaching them how to use filters or actually moving records to different tables.


  • Author
  • New Participant
  • 4 replies
  • July 30, 2020
_Zo wrote:

Hey there,

The only way to ‘move’ records across tables and bases would be either via a custom script block or a tool like Integromat or Zapier

Keep in mind you will lose record comments but if you dont use those you are good to go!


I’ll give these a look! I’m not sure how to set up a custom script block but I’ll dig into that as well. Thank you!


  • Author
  • New Participant
  • 4 replies
  • July 30, 2020
kuovonne wrote:

Welcome to the Airtable community!

You have already discovered that filtering is the best way to show and hide “finished” items. You can save the different filtering settings (filtered and not filtered) to different views.

Teaching your fellow collaborators how to use different views is much less complicated than teaching them how to use filters or actually moving records to different tables.


The people using this are not employees or collaborators. They aren’t going to sit down for an airtable lesson just to browse what we have.


_Zo
Forum|alt.badge.img+5
  • Inspiring
  • 6 replies
  • Answer
  • July 30, 2020
Smote_Mote1 wrote:

I’ll give these a look! I’m not sure how to set up a custom script block but I’ll dig into that as well. Thank you!


Sounds good!

Also if you decide to go the automation route, I have a short video where I demo migrating records to a different table and an entirely different base.


  • Author
  • New Participant
  • 4 replies
  • July 30, 2020
_Zo wrote:

Sounds good!

Also if you decide to go the automation route, I have a short video where I demo migrating records to a different table and an entirely different base.


Thank you so much! I appreciate it!


kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • July 30, 2020
Smote_Mote1 wrote:

The people using this are not employees or collaborators. They aren’t going to sit down for an airtable lesson just to browse what we have.


Ah, that wasn’t clear from your initial post. Yes, customers/clients need a more intuitive experience than employees.

It isn’t clear how you are sharing your base with your external users. If you are embedding a shared view in a website, you can share a filtered view. You can also pre-set filters in the url for a shared view.

However, if you want to automatically move records to a different table, Integromat is a good choice.


  • Author
  • New Participant
  • 4 replies
  • July 31, 2020
kuovonne wrote:

Ah, that wasn’t clear from your initial post. Yes, customers/clients need a more intuitive experience than employees.

It isn’t clear how you are sharing your base with your external users. If you are embedding a shared view in a website, you can share a filtered view. You can also pre-set filters in the url for a shared view.

However, if you want to automatically move records to a different table, Integromat is a good choice.


For external users, I am sharing the base by offering them a filtered view sorted by type. However, I want the users to be able to also view by location, caffeine amount, name, company, and style as well as be able to filter out results (ie: Sort by caffeine amount but filter out any black teas, or only show white teas). Most of the people using this will be able to easily sort things but I would like to avoid the hassle of users needing to also filter out for ‘finished’ teas constantly. Additionally, I can get a more accurate total of price, quantity, and other stats without ‘finished’ teas showing up on the main table.

I think the moving records is the best way to go about this and I’m going to poke around with some methods this weekend when I have time! Thank you for your reply!


Reply