Select query equivalent
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...
Forum Discussion
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
Hope this helps,
~Rob
- 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. - 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?
- https://help.quickbase.com/api-guide/... <- here are the api docs. They will be helpful to you one day, even if that isn�t the case for this topic.
- 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.
- 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.
- 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.
- Thank you!
- 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!
