Forum Discussion

JBJB's avatar
JBJB
Qrew Trainee
6 years ago

quickbase formula api

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. 

APIs and custom code
  • AustinK's avatar
    AustinK
    Qrew Commander
    6 years ago
    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.
  • ChayceDuncan2's avatar
    ChayceDuncan2
    Qrew Cadet
    6 years ago
    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