OVERVIEWI'm using Airtable as a main inventory of the products I sell.I have a table wherein a new record is created with an SKU whenever I scan a barcode of my product. WHAT I WANT TO ACHIEVEThe Main Inventory is located in another table. I just wan...
Hi, I'm trying to explore using Airtable as my Stocktake system. The idea is using an external form (Jotform, Typeform, etc) I assign a location, scan product barcodes and when I'm done, I click submit in a form and then all the records will be creat...
Hi, I'm using Airtable as my Main inventory.PROBLEM:Currently, I assign item location on a per unique SKU or product basis - the problem is, I cannot track how many item is assigned to the location.For example TshirtA has 3 quantities, all I can see...
Hi, I have 2 fields:Transaction Date - date fieldand Month (For Reports) - linked fieldWhat I want is whenever a date is set under transaction date, it should automatically link to the corresponding Month - linked field. I know this is doable but I c...
I’m trying to set up a customer having multiple addresses.
So Table 1 is customer that contains the profile, then table 2 for addresses and I link the customer to it.
I want the primary record of Addresses to have a count based on how many same custo...
@TheTimeSavingCo wrote:If the lines of text never contain commas, you could try:1. Create a formula field that will convert the line breaks into commas SUBSTITUTE({Field name}, "\n", ",") 2. Create a new table called "Line items"3. Create a linked fi...
I have no knowledge about how REGEX work so just to confirm, I will need to create a new roll up field similar to the photo below? I have 150 item locations.. seems like a lot of work so I want to make sure before I spend some time to test this.
