Forum Widgets
Recent Discussions
Invalid 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?Solved0likes1Comment
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!Solved0likes2Comments
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?Solved0likes2Comments
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.Solved1like4CommentsGetRecords 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? ThanksSolved0likes3CommentsMatching Fonts on Templates using Rich Text and Standard text
Hi, I'm very new to the quickbase world and trying to manage an app that was built for my agency. My question is about changing the font that prints from a form in Rich Text. We have several forms that use templates to print out and when there are both rich text fields and standard text fields used, the rich text fields default is different than the standard text in both size and font. This obviously looks terrible but I can't find a way to adjust it. I have read several articles and conversations about using rich text with HTML tags, but I can't find a way to actually adjust the font (I think prior to 2023 the options in Rich Text fields, were well richer). Can someone offer a suggestion. BTW, I am not a programmer so I need basic instructions on where to find things and how to adjust them. HELP! And TIA - HayleySolved0likes2CommentsPipeline Jinja For Duration in Seconds
I would like to have a pipeline condition where nothing happens if the current time is less than or equal to 30 seconds from the value in a given field, which is a date/time field. I have tried multiple variations of jinja code and mostly get the error message: Validation error: Incorrect template "whatever my jinja is". ValueError: invalid literal for int() with base 10: 'my_date_time_field_name' I have tried subtracting and converting the time.now and my field to an integer before comparing to 30 for seconds, I tried using time.delta(seconds=30) and adding it to the date field then comparing it to the current time, and some other things. I get the above error each time. I would really like to do this with Jinja, if at all possible. If anyone can help, that would be greatly appreciated. I know, worse comes to worst, I can add a helper field and just work off of that, but I am doing this for learning purposes. Thank you in advance to anyone who can help.Solved1like10Comments
Help with searches...
i set up a report that lists each vendor and what states they checked off for service area, they are checkboxes, i don't know how to make it group all vendors that service alabama, all vendors that service alaska, all vendors that service arizona, etc... my ultimate goal is to create a search widget that will filter by service area i inherited this app and it was seriously lacking. i'm new to creating and working on app setups. i have taken the intro to app building and intro to pipelines courses so that i could make some changes and i just can't figure this out.Solved1like1Comment
Bulk upsert field limit in pipeline
Hi, I have a pipeline that I'm using the bulk upsert steps for. Essentially, I'm just copying data from one table to another table and I need to do this bi-weekly. It's my first time using this bulk upsert and now I see there is a 250 field limit. Is there any way around this limit? I checked online and the solution seems to be to using a helper table, I'm not sure how to do this. I only have about 400 fields so I don't want to do that if unnecessary. I also saw something about a loop but I don't know how to do this either. What's the best way to go about this? I have the following steps in my pipeline: Prepare bulk record upsert Search Records In Loop: Add a bulk upsert row - End loop Commit upsertSolved0likes6Comments
