TomLeick
Qrew Member
Joined 5 years ago
User Profile
User Widgets
Contributions
Jinja Expression Help
Hi, I have a project that contains items (parent table) and arrays (child table). All the items contain the exact same array names on creation. Meaning every item will start off with array names 1,2,3, ...etc. I want the user to be able to change these names if they want to. So I am trying to build a pipeline so that when the user updates one array name, it goes through all the arrays and changes every array with that same name to the new one. For example, if I change array name 1 to "Barry," the pipeline will go through all the arrays and change every array with the name 1 to "Barry." In order to avoid an infinite loop, I created a field checkbox that, when checked, will trigger the pipeline. So to trigger the pipeline, the user will update the name of the array and then check the box. My pipeline then searches the arrays table and I queried to compare the previous value of the updated record to the current names of all the other records. However, it always comes up false even when they are the same. Can someone see if I am doing something wrong with jinja? Step a: The updated record trigger Step b: The search records action block Thank you ------------------------------ Tom Leick ------------------------------Updating a File Attachment Field Using Pipelines
Hi, I am currently trying to build a pipeline that automatically updates a file attachment field in one of my records. However, it des not seem to let me choose the file attachment field in the "add fields" portion of the "update record" block in the pipeline builder. Is this not available in QuickBase? Thank you ------------------------------ Tom Leick ------------------------------Creating a URL that Prints a spreadsheet
Hi, I am trying to write a formula URL field that prints my summary report as a spreadsheet. I know that QuickBase has this button natively, however I cannot use it because I used formula rich text fields in order to display my data so when I go to print it, it shows my entire formula in the excel box. So my workaround would be to have a button that will print a spreadsheet that doesn't use the rich text fields. I managed to create a formula that will accurately display the spreadsheet, but the print URL has an extra section labeled ridlist. What is this field and is there a way for me to include it in my formula URL? Thanks ------------------------------ Tom Leick ------------------------------Creating a Hyperlink in Exact Forms
Hi, I am trying to make an exact form that contains links to various resources depending on what the user selected. The the Quickbase application works is the user has a long list of items that they can select to learn more about. When they make their selection a pipeline then creates a record in another table that contains all the information, including links, of the items that were selected. I then parse through the record and separate the components into their respective fields. After the data is separated and organized I would like the link fields to be hyperlinks, is there a way to do that? Right now you need to select the whole field and manually enter in the link. Thank you ------------------------------ Tom Leick ------------------------------Automatically Sending an Exact Form in an Email
Hi, I have just created and properly uploaded an exact form for an application in quickbase. I was wondering if there was a way to make a button or possible pipeline that will automatically send an email with the completed exact form attached. By completed I mean the data fields within the exact form are filled out and not with the raw code. If it is possible, any help/explanations about how to do it would be greatly appreciated. Thank you! ------------------------------ Tom Leick ------------------------------Is it Possible to Hide Fields of a Table Similar to Forms?
Hi, Is it possible to hide fields of a table similar to how you can hide fields of a form? I have a table called projects and each project has a different number of arrays in it. I would like only the necessary arrays of each project to show on the table. I understand that I could create another table called "Arrays" and create a one to many relationship between "Projects" and "Arrays" but it would greatly benefit if I am able to see the arrays on the project table. Thank you ------------------------------ Tom Leick ------------------------------
