ContributionsMost RecentMost LikesSolutionsRe: Search different string from multiple records I figured out. If I use OR (has to be capitalized) it would search the 2 different values that are in separate records. ------------------------------ Gene Strelkov ------------------------------ Re: Search different string from multiple records We have thousands, so I will be importing those records from Excel. For example. I have this sample app. I'm trying to assign 2 assets to clients, one is SN: 267-01, and other is SN: 2664-05 If I try to search one SN at a time, I do get results that match that string. But If I try to search 2 SN's at the same time, I get no results. So this is my question, how can I search for different SN's, to get results? ------------------------------ Gene Strelkov ------------------------------ Search different string from multiple records I will be attempting to build an additional table in our account, that will have a list of all assets that we have by serial number. Our company supplies GPS trackers to different clients. What I'm trying to do, is let's say we have several thousand records, each one identifying asset model and it's serial number. If we have a client that needs a hundred of those trackers, how would I search 100 of those serial numbers (out of thousands of devices), so it displays 100 records for me, so I could go ahead and change the assigned company to that specific client for just those 100 devices. I don't want to edit 100 different records one at a time. ------------------------------ Gene Strelkov ------------------------------ Re: Extract Text Between 2 special charactersThank you, Mark! ------------------------------ Gene Gene ------------------------------ Re: Extract Text Between 2 special characters Mark, as I started to test more, how would I exclude running formula if the results show ERROR instead of number. How would include "If" to your formula? If >ERROR< I don't want to formula to run. Basically, the Pipeline output will either be with a number, or ERROR. <?xml version="1.0" encoding="utf-x"?> <string xmlns="http://www.tempuri.org/">1234</string> <?xml version="1.0" encoding="utf-x"?> <string xmlns="http://www.tempuri.org/">ERROR</string> If number, then trim that into new field (which is how it's done, if ERROR, don't put anything to new field. ------------------------------ Gene Gene ------------------------------ Re: Pipeline POST BodyIt does work in Webhooks, with the following formula, but QB is trying to merge into Pipelines, so I would like to get this migrated earlier than later, and would rather have with less steps, instead of adding complexity to it. &clientName=[Company Name]&userName=[Company Name] Admin&firstName=[Company Name] ------------------------------ Gene Gene ------------------------------ Re: Extract Text Between 2 special charactersThank you so much, Mark!! ------------------------------ Gene Gene ------------------------------ Re: Extract Text Between 2 special charactersAwesome, that worked perfect. Do you mind just quickly explaining what you did in that formula? ------------------------------ Gene Gene ------------------------------ Extract Text Between 2 special charactersI've been going through several posts here all morning, trying to find how I would extract text that's between 2 characters, and I can't seem to figure out. I have the following field text: <?xml version="1.0" encoding="utf-x"?> <string xmlns="http://www.tempuri.org/">1234</string> I need to extract the number that's between 2nd ">", and 3rd "<" (in the example, that number is 1234, and it always changes, and after 9999, it will turn into 5 character number.) The closest I could come up, was: Part([URL],3,">") But the result comes out to: 1234</string And I don't need "<" and anything that is after. ------------------------------ Gene Gene ------------------------------SolvedPipeline POST BodyWhat I currently have setup, is when a record is created, it creates a user name at my 3rd party service. Here's a partial of what's in the body: &clientName={{a.company_name}}&userName={{a.company_name}}&firstName={{a.company_name}} What I want for &userName, is to have a QB company_name field, plus static word "Admin" So I tried: &clientName={{a.company_name}}&userName={{a.company_name}} Admin&firstName={{a.company_name}} But it's not adding that word "Admin", it completely ignores it. I've never worked with JSON, and this was my very first time, and it all works great, I just can't add specific word to combine with an existing field name. ------------------------------ Gene Gene ------------------------------