Forum Discussion

PedroSampaio's avatar
PedroSampaio
Qrew Member
3 years ago

Webhook | API Add Record - Formulas

Hello everyone,

I am trying to make an API Call that, when triggered, will add an apartment record with the same values of the current one with the sole difference of the Monthly Rent be negative - for example.

You guys can help me to discover what i have been doing wrong?

Example:

API_AddRecord
<qdbapi>
<usertoken>######</usertoken>
<field fid="6">[Unit #]</field>
<field fid="9">[# of Bathrooms]</field>
<field fid="10">[Monthly Rent]*-1</field>
</qdbapi>

------------------------------
Pedro Sampaio
------------------------------
  • You can't do formula math in an API call. I think you have to make a new field which pre-calculates the negative value and use that field in the API call.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------