I run a research lab. I'm setting up Airtable to manage purchase requests and inventory. I have two tables:1. Purchase Catalog, with fields 'Item' and 'Current Stock'2. Order Line Items, with relevant fields fields "Quantity' and 'Status'. 'Order Lin...
Is it possible to hide or display certain fields in a table based on the value of another field? Basically, conditionally.
For example, let’s say a table has the following:
Field A
Field B
Field C
And I want the following display options
Field A: Alw...
When I selecting linked records in a field, the search function only allows me to search based on the primary field. However, my primary field names are not informative (AB001, e.g.). What I really need is to search by one of the other fields of the ...
I’m a researcher and I deal with biospecimens. One of the major tasks is to process and store specimens. A standard arrangement is to place samples in a storage for long-term keeping. I’ve drawn out what that looks like. Both the samples and the stor...
I'm open to alternatives. Can you propose how to do that? Because the value I want to roll up is not in the same table. I don't use Roll ups a ton, but maybe I should.But this brings up another matter. The current stock of an item will change over ti...
Thanks @Bill.French. I’m glad to hear it’s possible. But this is such a basic function, I don’t think it should require paid users to make scripts for it. If this were more of a niche request, I can see warranting a script, but this is a core feature...
