Skip to main content
Question

quickbase formula api

  • June 24, 2019
  • 0 replies
  • 56 views
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. 

    This topic has been closed for replies.

    • AustinK
    • Registered
    • June 24, 2019
    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.
    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
    Terms & ConditionsAccessibility statement