Forum Widgets
Recent Discussions
Unrelated Data
I suspect I know the answer to this question, but am hoping that someone has better solution. I have unrelated data except for the fact that is time stamped. I need to chart both series. The two options I know are: Export to SQL and use Tableau, then embed a Tableau report in QB. Create a table of dates to force the different sets to be related together. Anyone know of another method?
Importing excel into multi select text field which is connected to another table inside same app
I am trying to import data by adding existing data which is in another table but I am seeing a weird behaviour that rather than selecting the option which is already present it tries to create new option and as the option is more inside the main table it is throwing me error. Please give a reply ASAPMatching Fonts on Templates using Rich Text and Standard text
Hi, I'm very new to the quickbase world and trying to manage an app that was built for my agency. My question is about changing the font that prints from a form in Rich Text. We have several forms that use templates to print out and when there are both rich text fields and standard text fields used, the rich text fields default is different than the standard text in both size and font. This obviously looks terrible but I can't find a way to adjust it. I have read several articles and conversations about using rich text with HTML tags, but I can't find a way to actually adjust the font (I think prior to 2023 the options in Rich Text fields, were well richer). Can someone offer a suggestion. BTW, I am not a programmer so I need basic instructions on where to find things and how to adjust them. HELP! And TIA - Hayley
Could not parse XML input
Hi, I'm getting errors on my pipelines for a multi-line field. Quickbase reported an error: 11 : Could not parse XML input : XML Parsing Error. not well-formed (invalid token) at line 3 column 353 (which is byte 700) When I look through the activity log and the original db i'm seeing these characters: †and “. When I talked with the users they said they did not put them in the field. After a little research it looks like it was a copy and paste issue. My question is how can i prevent this from being sent through the pipeline? Thank you
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 ------------------------------
