Conditional Dropdown - Multiple Values
I have a table named Organizations. I have some conditional dropdowns for fields detailing where these organizations are based, using two other tables: Country and City. However, our dataset is rather large, and some of the Organizations are present in multiple Countries or multiple Cities (or both). Thus, as I understand conditional dropdowns cannot use multi-select fields, a traditional conditional dropdown does not quite suit my needs. Of the solutions I can think of, all have downsides. 1) Instead of having Organizations as the child table in the dropdown relationships, I could use a join table instead,so that Organizations has a many-to-many relationship with Cities, and each organization can be listed with multiple countries and/or cities if needed. Downside I won't be able to sort and filter my Organizations table easily by city and country, as it will be the parent table of where the data is actually stored. Given the size of my dataset, easy filtering and analysis of the Countries and Cities involved is important for us. Or is there a way around this? 2) I could create a second or third conditional dropdown, in order to add these second or third locations. Downside Also difficult to filter and analyse data, and fiddly to enter data. 3) I could create a 'Multiple Locations' value option in the Countries and/or Cities,and then have a new field in my Organizations table to detail this supplementary information. Downside One set of values would be divided among different fields. Question: Does anyone have any suggested alternatives to the options above? Or solutions to the downsides identified? Any advice enormously appreciated!38Views3likes0CommentsHow to make a summary report from multiple tables?
I have four tables. A Project table, a Task table, an Assembly table and an Item table. Each record in the Project table has many related tasks. Each record in the Task table has a numeric field dictating the number of assemblies needed for the task. It also has a dropdown to choose an assembly from the Assembly table. Each record in the Assembly table has a list of many related items from the Item table. Each record in the Item table has a field dictating the number of items needed to make the assembly it is related to and the Item description. I want to make a report that summarizes the total number of each unique item descriptions needed to complete the project. So: For each task, total the # items individually per assembly multiplied by the # of those assemblies needed for the task. Then combining the totals for items of the same description across all of the tasks of the project. Is there a way to do this either within native quickbase or using external tools? If external tools are required do you have any recommendations of what to use?47Views2likes9CommentsHow to use JavaScript to concat child records into a single field?
I'm trying to learn how to concatenate multiple child records into a single field on a report. I have spent a lot of time searching google and the help forums and have come up with nothing. I don't want to use reverse look up because there could be a lot of records I'm returning or only 1. I figured the best way to accomplish this would be JavaScript. Maybe some tutorials on how to implement JavaScript functionality with QuickBase would help.29Views2likes21CommentsHi Guys, I'm new to Quickbase I have trouble in building relationship. Pls help
1.I have two tables called Companies and Orders 2.I created Table to table relationship in Orders(Companies to Orders) 3.Issue-->I select company name in Details table. If I try to access the Orders table I'm not getting the Company name in the company field instead i get Company address value in the Company name field.6Views2likes2CommentsHow to create an auto-number for a item label
We have searched QuickBase and the Internet and found nothing useful so here's to hoping someone has something useful to share. We are creating a printable form. One of the items on the form is an auto-number based on a summary of labels. The auto-number is based upon the count of labels in a summary passed back to the label table. The problem is while the auto-number works, it updates all the labels and not the one we are creating. We have tried to pass the number to another field. We have tried to use dynamic form actions, which worked and then stopped working. I read one post that talks about a snapshot but it links to an App that is no longer available. Has anyone had any luck generating auto-numbers from count summary fields or is there an easier way we cannot see? Any ideas, or links to instructions or Apps are appreciated.21Views2likes6CommentsEmpower 2019 off-book baseball game outing?
I'm fortunate to have the chance to travel for work a couple of times a year, and there are two things I always try to do when I do: 1. drink a local beer and 2. catch a baseball game if I can. This year will be my second Empower and I'm super excited and also ready to venture a little bit off the official social agenda. It happens that the Miami Marlins are hosting the St. Louis Cardinals this June while we'll all be in town. The Empower Agenda Overview shows Tuesday night as open - I assume this is a night where there's an official-but-optional outing, like last year to see the bridge bats? There's a baseball game at 7:10pm that night. The ballpark looks to be about a half hour cab ride from the conference location. I figure I'll almost certainly go myself, but I thought it might be even cooler to see if any other Empower-ers were interested in catching a ballgame. Who knows the next time we'll all be in Miami during baseball season! So, anybody interested in going to see Cardinals @ Marlins, Tuesday 6/11 at 7:10pm?4Views2likes5CommentsQ&A Table report
I'm looking for a way to create a report for Q&A. I have two tables: 1. Questions with 2 fields - Question by (list-user, with default value - current user), and Question (multiple line text field 2. Answers with 2 fields organized in the same way as fields above. I've connected them in a one-to-many relationship (one Question can have many Answers) I want to create an overview where for one Question I can see all answers, or if there aren't any answers to have "add Answer". Considering the relationship I already have Add Answer button, but in report customization I don't have the option of reviewing those answers within a question. If it is possible to have one Question in a field, and see all answers for that question that would be great. Any help would be appreciated.6Views2likes2CommentsReporting most recent data from two linked tables
Hey everyone! I am trying to build a report that links two tables. One table contains the information for our clients (accounts). Embedded in the data entry section is a table to link activities as well as add new activities (please see the attached photo). I am struggling to create a column that lists the most recent activity date for each account. Is there a way to do this? Any help would be appreciated! Thank you.3Views2likes2Comments