We are using Airtable to organise our plant nursery. We need it to track the stock of plants in the nursery and match to orders etc. Its a bit different to normal stock tracking where we might track "current stock" by adding to stock when we get in s...
I am hoping to use a cutdown “form” or interface designer method to enable stocktakes of our database items via mobile phone and the airtable app. I have created an interface with a barcode field to be used as a key to all the items and an associated...
Is there a problem using a formula field in another formula field ? I have 2 calculated fields that I want to derive from 2 number fields. The 2 raw number fields are {Seeds per g} and {Plan2023}.
I derive an {adjusted Plan} field using 1.1*{Plan2023...
Thanbks Matthew but I don't see how this would work. We grow 200,000 individual plants/pots per year so having a record for each plant would be overkill. Some species we grow only 100 of but some we grow 5000. We have about 300 different species and ...
Thanks Vivid. Thats how it looks to me too. I don’t want to collect the stocktake data using the whole table as it has about 50 fields and I only want to update 4 with the mobile interface. Maybe the form view would work ?
OK I sorted it out. The first calculated field used an if statement with an option that if a record was empty, the result was " ". So airtable classified this field as being not numeric, even though it looked like it was. I changed the " " option to ...
