Pen and paper is far superior for usability and speed of input, but far inferior for reflection and analysis. Norm for my cover cropping is 8-ish species per bed.įor both of those practices, it gets quite tedious with forms for each crop needing to be refreshed (it's also easy to lose track of what info you have inputted). So I'll weigh out 10g vetch, 150g tick bean, 8g daikon, etc and seed that.
But we use a soil conservation and regenerative practice of "cover croppping" - where we sow a diveristy of species (up to 12, but some people use over 20 species) in a mix in the bed. That may look like 2 trays of beetroot, 2 trays of Lettuce 1, 2 trays of lettuce 2, 1 tray red cabbage - etc. If this is not the case, then that field will not appear in PowerBI. Copy Template M Query Note The first record in the table or view that is being integrated from Airtable should have a populated value in each field that you would like to visualize in Power BI.
#AIRTABLE API EACHPAGE HOW TO#
But on a nursery day, we may do 30 trays. In this section, we'll cover how to use the Airtable API to connect to both. But we may do a few crops if we're doing a small trial. I have an airtable base that lists possible surveys along with the required data for each survey. we sell "lettuce" but grow at least 6 different kinds of lettuce - usually a few at a kind for our lettuce mix - and appropriate cultivars change with the seasons (some do well in the heat of summer, some deal with damp winters better). Topic Labels: Data Interface Designer Views. We have about 40 different "crops," but within that there may be data on as many as 10 cultivars. Hi CJ, I tried to keep the details simple as I realise market gardening is foreign to most on here! But to give some details: The ideal solution would be a form that could collect all data against each instance, but airtable doesn't allow that.ĭoes anyone have any ideas to help with this workflow? I have seen on2air, but unfortunately as a non-profit, spending more and more $ on record collection is really really hard to justify. We need to be able to do this on mobile, as we're in the field, and unfortunately the table view of airtable isn't very easy to do this on mobile.Īnd unfortunately having to submit a form 15 different times is confusing and time consuming. Each crop in either of those instances has unique data stored against it - Date, quantity, etc. For example, when I seed trays of 15 different crops in the nursery, or I sow a cover crop into a bed (sometimes 10+ species).
A few of the things we keep records on need many records created at the same time. I know airtable doesn't have the ability to do this, but I wonder if anyone here has a clever solution.įor context, we're a non-profit vege farm.
0 kommentar(er)
