Discussions

 View Only
  • 1.  quickbase formula api

     
    Posted 06-24-2019 15:53
    Trying to use alteryx to use the quickbase api. using API_SetFieldProperties to update a formula field i built to have a real formula added to it. 

    example formula i'm trying to add:

    [field1]&[field2]

    For the amperstand it keeps breaking and not showing the proper formula... its will only pass through the first field. 



  • 2.  RE: quickbase formula api

    Posted 06-24-2019 17:06
    So you are making a URL call with this or doing it another way? It sounds like you might just need to URL encode that ampersand to get to the next step.


  • 3.  RE: quickbase formula api

    Posted 06-25-2019 18:45
    I'm not familiar with Alteryx - but if your currently trying to update a formula field - and populate the formula of a specific field to be [Field 1]&[Field 2] in Quick Base - Austin is right - you probably need to encode the & into XML format and pass it that way. 

    So try this: [Field 1] & [Field 2]

    Chayce Duncan | Director of Strategic Solutions
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base