Skip to main content

"syncing" tables, I think

  • October 11, 2020
  • 2 replies
  • 13 views
D
Forum|alt.badge.img+3

Greetings all,

I have a pretty basic table that I keep my Bourbon inventory. I have a table called “bottles purchased” and another called “current inventory”. They are basically the same tables right now, as I just duplicated my original table, Bottles Purchased. In my table, I have a checkmark field that I check if it’s currently in my collection. Obviously, I can filter the checkmark on and off. But how can I add a bottle in “bottles purchased” and it gets added to my “current inventory” table upon checking the checkbox?

Hope that makes sense.
Thanks
David

    2 replies

    Kamille_Parks11
    Forum|alt.badge.img+27

    Airtable Sync can’t sync two tables within the same base.

    Why do you want a separate table, are you counting individual inventory of each type? (i.e. Bottle A #1, Bottle A #2, Bottle B #1, etc.)

    If you absolutely need a seperate table you could use an Automation to run on “when record meets conditions” (checkbox is checked) and have a “create record” step that maps the appropriate fields in the second table.

    D
    Forum|alt.badge.img+3
    • David_Chaney
    • Author
    • New Participant
    • 2 replies
    • October 11, 2020

    Airtable Sync can’t sync two tables within the same base.

    Why do you want a separate table, are you counting individual inventory of each type? (i.e. Bottle A #1, Bottle A #2, Bottle B #1, etc.)

    If you absolutely need a seperate table you could use an Automation to run on “when record meets conditions” (checkbox is checked) and have a “create record” step that maps the appropriate fields in the second table.


    Thanks for the reply. I guess I’ll go about it another way then. I just changed my SORT up. Where by it shows all my current stock, the check box, sorted first, then my other sort fields.

    Thanks
    David


    Terms & ConditionsAccessibility statement