Forum Discussion

LizChartrand's avatar
LizChartrand
Qrew Cadet
1 month ago
Solved

If/Then Help - Unforeseen number populating

Hello! I've got an API button that when triggered, creates a new record with some preset information pulled in. That all works except in the instances where I need some fields to be blank. I thoug...
formulas
  • MarkNishikawa's avatar
    MarkNishikawa
    1 month ago

    What if you exclude the field reference line completely from the URL if there is no data in [Renewal Outcome Parking Rent]?

    & If([Renewal Outcome Parking Rent]>0, "&_fid_176=" & [Renewal Outcome Parking Rent], "")

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
1 month ago

In my experience

If([Renewal Outcome Parking Rent]>0, [Renewal Outcome Parking Rent], "")

and 

If([Renewal Outcome Parking Rent]>0, [Renewal Outcome Parking Rent])

will produce identical results.  Is this a URL formula field with an API call or a Pipeline?

 

LizChartrand's avatar
LizChartrand
Qrew Cadet
1 month ago

Thanks Mark, same - in fact, has I've updated my syntax again it works for me. And yet , when my team member uses the API button, she's getting the ~$25000 populated instead of being blank.

It seems like its happening with her but I have no idea why.

This is a Rich text field making an API call.