Select query equivalent

Question

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.

robiv · Answer

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

jackfretwell · Answer

Thanks, I have the string built and held in a field, I then want to use this field value in a look up table, I want to retrieve one value back, I was hoping to steal some code and adapt it, I was working with some thing like this.

<query>{'16'.CT.[ProductCode]}<query>

This is my 2nd day with the product so still a novice and there doesn't appear to be a manual. I can't see where I define what table I want to be queried.

robiv · Answer

That syntax is used when calling an API.  Are you calling the �API_DoQuery� method, or trying to work from within a report on a table?

robiv · Answer

https://help.quickbase.com/api-guide/...  &lt;- here are the api docs.  They will be helpful to you one day, even if that isn�t the case for this topic.

jackfretwell · Answer

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.

Forum Discussion

Select query equivalent

Related Content

Formula Query with custom key

advanced query in a pipeline

Multi-Select Fields with Commas in Pipelines

If Then Else formula with a multi select field.

Using GetRecords to query a table in a different application?