Pipelines - not recognizing Record ID#

Question

I have a pipeline that triggers when a record is edited. It pulls in the related record ID#, and then runs a search to match that related record ID# to a record ID#. For some reason, on that query, it changes the record id# from just a plain number to a number with decimal points. See screenshot. I am trying to find a formula that I can use to trigger this to round up, or find a way around this

. Has anyone else come across this issue before?

thanks, Urs

------------------------------
Ursula
------------------------------

. Has anyone else come across this issue before?thanks, Urs------------------------------Ursula------------------------------

ursulallaveria · Answer

Thanks Angel, What I ended up using was the {{ a.bill_to_matter|int }} option instead. I didn't want to use Round because this is the Record ID# (key field) and I didn't want there to be any mistakes with it rounding up or down a number and it creating a record related to the wrong record.------------------------------Ursula------------------------------

markshnier__you · Answer

I believe I heard about this issue on a Webinar and they did some Jinja language trick. I wonder if you made a text field formula for to mirror the record ID# field if it would then treat it as a character and get a clean hit that way.

ie [Record ID# text] with a formula of ToText(Round([Record ID#]))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

ursulallaveria · Answer

Thanks Mark! Funnily enough, that is what I ended up doing. I had to create text versions of all the related record ids I was referencing, and it seems to work. I will have to do some further testing to make sure it works in all instances, but this is a good workaround. I am surprised that this hasn't been identified as a bug of some kind, seems a little convoluted to get a record id.

------------------------------
Ursula
------------------------------

angelrodriguez · Answer

Ursula, with jinja templates you'd want to use the 'round' filter. So instead of round({{ a.bill_to_matter }}), you just write {{ a.bill_to_matter|round }}

------------------------------
AR
------------------------------

Forum Discussion

Pipelines - not recognizing Record ID#

Related Content

Pipelines: Lookup newest record?

Using Pipelines to Archive Records Based on Checkbox

Three Words of Advice on Pipelines

Button to Add Record via Pipeline, and refresh Record

create pipeline to create new records based on current record