Skip to main content
Question

Select query equivalent

  • August 9, 2018
  • 0 replies
  • 71 views
I'm very much used to SQL, Quickbase is very new to me.

I want to look up a value from a table based on a string, this is for a mailing house and I build the string up depending on the post carrier, weight of item, quantity etc.  I'd like to create a query or formula that can do this from a field formula.

Before I would just: 
SELECT cost FROM data_tbl where product = 'MyString'

I'm baffled by what I'm seeing with Quickbase. 
    This topic has been closed for replies.

    • RobIV
    • Registered
    • August 9, 2018
    The usual method in QuickBase for this type of thing would be to create a formula-text field that builds your string. Then use that field to filter a report on the table. There are API methods available to do this type of thing also depending on the desired output/use of the data in the query.

    Hope this helps,

    ~Rob
    Terms & ConditionsAccessibility statement