So I’ve got a base that I want to run a form out of. The table that the form is within has a link to another table that contains our product inventory, which is selectable within the form.
What I’m trying to do is use a second field, a lookup value ...
So we use Airtable to house an inventory system, for both existing and new assets. New assets are written into the system as a new record via a form.
Up to this point, we’ve used autonumber to generate a unique easy value for vendors to reference to...
So I’m trying sync some records from one base (base 1) into another (base 2). Base 1 contains my inventory, base 2 contains my service records FOR that inventory. I can’t have them in the same base due to record limits.
My idea is to have two table...
Trying to figure out a formula to run a conditional average:
Within the table, each record is a single asset. One field tells me what asset it is (unique ID), one field shows me where its physically located, another shows me the type of asset (may a...
I’m relatively new to the platform, so please forgive any vernacular discrepancies on my part!
So I’ve got a base with two tables. One table is a static list of assets (Asset Table), the second table is a list of requests (with inputs driven by a fo...
Its a hassle, but I think the easiest way to do it is to use concatenate to merge product ID and type into a single field “11821 - Soap” and use THAT as the linked value, and then use conditional logic on the text included.
Appreciate the suggestion, but thats what I’m trying to avoid. I don’t want the user to be able to select type - I want it auto selected for them after they choose the product.
Thanks for the responses so far! I’m assuming the attached is the “smoking gun”? Since the field isn’t user editable, “user modified field” is what we’re talking about here?
The other weird thing - yesterday trying to duplicate the problem, we cre...
I thought about that, but the value I’m needing to average is in this existing table, not another one.
The other issue is that there are say 2000 assets, 500 locations and maybe 70 types… Almost need like an excel averageif where instead of clarifyi...