Discussions

 View Only
  • 1.  Calling API through Formula URL

    Posted 07-10-2020 02:50
    Hi ,

    I'm new to quickbase and I'm currently using a formula URL button and i need to call API_GenResultsTable . Can anyone help me or guide me on how to process this or what to write in my formula text box .

    Any help would be appreciated .
    Thanks



    ------------------------------
    Ashish Nair
    ------------------------------


  • 2.  RE: Calling API through Formula URL

    Posted 07-10-2020 11:25
    Edited by Austin K 07-10-2020 11:26
    What are you wanting it to do? Without any information like that it will be tough.

    This site has examples of what to do so you can look at that and see if the URL alternative that is listed will work for you. If you need help past that come back and explain what it is you are wanting to do exactly.

    https://help.quickbase.com/api-guide/gen_results_table.html

    Example:

    https://target_domain/db/target_dbid?a=API_GenResultsTable&ticket=
    auth_ticket&apptoken=app_token&qid=5&jht=1&query=
    {'6'.CT.'done'}AND{'14'.CT.'USA'}&clist=7.8&slist=6&options=sortorder-A

    If you don't understand the query string comparison operators like this, {'6'.CT.'done'}AND{'14'.CT.'USA'}, then go here and scroll down to "Query string comparison operators" learn about them. 

    https://help.quickbase.com/api-guide/do_query.html


  • 3.  RE: Calling API through Formula URL

    Posted 07-10-2020 11:39
    Ironically enough, I'm looking for specifically this type of functionality...

    Ideally, I want the formula field to do an API_DoQuery of related child records (there should only be one in our situation) and get the filename of a file attachment field in the child record. Any assistance would be greatly appreciated.

    I know I can do the DoQuery where the related parent is equal to ID... I'm just used to doing this more in JavaScript versus in a formula field.

    ------------------------------
    Ryan Stanford
    ------------------------------