Apologize for this possibly simplistic question, but here goes:I want to create a field that is a Category, that based on the category value selected, will ONLY display a list of relevant Sub Category values for the selected category. EXAMPLE (Simpli...
I am trying to build a more comprehensive product-tree type base where I can accurately keep track of Projects, Assemblies, Parts, attachments, and revisions. I want to have a parent-child relationship in that same order as well, but I don't strictly...
I want to find the sum based on my first metric Companies and within that a metric KPI such that i find the sum of all values of a single KPI within a company. For example, I want the sum of travel hours for a single company and also the sum of fuel ...
I am working on a project for a service company. I have a table with clients and then a table of projects that are linked back to the client. Clients are assigned a rate based on different factors. The rate is carried through to any of the projects t...
Hello everyone,I'd like to have an informative main field in one of my tables but im blocked because of circular references. To be brief, I have a table Programme, that is referenced in Sessions, that is referenced in Half-days, that have begin & end...
Hi all,Can someone please assist me in linking my worklist with a reference table? Essentially what I'm trying to accomplish is to pull in information from a reference sheet into the main worklist whenever a couple conditions match.For example, if th...
Hi there,I've created a base where I track all of the marketing activity for a number of shows, and now wish to track the weekly sales and present them in a line graph, similar to how you would in Excel.At the moment, I have a column in a table calle...
I have a contest that has 3 rounds that are dependent on each other to start and stop. Each Customer's contest could have different durations for each of the round. They usually define a start date and a duration.For each contest record I define: Nam...
Is it possible to create a base that pulls in different tables from different bases? For example, if there are 4 different workspaces (brand) with it's own unique base, and each base has a tab called "X" - is there a way to create a net new base or i...
I have two different tables in one data base.Table A has a list of unique topics, and each of them is sorted into 'Categories' (via a single select column), and has linked records (from Table B), which represent unique people (it's a formula column t...
