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 ------------------------------
conditional dropdown
Hi, I'm trying to utilize conditional dropdowns and running into an issue that I can't figure out. Here's the relationships: Project Management App has Projects. Each Project has many Sign Types (think of these as Products associated with a Project). Production App syncs Projects. Each Project (sync table) has many Production Tasks. Production Managers Task via Production Tasks. They click on a button on the Project sync table in Production and it associates the Production Task with the Project (in the sync table) but I lookup the Record ID#2 (the original in PM app). Nothing unusual here. What we're looking to do is gain further granularity into how long each Production Task associated with a specific Product (each Project has anywhere from 1 to sometimes 100). So, I created a join table "PT Chains" in Productions to help with this many-to-many relationship. Production Tasks -> PT Chains <- Products. Utilized lookups to bring the related "project" from Products and Production Tasks has the "Record ID#2" which is the same ID in the Production App. I've tried to use Grid Edit and directly adding a new record into "PT Chains" but inside that table, if I enable "Conditional Values" and try to line-up the Record ID#2 and "Related Project" from Sign Types (first attachment) but it seems like this is entering into a circular relationship, where I think it should work. Production Manager creates a Production Task off of the related project. The "Add PT" is a normal Formula URL with the associated fields already filled, so it knows of the Record ID #2 field, which is the record id of the project. Then, as they're creating the task, they should be able to "add in" via grid edit, the specific sign types (products) that the task is related to, since you could be working on more than one, and there's thousands of products, so I'm trying to limit the selection to ONLY the sign types related to that specific project. I'd think this works but it doesn't. It's like a chicken-and-egg or something isn't working right. I can't select any STs (products) because PT Chains (join table) seems to not be inheriting the associated lookup field from the task. Any clues? Thanks! ------------------------------ Andrew Ryder ------------------------------
Conditional Drop Down of Child Records based on Dates
Hi, I am not sure on how to accomplish this and I am very open to out of the box ideas. I have a parent table called measures that has a start and end date for that measure. I have a child table called Projects that has a date field called start date. I would like to see a conditional cascading drop down of measures on the project form for the user to pick where that measure's start and end date are between the Project's start date. From what I can tell in the Related Numeric Reference the conditional values has to be equal not <>.
Airports related to hotels
Good afternoon, Still learning QB and I need help with conditional formatting. I have a list of airport codes and each airport has one hotel or multiple hotels related to that city. When an user selects the airport they want too, I want the hotel field to provide all the hotels related that city. I have been struggling with issue for a while now. Thank you for all the help.
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 ------------------------------
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 ------------------------------Conditional Record Pickers in Grid Edit
Hi everyone! Trying to come up with a workaround for the 1000 record limit imposed upon record picker selections and thought maybe I can narrow this down by setting up some conditional record pickers. We currently have 2000+ records to filter through but I wanted to set a preliminary record picker to filter the results by state. This appears to work on the form but when carried over to grid edit we first get an error message that reads 'First choose State/Region' (even after it's already selected). Even if we select State/Region then save, the second record picker still pops up in a separate window with 'No records found' to select from. Anyone have any ideas on what might be wrong and how we can make this work? ------------------------------ Marissa Zepeda ------------------------------