Skip to Content
author's profile photo Former Member
Former Member

New User Questions related to filtering / formulas

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.