Forum Widgets
Recent Discussions
Need help with nesting statements for pipeline
I have two template tables that are related (Task template - parent and Subtask template - child). Both of these tables have a multi-select field called Task Category which could list property purchase, business purchase, lease, ground lease, construction, property sale, business sale as some tasks apply to multiple types of transactions. I also have the option of All if the task applies to any type of transaction. A transaction can involve several options - for example we could purchase the property and construct a building, or we could purchase a property and lease to a tenant. Upon the trigger of the pipeline, the appropriate Tasks are copied from the Task Template table to the Task table based on matching criteria. It works but I don't know how to add a 2nd step to also pull any tasks that are marked "All". I've attempted to add it within this statement as well as using AND but it errors . This is my current formula: {% set list = a.deal_task_category.split(';') %} {% for item in list %} {% if loop.last %}{9.HAS.'{{item}}'} {% else %} {9.HAS.'{{item}}'}OR{% endif %} {% endfor %} I have a similar issue in next step for the subtasks. For this step I have three functions that I need to accomplish (1. I need to pull the Subtasks that relate to the copied Tasks (which I attempted to do in the first line in the formula below), 2&3. do the exact same as above - pull over the subtasks that match the Task Category and then pull over any subtasks that have "All". This is what I attempted but it gives "Valueerror: invalid literal for int() with base 10: 'id' {{h.template_id == i.related_test_task_template}} AND {% set list = a.deal_task_category.split(';') %} {% for item in list %} {% if loop.last %}{25.HAS.'{{item}}'} {% else %} {25.HAS.'{{item}}'}OR{% endif %} {% endfor %} Any insight on how to add nesting request would be much appreciated!
Apply Dashboard Filter across all Tabs
Hi, Is there any way to apply a dashboard filter to cover all tabs? The filter works fine when all the reports are on the same tab, but if I want to split reports across tabs, then it's very inconvenient to ask the user to select the same item across every tab to get what they want. e.g. You select the Project via the "Main" tab and it will filter all reports across the "Main", "Calendar" and "Issues" tabs for that selected Project. Thanks.How to Generate PDF with data from multiple children records
I am trying to see if there is a way to create a pdf that is able to loop a section depending on how many children records are linked to the parent. Here is the situation. I have a site record (parent). Each site may have one or more visits (children). I want the PDF to repeat a template section for each child record. It will have information such as Start Date/Time, and Job Description. e.g I know Quickbase has an API to generate a PDF using a static template, but is there a way get it to loop a section in a template for each child record that exists? Having a different template for each child quantity possibility seems inefficient. Thanks.Save & Continue on New Record form
Hello all, I'm trying to create a Save & Continue button for an add form that will return to the record to continue editing. I found this thread ( Add Save and Keep Working Button on form for a new record | Qrew Discussions ) from a few years ago which is exactly what I want to do, but it doesn't seem to be working as stated anymore. var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%RID%%"; var text link = "<a href='" & $URL & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and Continue</a>"; $link When I click the created button I do see the "saving record" alert appear and then the green "Record saved!" but then directly after a window pops up "Leave site? Changes you made may not be saved." with options of Leave and Cancel. It doesn't matter what option I select, the next screen is the quickbase error page "Record Not Found" and to either go to the application's dashboard or go back to the previous page. Although the record is there when I go back in manually. I'm not sure what to add to the formula to get it back to the created record in edit form. Thanks, KellyOffice Hours Cancelled August 4th to the 8th. Returning Monday the 11th.
Hello! Sam Trachy's office hours is cancelled this week and return Monday the 11th. If you need help with any challenges, feel free to post a discussion question on this site, join Discord to ask a question, or open up a support case with our tech support team. Thank you!
How to see when a report was created & who created it
I am trying to see if I can find out when a report was created, & what user created it. I know that information is found at the bottom of the page in the tables, but I can't figure it out for the reports. ------------------------------ Laura Diak ------------------------------problem populating relationship field from import
In a new QB app we created, we have a table "Phishing Attempts" where we want to create records by importing a spreadsheet. We also have a table "Targeted Users" which has employee info such as Employee ID, email, position, etc. Phishing Attempts table has a relationship with Targeted Users table, where we have the Employee ID field from Targeted Users included in the Phishing Attempts record form along with lookup fields that are automatically pulled from Targeted Users table. The spreadsheet we want to import to create new records in Phishing Attempts table includes an employee ID number. When we import the spreadsheet, we select the target field Employee ID in the Phishing Attempts form. The problem is that the Employee ID field in the Phishing Attempts form is not populating when we do the import. The ID number in the spreadsheet matches exactly what is in Employee ID in Targeted Users table. Is this not working because the Employee ID field in Phishing Attempts is pulling from Targeted Users table? Is there a way to get this to work?Records, Pipelines, and Callable Pipelines clarification
Hello! I am a new user, and I'm looking for some clarifications on some of the specifics about how records, pipelines, and the callable pipelines action relate. I have a complex pipeline trigger by a user record creation. The pipeline runs through a substantial decision tree and updates records and sends notifications depending on the path through the decision tree the record takes. However, I have run out of actions and need to set up a callable pipeline to do some record validation (instead of adding those steps into the main pipeline). So, I am working on setting up the callable pipeline, but I want to make sure that the pipelines are only updating a given record, and not ALL records. - Update: before you read the next part of the post, consider that I may be overthinking this whole thing and I just need to pass through the record ID(s) for the records I want my called pipeline to validate. - I assume that when a pipeline runs with the "record created" trigger that the pipeline will run only with relation to a given record; i.e. is the context of the pipeline run a single record? Is that correct, or does it evaluate the whole table of records? Or do I need to set a record limit on the trigger? When I use a callable pipeline, does the calling pipeline maintain the context of the call; i.e. for a single or batch of records? Depending on that answer, does the pipeline evaluate each of those records individually, or does it evaluate the entire table with respect to the called field(s)? For example, here are my two actions. I thought I had them set up correctly, but I can't call the fields from the calling pipeline in the called pipeline (third screenshot). Update: this may be because neither of the pipelines are turned on, and I may be using Jinja expressions where I should instead be using aliases which I can set to the calling pipeline's fields (see this video). Do I need to bother with passing the record IDs ("a.id"), or are those "implicit"? Call action: Called trigger: Not finding called fields: BUT let's assume that I get these calls to work. Will the changes to the records made in the calling pipeline have been written to the table when the called pipeline is called? Because that pipeline will need to do evaluations based on the records' data, which is dependent on the actions in the calling pipeline! Thanks for all of your help!
