Skip to Content

New User Questions related to filtering / formulas

Feb 08 at 03:19 PM


avatar image

Hopefully, I explain my questions in an appropriate manner.

1) I have a set of data I want to query. I have a formula that works for querying if the field value is null or blank. Is there a formula I could create to tell me if an entry in the database even exists? For example, I create an item in the database and while creating this item I can attach a reference field to this item that's linked from another table. The reference data is only created if reference information is entered. How would you query the database for data in a table that might not exist?

2) Let's say I have a table in the database called references and within this table I have a field called ref_type and ref_value. A ref_type can only have a maximum of three ref_value's attached to it. The value in the ref_value field will be showing up on a report, but I only want to show the values in line no 1 or on the detail level is there a way to only display reference fields for one particular item, while ignoring reference from other items appearing on report?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers