Recent Discussions
Duplicate Record & Add new/different data PIPELINE
parent table - TAKE/OFFs child table - TAKE/OFF CALCULATIONS Take/Offs create record in Take/Off Calculations using a pipeline Take/Offs FIELD [PLAN OR OPTION NAME] contains MASTER is the only field "pipelined" into the TAKE/OFF CALCULATIONS table Now, I need a PIPELINE to add 5 additional records duplicating same [PLAN OR OPTION NAME]......New records will then contain selections from multiple choice field [CALCULATION TYPE] In summary, starts with this record: TEST.PLAN.MASTER - no data in CALCULATION TYPE field Need: TEST.PLAN.MASTER with selection from Calculation Type field - WALLS.INTERIOR and TEST.PLAN.MASTER with selection from Calculation Type field - CEILING.INTERIOR and TEST.PLAN.MASTER with selection from Calculation Type field - WALLS EXTERIOR and ETC thank you0likes0CommentsPipeline Jinja url decode
In a Pipeline, you can use the Jinja urlencode filter to encode a value that needs to be safely encoded for use somewhere else. However, how can you use the URL Decode function? I am used to Python, JavaScript, and other languages where you can easily use a URL Decode function. In fact, it seems in the full subset of Jinja filters or function, there actually IS a urldecode but that Quickbase hasn't implemented it in their build of Jinja for Pipelines. Any ideas? Desired: {{a.json.url | urldecode}}0likes1CommentButton that adds record #2 from record #1 in same table ... but returning to record #1 after save.
After save, I want to stay on Record # 2 , not return to Record #1 which is what's happening now with code below. Here is my code (I am pre-populating some values in Record #2 from Record #1). The button resides and is clicked in Record # 1. URLRoot() & "db/" & [_Table Name] & "?a=API_GenAddRecordForm&_fid_265=" & URLEncode ([Costing Assigned To]) & "&_fid_268="&URLEncode([Pricing Assigned To]) Note: there is no redirect in my code.0likes26CommentsSample Data not reflecting Default Value (Field Properties, Numeric-Currency)
I am entering a default value, but the sample data is not reporting and when viewing outside of Field Properties, shows blank. I have this function working on two other similar fields, but this one refuses to update. If I can provide any more information, please let me know.Solved0likes2CommentsFormula field to pull selected pending items from checkmark fields
Hello. I have a report/table that has about 32 items that it can have concerns for. I want to see if its possible to have a field where it can let you know which items are pending from all 32 options without manually having to do Multiselect field or scroll all the way down the reports just to see which ones have been selected. Not sure if a formula field can work or would it be a pipeline?0likes7CommentsApp Archive Strategies
Does anyone have a way that they save/archive their app structure/build before deleting an app? I'm doing some clean-up in our realm, and we have a bunch of old, unused apps. I want to archive/delete them, but I'm thinking of the off chance someone comes back and says "remember that app we had? can we get something like that again?". I'm thinking I could use the new solutions APIs to get the QBL exported, but that doesn't support reports, forms, pipelines, etc. yet. Just curious what others' app archive strategies are!0likes4CommentsSum Overlapping Time/Remove Timeframe Gaps
Hi all, is there a way to do this formula queries? I have a table of people who have child residence & employment records, with start & end dates for each, as well as a numeric field that summarizes each timeframe in months. I need to query for all child residence & employment records related to each person, find any potential overlapping timeframes between the 2 tables based on start & end dates, and sum the total # of months from the Duration (months) field from applicable records. Essentially I need a final number in months of time each person provided to us across 2 tables, so any overlapping time would basically get deduped out. I also need it to be smart enough to recognize some of these timeframes are not contiguous and contain gaps, so we might not have any date for particular person from 2010-2015, but we do from 2005-10 and 15-18, so any gaps would need to be excluded from the final count.0likes7CommentsFormula help
I am trying to accomplish this: I want a report that will show me clients in a week how many times a record was made with the filter No Show So a client is booked - he does not show on Monday, on the form he gets a Q of no show. then he shows up on Wed and we proceed with what we do. I want to run a report of only those customers. Now I can run a report that shows me all Q that = No Show and sort by Client but it only shows the no shows it does not show any of the other time they might of come. If I don't use the filter no show then I sort and group by customer and it shows me everything and then i can see it but there are hundreds and eventually more. I have a summary field that counts the qualified tours as a 1 and the no show as 0 but other things are 0 as well (other unqualified) QB tech support is sort of helping but it's not working and I am pressed for time. They originally said this - So I created a summary field on (child record) and filtered by created in a week. Then it was not clear on setting up the formula ( is it in report or another field - well I did both and got the same result. when I created If([Weekly No Show Count] = 2, true, false) the True was yellow no matter what I did on either the formula in the report or a new field. It had to do with the boolan Then I created a check box formula thinking that would help - If Q said NO SHOW check the box thinking I could make that work. First we need to create a summary field in the parent table: Name: Weekly No Show Count Summarize Field: [Child Record ID#] (or any unique field in the child table) Filter: Date created is within the current week. Second we can setup the formula: If([Weekly No Show Count] = 2, true, false) This formula will return true for customers who have exactly 2 child records within the given week. And for last we can create a report that would display those records. Report Type: Table Filters: Is No Show Twice This Week is checked (true) and then in the report table - when it said use those above filters is why I made a check box. I am leaving for a few days and didn't want to leave this hanging out in QB tech support world as they would of course close the case - I have messaged several times but to no avail - this case has been opened for a long time already0likes2CommentsAsk The User Exact Search
Hi, I have a report that asks the user to input a value and returns the result. I am searching for Asset records assigned to a user, or client. Because these clients are formatted with "HFT" and leading zeros for a number less than 3, the clients look something like these examples: "HFT055", "HFT006", and "HFT545". I made a formula field that removes the "HFT" and appends leading zeros, and have the report set to "Store Search" (my formula field) contains "Ask the User". My goal here is to allow the user to only input the number, not HFT or leading zeros. Formula: "HFT" & PadLeft(ToText([Related Client]), 3, "0") This current setup works in a sense but also pulls up other records due to the contains criteria. When I change the filter to "Is Equal To" nothing shows up. Can this work so the user inputs just a number, such as 55, and it would pull up an exact match of all assets assigned to user HFT055?0likes1CommentURL formula -API_RunImport
I would like to create a URL formula button -- that when clicked it will run a table to table import --- this is what I have created (did not work) var text URLONE = URLRoot() & "db/" & [Table ID] & "?act=API_RunImport&ID="&[TableImportID]&""; $URLONESolved0likes12Comments