Forum Widgets
Recent Discussions
Error listing for Pipelines?
Is there any kind of troubleshooting/listing somewhere of Common issues with Pipelines. I have Literally copied a working Pipeline line by line, instruction by instruction, and the one I am working on keeps getting an error. What I have noticed is for some reason the "Commit Upsert" runs twice, which i don't believe it ever used to if I look at older runs similar to this one. It is very frustrating with Pipelines to build an exact copy a functioning pipeline, only difference is a different app, and the copy will not function. I've added a screenshot of the error i'm getting. If anyone can either help me or guide me to a answer, I would appreciate it.
Pipeline help
I have a parent table called principal investigators (PI) that has a child table called "applications". This is for external users to apply to a grant we are hosting, all the information will come through a form in the applications table. However, I want to pull information from the applications table into the PI table for future querying. Very simply, users will put in their name, email address, and departmental affiliations which I want to then create a record in the PI table if it does not exist. If it does exist, I want to update the applications table with the related PI record ID. I cannot get this to trigger properly and I have tried many times. It fails at the IF/ELSE statement. Here is my YAML file below if it helps (I removed identifying information): # Add PI to table # # Account slugs: # - quickbase[DB]: Realm Default Account <None> --- - META: name: Add PI to table enabled: false - TRIGGER quickbase[DB] record on_create -> a: inputs-meta: allow_triggers: Any export_fields: '"Applicant Name, Applicant Email, Departmental Affiliations, Related Investigator" <6, 9, 81, 234>' table: '"Awards Portal: Applications" <##>' - QUERY quickbase[DB] record search -> b: inputs-meta: export_fields: '"Email Address, Full Name" <7, 6>' table: '" Awards Portal: Principal Investigators" <##>' name: Search for records in PI table note: Search for records in PI table that match the applicant email - b<>LOOP: - DO: - IF: - AND: - a<>applicant_email equals {{b.email_address}} - THEN: - a<>ACTION quickbase record update -> c: inputs: related_investigator: '{{b.id}}' name: Update the record note: This step updates a record in the table - ELSE: - ACTION quickbase[DB] record create -> d: inputs-meta: export_fields: '"Affiliations, Email Address, Full Name" <8, 7, 6>' table: '"Awards Portal: Principal Investigators" <DB>' inputs: affiliations: '{{a.departmental_affiliations}}' email_address: '{{a.applicant_email}}' full_name: '{{a.applicant_name}}' name: Create the record note: This step creates a record in the table - a<>ACTION quickbase record update -> e: inputs: related_investigator: '{{d.id}}' name: Update the record note: This step updates a record in the table - metadata: name: If a condition is met, do something note: Check if condition is true - metadata: name: Iterate through the records note: Iterate through the records found in the previous step ...Join multi-line text field to one line
Hi all. I'm trying to find a way (either using a formula or in Pipelines) to join a multi-line text field to a single line. Use case: The multi-line text field will contain text that will go to the JSON request body of an API call in Pipelines, so the field needs to be converted to a single line. The field has to a multi-line text field, because values can contain several paragraphs and app users can easily customize it. Thanks!Search And Replace to Remove "enters"
I have field where users can enter data and divide them by using Enter: XXXXXX YYYYYY For another field summary I would like to convert this way of entering into: {XXXXXX; YYYYYY} I was thinking to use formula "SearchAndReplace" but I am not sure what to enter in Search for?: SearchAndReplace([1-Step feeder(s) - after AltBOM],"?????","; ") In excel I would search for Char(10) but how to find "Enter" in QuickBase? I tried to Trim, but does not work. I tried to use in formula enter but after save it is converted to "/n " Any ideas how to search and replace "ENTER" between numbers? There might be more then 1 enter. ------------------------------ Adam Krzyzanek ------------------------------
stripping hidden characters from text strings to enable field equality
I am using a staging table to compare a .CSV import to a bunch of live data. I have maybe 50 fields to compare and I am trying to check a few thousand records regularly and just flag the fields that have changed. This is typically pretty straightforward as they are text fields and using a List function and a bunch of if statements, I can easily display the field names when Live Field A <> Import Field A. My issue is lots of text fields are appearing as not equal, though they look the same when displaying them. I have used the tricks I know to tidy up hidden characters... var text A = SearchAndReplace([Live Field A],"\n"," "); var text C = SearchAndReplace($B,"<br>"," "); Trim(Upper($B)) This removes next line and carriage returns and makes all uppercase and trims extra spaces. I apply this to both fields, they have the same length of characters, look identical, even copy/pasting them to Notepad++ and turning on hidden characters they look the same but according to QB they are not equal. I have one more question path of enquiry... I have tried swapping between Text and Rich Text. The <br> I think works in Rich Text but \r in text gets converted when I save to something else, perhaps that is the issue? Any text gurus out there? Ideas or assistance would be appreciated... Kind Regards, Jeff LoveHow To remove carriage return from Multi-Line text field
Hello, I have searched for this subject and found 1 post with 0 responses. I'm pulling in info from QB using Power Query, a Multi-line text field is not pulling at all when there are multiple lines created using a carriage return / line feed. Is there a function similar to CLEAN (instead of TRIM)? or how can I replace the non visible carriage return using another text formula field (without taking the table down clean it and re-uploading) thanks, ------------------------------ Ayman Hanash ------------------------------
Open Notifications Stopped Working this Month (7/2025)
Hi all! I've had an app built for years that houses my internship program data. It sends out an open notification to internship supervisors to evaluate our students' performance near the end of their internship. The notification contains a link that takes them into the app to complete a form which pulls goal data from the student's workplan to be evaluated on. It last worked properly (was completed by a supervisor) on 7/6). This week, particularly the last 2 days, my team started getting emails saying the link shows them the form for about a second, gives an error code, and takes them to a log in page. Supervisors have never needed to log in before. Just click the link and they access the form. I'm not super savvy at Quickbase - any ideas on what happened/broke?
