ContributionsMost RecentMost LikesSolutionsHow to compare to a list exactlyHello, I currently have a drop-down list that is populated with names and numbers from a report. If the number is typed into the drop-down, it'll search and find it. Is there a way to compare to the list (report) exactly? I'm not attached to having a drop-down list if a text or numeric field will work and right now it'll find the closest match but is there a way to have an error pop up if the match is not exact? Thanks.Populate a field from a reportI have a report that adds up the total number of checkboxes checked for various different items in a table. Is there a way to use this information to populate fields in a different table? For example, option 1 was checked 5 times, option 2 was checked 8 times and option 3 was checked 4 times. I would like to use this information to make a seperate table that looks like: Options # of checks Option 1 5 Option 2 8 Option 3 4 How do I use the report to populate the # of checks field?Re: Bar Chart with SeriesI think I figured out the first part. Is there a way to get the data directly from the summary report or do I need to create another field? Thanks!Bar Chart with SeriesHello, I'm trying to create a Bar Chart with Series just like the one pictured in the Chart types information: https://help.quickbase.com/user-assistance/chart_view_type.html#bar 1) How do I get more than one value on the X-Axis? How do I show data for multiple months (for example)? 2) Is it possible to get the data from a summary report? I have a summary report that totals the columns at the bottom and would like to show the totalsfor the various columns in a bar graph. Any help is appreciated!Re: How to reference fields in a related table without going through the pickerok, I'll look into this further. ThanksRe: How to reference fields in a related table without going through the pickerWhen I use the direct entry field, the only values that come up when it's saved are the "related employee from direct entry or record picker" and "employee number direct entry", both of which equal the number I entered. And this makes sense given the formula. If I use the picker, the "related employee from direct entry or record picker" is equal to the value I 'picked', otherwise, "related employee from direct entry or record picker" is equal to the value I entered in the direct entry field. Here are the two relationships I have set up between the assets (checked out) table and the employee information (card and employee numbers) table Yes, there are duplicates. Once I get something up and working I can delete the duplicate information. Below I assigned an asset (a physical key) to Mr. E. First I used the picker to select him and the information populated. In the second row I assigned a different asset to the same person, this time using the direct entry but no information populated. *note* all information is made up for test purposes I think this means I need a relationship between the direct entry field and the information I'm trying to get it to populate (from the card and employee numbers table). But now I'm back where I started, trying to type in an employee (or ID card) number and getting the name and title to populate. >_<* Sorry if this is too much information. I was thinking out loud, trying to process.Re: How to reference fields in a related table without going through the pickerI've managed to get half of it working, but not the half I want. When I use the picker for the "related employee from record picker" field it populates the information I want, but when I try the "employee number direct entry" field, the same information won't come up. Can we try it without using the record picker at all?Re: How to reference fields in a related table without going through the pickerGreat! Having the option to use the record picker as a backup would probably be a good idea. I was just looking for a faster primary option. Thanks!How to reference fields in a related table without going through the pickerHi, I have a table with employee information such as name, title, and employee number. I have a separate table in which to assign assets to said employee. The two tables have a relationship such that the employee number can be selected from a drop-down list in the "assets" table and the name and title will populate. This is what I want but as I expand the list of employees in the drop down list (to over 1000) it switches to the picker instead. Is there another way to reference the employee information without going through the picker? Using the picker adds many more clicks and is inconvenient and time consuming. I would simply like to be able to type the employee number in the "assets" table and have it populate the name and title from the employee information table. There are too many employees to use a drop-down and I'd rather not use the picker. Is there another way? Thanks. P.S. I'm pretty new to Quickbase so please be specific. Your help is greatly appreciated!Re: How to update a field with the information from a field in another table?This is AMAZING!! You're the best! Thanks!!