Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I need a pipeline to populate a field in a new record with the names from another field. Many users did not update their profile with a ‘Screen Name’ so I can’t use that field in the pipeline. I am having trouble getting it to populate using the First and Last Names. What formula can I use in Pipelines to create a list of multiple names?I used this field to create a text field and this is what is returned: Using this text field is not ideal as Barb does not have a screen name so it defaults to her email address. If there are several users, this field will be harder to read with emails being used. I want the pipeline to take the Fundraisers Assigned values and populate like this – preferably comma separated but semi-colon is fine too. Example: Amy Gosz, Barba
Hello, I want to convert CSV to vcard file format. i don?t know how to that convert if you know...... recommends.......
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?
Does anyone have a good way to add a file name to a file attachment? When in the field and we click the 'add file attachment' button/ link, we usually take a photo with the ipad to embed there. Is there a better way than making a text field for naming? Any way to do this manually?
Is there a good way to show the # of records where each option from a multi-select text field is selected WITHOUT showing every single unique combinations. For example, if Option A is selected on one record, Option A AND Option B would NOT be a separate bar on the bar chart, it would just show the actual choices in the field.
Not sure where to post/send this, but I would like to request a modification to the user experience when editing records from the table home page. When you click on either the pencil or eye icon to edit/view a record and then you save/cancel and close you are taken back to the very top of the table. This is fine when you only have a few records, but when you have several pages, it is frustrating to have to scroll back down the table to find the place where you left off. Would appreciate a way for it to remember where I left off and then return me to that location.Just a thought.
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!
I can't seem to wrap my head around this. I have a record with a multiselect field. When conditions are met, I want a pipeline to take data from the record and create a new record in another table, creating one record for every value in a multi-select field. I can't seem to figur eout where I would put the jinja to split those values and then loop through them. Googling came up with the following for the Jinja:{% set selected_values = a.your_multi_select_field | split(';') %}But where would I put this? Seems like I need a step after my trigger to do this, but there isn't a "jinja" channel.
Is there a way to upload a personal image (ie: company logo) to use as an app icon? I know it's possible to change the icon color and image to pre-programmed options but have not found a place to upload a personal image.
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?
I am trying to import data by adding existing data which is in another table but I am seeing a weird behaviour that rather than selecting the option which is already present it tries to create new option and as the option is more inside the main table it is throwing me error. Please give a reply ASAP
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 - Hayley
Hi,I'm getting errors on my pipelines for a multi-line field.Quickbase reported an error: 11 : Could not parse XML input : XML Parsing Error. not well-formed (invalid token) at line 3 column 353 (which is byte 700)When I look through the activity log and the original db i'm seeing these characters: †and “. When I talked with the users they said they did not put them in the field. After a little research it looks like it was a copy and paste issue. My question is how can i prevent this from being sent through the pipeline?Thank you
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.
There used to be a button to send test notifications, is this gone?
Hi all. I'm trying to find a way (either using a formula or in Pipelines) to join a multi-line text field to a single line.Use case: The multi-line text field will contain text that will go to the JSON request body of an API call in Pipelines, so the field needs to be converted to a single line. The field has to a multi-line text field, because values can contain several paragraphs and app users can easily customize it.Thanks!
I have field where users can enter data and divide them by using Enter: XXXXXX YYYYYY For another field summary I would like to convert this way of entering into:{XXXXXX; YYYYYY}I was thinking to use formula "SearchAndReplace" but I am not sure what to enter in Search for?: SearchAndReplace([1-Step feeder(s) - after AltBOM],"?????","; ") In excel I would search for Char(10) but how to find "Enter" in QuickBase?I tried to Trim, but does not work.I tried to use in formula enter but after save it is converted to "/n "Any ideas how to search and replace "ENTER" between numbers? There might be more then 1 enter.------------------------------Adam Krzyzanek------------------------------
I am using a staging table to compare a .CSV import to a bunch of live data.I have maybe 50 fields to compare and I am trying to check a few thousand records regularly and just flag the fields that have changed.This is typically pretty straightforward as they are text fields and using a List function and a bunch of if statements, I can easily display the field names when Live Field A <> Import Field A.My issue is lots of text fields are appearing as not equal, though they look the same when displaying them. I have used the tricks I know to tidy up hidden characters...var text A = SearchAndReplace([Live Field A],"\n"," ");var text C = SearchAndReplace($B,"<br>"," ");Trim(Upper($B))This removes next line and carriage returns and makes all uppercase and trims extra spaces. I apply this to both fields, they have the same length of characters, look identical, even copy/pasting them to Notepad++ and turning on hidden characters they look the same but ac
I would like to create a formula text field that replaces all carriage returns in another multi-line field with a comma or period or some other delimiter. Is there a way to do this?Thanks in advance.
Hello, I have searched for this subject and found 1 post with 0 responses. I'm pulling in info from QB using Power Query, a Multi-line text field is not pulling at all when there are multiple lines created using a carriage return / line feed. Is there a function similar to CLEAN (instead of TRIM)? or how can I replace the non visible carriage return using another text formula field (without taking the table down clean it and re-uploading) thanks,------------------------------Ayman Hanash------------------------------
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{
Hi all! I've had an app built for years that houses my internship program data. It sends out an open notification to internship supervisors to evaluate our students' performance near the end of their internship. The notification contains a link that takes them into the app to complete a form which pulls goal data from the student's workplan to be evaluated on. It last worked properly (was completed by a supervisor) on 7/6). This week, particularly the last 2 days, my team started getting emails saying the link shows them the form for about a second, gives an error code, and takes them to a log in page. Supervisors have never needed to log in before. Just click the link and they access the form.I'm not super savvy at Quickbase - any ideas on what happened/broke?
If this topic has been discussed and there are well known solutions to this topic - I apologize. I didn't come across any before I came up with the solution below.Background:I was working on a request from my team to build out some functionality that required a lot of check boxes. I didn't want to take a lot of time building a custom form to ensure that the checkbox data was stored with a row for each box. There are 28 checkboxes representing various issues (oil leak, lights, forklift forks, etc). While not totally necessary, I did hope I could somehow un-pivot these columns into a table where only issues that were checked had a record.TLDR;Using fetch JSON and the Quickbase API, you're creating a list of field ids that you want to unpivot and then for each record in a second set of JSON data, you are looping through that field list and creating a new single record in a 2nd table with the values you are unpivoting as well as any other data you wish to repeat in each new row. 
Are there any tips out there of how to let a user sign in without the Quickbase branding screen. I have a situation where customers will be logging into a supplier Quickbase app, with proper userids. But we want to suppress all the Quickbase branding on that page. ------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------
I am trying to have a button from a button bar on the Dashboard open up a PDF. What is the best way to achieve this?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.