Field completed auto populates other fields
I am new to developing in Quickbase or any other program. I am building an app where if a person selects one of three regions, I would like to populate only those associated with that region to select. For example, I have three regions, and each region has three items (each item is different in a region and stored in a region table), when I select Region X, I only what the three choices in Region X to be displayed, not the other items associated with the other two regions. Thoughts or suggestions? ------------------------------ Brent ------------------------------
Possible to add an 'Other' Option to a conditional dropdown?
I know this isn't a native capability, but sometimes we can trick QuickBase into certain things. I was trying to come up with a slick way to use formula fields so that I can add an 'other' option to my conditional dropdown. For example, if I had US States as my first selection, then cities as my second, could 'Other' be listed with the cities? ------------------------------ Mike Tamoush ------------------------------
Conditional Drop Down - Auto Fill
Hi, Hoping someone may have a solution for this. I'm sure I'm missing something simple. Table: Employee This table houses all employees. There will never be a duplicate instance of this employee This table includes - Employee Name and Employee ID Table: Project This table includes the list of possible projects an employee can be assigned to. Table: Assignment This Table Includes the Employee Name & Employee ID (Pulled from the Employee Table This Table includes the Project Name and Project Supervisor (Pulled from the Project Table) An employee is typically assigned to one project, however, they can have multiples. Additional Fields - Assignment Supervisor, Start and End Date Table: Weekly Employee Summary This table will have a relationship with the Employee Table (pulling name and ID) and Assignment Table(pulling Name, Project Name, employee ID and Supervisor for Project and Assignment) What I am trying to do is: When the Employee Name is selected if there is only one active assignment, it defaults to this. If there are multiple assignments - it requests a selection. Is this possible? I do have the conditional drop downs already working, just hoping to reduce a step in filling out the form. Thank you :) ------------------------------ Amber Anderson ------------------------------
Conditional Dropdown - from one contact to many
I have three tables - Company, Employee, and Activity. Each Activity relates to only one Company, and each Company can have many Employees. I have a conditional dropdown in the Activity screen so that when you choose a Company for an Activity, you then can see all that Company's Employees, and pick one to relate to your Activity. OK, but now they want to be able to choose multiple Employees from that Company, not just one. I want to be able to pick multiple Employees from the Conditional Dropdown, not just one, and I want the email addresses associated with those Employees to be stored in a text field, preferably separated by semicolons, so I can put the entire string in the body of a Calendar invite (which I'm already creating, that part is done), and the user can then copy and paste that string into the Attendees field in the invitation to invite all the people in the Employee list to the Activity. Is this possible? I'd like info on how to allow the user to choose multiple Employees in the conditional dropdown Employee field, and how to create the field with all the matching Employee email addresses. ------------------------------ Charlotte ------------------------------
What causes Conditional Dropdowns not to work in editable report links?
I've used conditional dropdowns in editable report links before, but am having trouble now. I have a formula field that is what my condition relies on. If I add a child in the typical way, the formula field is populated (it's just the record ID of the grandparent), and the conditional dropdown works as expected. If I have the child table in an editable report link, and then try to use the conditional dropdown, the lookup field (used for the condition - the grandparent record id), is not populated, and therefore I can not select from my dropdown. What could cause this? Update: Found this in the community. This is my problem. "if the conditional drop-down is dependent on a value from the parent (most likely scenario), it cannot be used in an 'editable' report to add new child records. Reason being is the child record doesn't exist thus it doesn't have the lookup value that is controlling the conditional behavior. " ------------------------------ Mike Tamoush ------------------------------Cascading Dropdowns Not Working
Hi, I am currently trying to make a cascading drop down menu where the options of one field are dependent on the selection of the previous. The hierarchy of my field is as follows: Part Type -> Part Sub-Type -> Final Part Type -> Specific Part Type. The structure of my app is shown below: Once I had the structure set up, I first went to the "Final Part Type" tab and enabled the conditional values of the "Related Part Sub-Type" field. The conditions I set are shown below Then, I used the same process and went to the "Related Final Part Type" field of the Specific Part Type table. My conditional values that I set are as shown: However, when I add a final part only the dropdown menu for the Final Part Type is conditional. I used the "How to Add Cascading Dropdowns" article on the Quickbase help site in order to help me with the connections. I am unsure of where I went wrong, any help would be appreciated! ------------------------------ Tom Leick ------------------------------
Tecnnical Support re Conditional Dropdowns (or another way to solve this).
Hey guys, it's my first posting my own discussion. I've used the community plenty of times to read up and solve problems on my end, so THANK YOU for being such a great community. So, pretty much what I want to do is filter the options I get on a proxy field based on a lookup field that comes from a priorly selected field. This is for an Inventory MGMT app. Let me explain each of the tables that will come into play here: 1. My first table is called Requests, where people send in their requests to our Warehousewhere they input certain info like their names and once they select their names, based on a lookup field, we get what area they work in. 2. The other table I got is called Materials, this is a list of all of the materials we track in our warehouse. This list is at about 350 materials (but not every area uses all of them). 3. And then my last table is a Many to Many relationship table that brings both of those together.When filling up a Request, the user gets an editable report where they select a Material and then input how much quantity they need. What I want to do is that, based on the Area of work of each specific name, they only get a list of Materials specific to that Area. Any idea on how to go about this? PS> I wanted to upload a video but wasn't able to, please send me an email so I can send it as attachment. There's also a link in case it works:ClickUp Clickup remove preview ClickUp View this on Clickup > https://share.clickup.com/clip/p/t1251230/b34fa86e-e7b7-498e-b0c8-8a3265fe53b6/screen-recording-2021-02-15-14%3A25.webm ------------------------------ Checho Najera ------------------------------conditional dropdown for field that displays value from another field
I have 2 table Family and Individuals. Family and Individuals have one to many relationship (Family<Individuals). Family has fields name(user input text) and typeX (text multiple choice yes/no). The field name is shared value. Table Individuals has field Part, which is value from field- "name" of Table Family. Although there is parent child relationship and each record in Individuals is linked to parent table family, we should add a records in family which is not parent record. In the drop down I should only display records of shared field- "name" that has typeX as yes. Please guide me on how to do it. ------------------------------ Aswin Babu ------------------------------Creating conditional dropdowns in cases of a many to many relationship between tables
I have 3 tables - Products, material and group. Relationships are one material has many products one group has many products many material has many group. Examples for materials are high quality leather, low quality leather, high quality jute, low quality jute, grade 1 jute etc. Examples for groups are Indian leather, Pakistan leather, Bangaladesh leather etc. 1 high quality leather can belong to many groups. as well as 1 indian leather(group) can have belong to many materials. is there a way to create a conditional dropdown for case where there is a many to many. conditional behaviour can be either for materials or group. (if a material or group is selected show corresponding group or materials.) ------------------------------ Aswin Babu ------------------------------
