Qrew Groups
Connect with others from your area, or who share the same role, professional interest. Find your Qrew here!
Links Banner
Main Content
Recent Discussions
Help/suggestions on simplifying a child table
I'm looking for help/suggestions on simplifying a child table. The attachment is how it currently displays on the parent table. Is there a way to display the lines that are checked Task Completed in a second table below this one? I still want to be able see all the task lines though.Solved33Views0likes2CommentsSearch for Records with no new entries?
I'm trying to determine the best way to analyze records in a single table and return a list of records that had an entry 07-01-2025 but DON'T have an entry for 08-01-2025. I tried a simple table report that had 2 conditions Rate Date is equal to 07-01-2025 and Rate Date is not equal to 08-01-2025, but that just gave me the list of records that did have an entry on 07-01-2025. I'm trying to see which records from 07-01-2025 do not have a record for 08-01-2025.Solved86Views0likes12CommentsInvalid entry error when entering a negative number
I have a numeric-currency field that I am using to adjust a total field. If I edit the record to enter a negative number I get an error Invalid entry. But I can enter a positive number, save and reopen the record, edit the field to add a "-" then it works. So why won't it accept the "-" on the first attempt? Why must I enter the positive value, re-edit, add the "-" in order to make it work?Solved24Views0likes1CommentUsing RegexReplace()
Does this function support capturing groups, and if yes, how does one access the captured data? Intent is to use a this function looking for punctuation from a text field, and then add a new line to this. regex: ([.!?])\s* substitution: $1\n Documentation doesn't state one way or the other. I've tried escaping the new line value without success. Perhaps I'm just missing something simple.Solved120Views0likes4Comments
Removing Invalid Characters for File Name
Good Afternoon, I am trying to manipulate a simple text field to remove the following characters: \ / : * ? " < > | So that I can use it for file names. When I try SearchandReplace, it keeps throwing up syntax errors for these characters despite my double quotes around them. Is there a way to get these characters removed to prevent any file upload issues due to file name? Thank you for the help!Solved49Views0likes2Comments
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?Solved40Views0likes2Comments
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.Solved50Views1like4CommentsGetRecords Formula Help
Looking for assistance to help figure out why my formula isn't working as expected. Setup: Rental Rates table: used to capture the Daily, Weekly, and Monthly rental amounts for Assets. There is a lookup field to select the related asset (FID 12). There is a number field to enter the Rental Year Coverage (FID 14). There is a currency field to capture the Rental Rate (FID 8) Rentals table: used to capture the individual rentals for specific assets. There is a lookup field to select the related asset (FID 6). There is a number field to enter the Rental Year (FID 20). In my Rentals table I have a formula-numeric field and need to find the Rental Rate (Rental Rate table FID 8) IF the related asset (Rental table FID 6) equals the related asset (Rental Rates table FID 12) AND the Rental Year (Rental table FID 20) equals Rental Year Coverage (Rental Rates table FID 14). I found various posts and put together the following formula: GetFieldValues(GetRecords("{12.EX.'"&[Related Asset]&" '}AND{14.EX.'"&[Rental Year]&"'}",[_DBID_RENTAL_RATES]), 8) The field won't save as it is saying that it is Expecting number but found textlist. I tried adding "ToNumber" prefix, but the error just changes to Expecting text/bool/number but found textlist. I have confirmed that each of the fields being compared are of the same type. What am I missing? ThanksSolved61Views0likes3Comments
