Skip to main content
Question

Using a Formula, be able to search for a value in a field across all records of a table

This may be an obvious, or maybe it's a form of searching that isn't available?  There are ways in Quickbase to just get a summary of a table, grouping fields and counting the results to display in a report.  

Is there a way to search for a value in a field across all records of a table and then use that counted value within a formula or form rule?  If not the same table, what about with related table, BUT including records in the child table that are NOT related.

For example, find all records (non-related) in a table by searching a status field for the word "active" and returning that count to be used with another formula or within a form rule somehow?
    This topic has been closed for replies.

    Hoping there might be some thoughts on this question still.

    Through some more testing, I found that by doing the following, I kind of get the result I need, but it's extremely slow, so still looking for help.


    * create a new multitext field in which the Input Type is populated from a source field in the same table. 
    * the source (main) field is from the same table, allowing this new lookup field to now show all the values in that table for that source (main) field. 
    * I unchecked all the boxes under the advanced header, thinking it might help speed it up?
    * on the form, I created 2 dynamic rules.
    * rule 1: when record is saved and the main field has changed, change the lookup field to match this main field on the form
    * rule 2: when record is saved (after checking), see if the lookup field matches the main field. Also check if the main field is not empty (since empty ones are allowed). abort with a message that the value from the main field already exists in the lookup.


    This seems to work when I have the lookup field displayed on the form (which I don't want), yet it makes the form ice slow!!!  basically not functional for users who don't want to wait 1-2mins.  If I remove the lookup from the form, then the rules don't work it seems.

    Anyways, I'm messing with that still, but hoping someone might know of a way to handle the actual question.

    Thanks
    I'm not really understanding the ask here.  Do you need to be able to change the search term you are looking for?

    Or are you looking for the results to display as an embedded report on a parent record and you want children who match some word in a field on the parent record. 
    Terms & ConditionsAccessibility statement