Skip to main content
Question

Webhook | API Add Record - Formulas

  • March 3, 2022
  • 0 replies
  • 37 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement