Skip to Navigation

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I create a report that displays records where one field equals another field?

1. Choose a table from the Table bar.
2. Click REPORTS & CHARTS to open the reports panel, then click + New.
3. In the dialog, select Table and click Create.
4. In the Columns section, choose Custom columns and click and drag each column you want to include under Report columns.
5. Check Define a calculated column.
6. Set the type to Checkbox.
7. Enter this formula:
[Field 1]=[Field 2]
where "Field 1" and "Field 2" are the names of the fields you want to compare. Also, make sure Field 1 and Field 2 are the same field type.
8. In the Filters section, select Filter (items).
9. In the dropdown which appears below, scroll to the bottom and choose Calculated Column.
10. Select is equal to in the middle field, and enter True in the text box.



How do i create a report that will show montlhy those employees who have no attendance infractions?

Hello, Specifically how you



Specifically how you build that kind of report will depend on how your app is structured. If you go to Help > Manage Support Cases > + New Support Case, a customer care specialist will be happy to take a look at your app with you and help you build the report.




Intuit QuickBase

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit