Select query equivalent

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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. 
Photo of Jack Fretwell

Jack Fretwell

  • 484 Points 250 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Rob White IV

Rob White IV

  • 948 Points 500 badge 2x thumb
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
Photo of Jack Fretwell

Jack Fretwell

  • 484 Points 250 badge 2x thumb
I'm not calling anything, I've just found a video on YouTube explaining some of this so I'm catching up, if there are any code examples you could point me to I can try and amend these.
Photo of Rob White IV

Rob White IV

  • 948 Points 500 badge 2x thumb
You shouldn’t need any code. Just go to the table in QuicBase, create a report, and insert your filter criteria there. I’m sorry I can’t offer screenshots right now. I’m on my mobile device. Just trying to help point you in the right direction.
Photo of Rob White IV

Rob White IV

  • 948 Points 500 badge 2x thumb
There will be a filter section when customizing the report. In that section, set cost field equal to your formula field. The report will then display only those records.
Photo of Jack Fretwell

Jack Fretwell

  • 484 Points 250 badge 2x thumb
Thank you! 
Photo of Rob White IV

Rob White IV

  • 948 Points 500 badge 2x thumb
I’ll try to offer more later when I’m at a machine if no one else has chimed in. Let me know if you figure it out.

Thanks!