Forum Widgets
Recent Discussions
Combining Multiple Text Lists into One Text list Field
I have three text lists as input: List A = [A, B, C] List B = [E, F] List C = [G, H] I want to combine these into a single text list as output, like this:[A, B, C, D, E, F, G, H] The output field is of type formula-multiselect. Could anyone please suggest the best way to combine these lists within a QuickBase formula?Document Template Source Engine?
Looking to see if anyone has knowledge of the engine Quickbase is using in the Document Template (Doc Gen) feature? Reason: We are hand editing the source to gain control over the layout. Each time we paste our edited and functional HTML into the Source window and save, the Document Template engine modifies the HTML. When we print the Template the layout does not meet end User requirements. If we know what Quickbase is using, we can read the documentation and learn what HTML is allowed. It is obvious the HTML engine is not compliant with HTML5 and we are struggling. We are chasing our tails. Any ideas ... aside from using a third party solution.
Making a checkbox field editable in a report?
Hi! I was wondering if someone could help with a possible formula question? I have in an app an employee master list. In that list the previous designer has a checkbox field called "Active" - If the employee is active it is check if not unchecked etc. My question is the default report that lists all of the employees shows a column that is the active field but I have to go into each individual employee record to uncheck active. Is there a way to be able to go down the list and uncheck all who are inactive right from that report? Thank you in advance!
How to use GetRecords()
var text QUERY = "{9.EX.'" & ToText([Person Assigned]) & "'} AND {3.NE." & [Record ID#] & "} AND {11.LE." & [End Date] & "}AND{10.GE." & [Start Date] & "} AND{13.NE.'Completed'}"; var recordList overlappingTasks = GetRecords($QUERY); var number conflictCount = Size($overlappingTasks); If( $conflictCount > 0, "Not Available", "Available" ) I have used the above query to configure any existing records but the comaprison is not done in the way expected like the number 9 gets compared not the value like that in everything.
CSV Import - Check Records
I am looking for help in importing a CSV file to a Company table that will check if the Company Name if it exists (text only as complete match) before importing. This pipeline imports company data from a CSV file into a Quickbase table. It checks if a company already exists before creating a new record to prevent duplicates. It fetches the CSV file (all+1300 rows) - This is test file and only has 3 rows I receive the following error Validation error: Incorrect template "{{c.company}}". ValueError: invalid literal for int() with base 10: 'company' Attched are the pipeline steps Thank you, Eric
Document Generation - Filename
I started playing with the Document Generation in Quickbase this week which is amazing! I am curious to know if there is a way to set the filename of a Document that is generated in a custom email notification from a Quickbase application? I know that when you use the Generate Document code to create the document for a record in the application, it does allow you to set the title/name of the document specifically. However, using the same option as a part of the custom email notification sends the notification with the PDF attached and named Document 1, rather than any name you specify in the code that is attached the Formula URL field.
Provide Link to New Record on Predecessor Record
I've created a system where when a user clicks "Create New Agreement" URL button, a new record will be created that brings over key information, including the "predecessors" record ID so that the new record can capture that this previous agreement is a "predecessor". However, I'm trying to figure out a way on how to link the "predecessor" record to the newly created agreement as I want a user to actively see in the "predecessor" record that this work has already been completed. Any recommendations on how to do this? Thanks!
