Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi all, please can someone help me! I have to create a date field that needs to auto populate when a certain tick box field has been selected. Basically we want to create a report to show a date that one of the tick boxes was selected. We already have an email alert for this tick box, but they need to run a report, so need to create an auto populated date field for this.My formula skills are shocking and need your expert advice!Thanks
I have an invoice line item table with a non-key field Invoice #. Some lines have the same invoice number. These lines with the same invoice number are usually entered by the user at the same time (because there's more than one line per invoice).I want to use a pipeline to create an invoice header from the lines. I have a table with a custom key that is that invoice #. Of course it needs to be unique. I know that if I use upsert I can insert new invoice headers and update existing ones. Right now I have my filter set to pull all invoice lines added in the last few minutes. But some in that set will have duplicate invoice numbers, and the upsert does not allow this within the same commit - it errors out on the duplicate key.Is there a way to commit one record at a time with upsert? Or should I be doing this a different way?
I have a form that has a member ID and also first and last names...in that same form I need to capture in another field the previous member ID and name should the user change the name or mbr ID in the text/numerical fields. I'm unsure how to set this up the fields in the same form and if / how to do this in a pipeline or another way.
I am trying to have a pipeline enter the current time and a time 2 minutes prior into two seperate fields. Below are the values I am using. It doesnt work because the format isnt allowed in a time of day field. How do I format the values properly?{{time.now}}{{time.now - time.delta(minutes=2)}}
Hi,I have a scenario where user wants to check whether the record already exists or not at the time of creating record.For Example: User wants to create a product ,clicked on add record button of the table and while filling the product name in the text field it should reflect that particular product already exists. User is already aware that he/she can search in table report first and if it exists then go for editing that record otherwise create, but this will not work if user have multiple entries to add in that case user has to go back and check over and over again which consumes time.Kindly help!
This will probably be a hot topic, but it needs to be said since the better legacy builder UI is being removed soon. Posting here rather than a "suggestion" because in my 6 years of doing QuickBase Development, the suggestions page has proven to be basically useless at getting the word out on issues.Overall the new PL Builder UI only offers ONE feature that is a benefit, which is full step-reordering. But, this should have just been added to the old UI. Who asked for a new UI? The new UI, overall, is just cumbersome/slow and annoying to use.I have waited for a long time now, expecting the UI to be improved, but I've see no such fixes to the issues the new UI has, as such it is now time to talk about it.See my images below with added notes.Below is probably one of the absolute worse design choices overall; Why do we have to OPEN each section of the step? What value does this add? All this does is slow down the process by forcing me to go "open, open,
I am looking for a way to not just pass the parent Key field to the child document records I create. I want to be able to pass other field data into fields in the child record. For example currently when you add an individual document to a child record you can include code that let's you update other fields like this:URLRoot() & "db/" & [_DBID_NOTES] & "?a=API_GenAddRecordForm&_fid_18=" & URLEncode ([Record ID#])& "&_fid_6=" & URLEncode ([Account Number])& "&_fid_17=" & URLEncode ([AccountNow])& "&z=" & Rurl() This will put the Record ID# in the Related Claim field... the Account Number in field id#6 and the AccountNow text in the field ID#17 in the child table.I can't figure out how to do that with the URL from the File Manager Plugin that looks like this:var Text realmHostName = NotRight(NotLeft(URLRoot(), 8), "/");"https://api.plugins.quickbase.com/launch?pluginId=qb-uploader&pid=" & [Record ID#] &
From the parent table (FWA Investigations) a task record (child table: Tasks) can be added and displays in the parent table. I want to create a report that will show me when there aren't any task records that have been created under the parent table.
Has anyone else encountered this issue? I am using a sandbox for my app and editing an existing form (using the new forms) and get a warning message.I find the form rule with an issue and have tried disabling, deleting, and editing the conditions, yet no matter what I do, when I try to save the form, I still get:I don't know if checking the performance of forms is a new feature during save, but there is no guidance anywhere on what to do when you run into this error. Is anyone else running into this issue?
I currently am using a Formula Query to identify when specific fields match it returns the Record ID# that has the matching data. This is to help identify duplicate record entries for things that can not be unique fields.It works just fine.I am now trying to figure out a Formula Query to look for records that should share the same data in 3 specific fields but doesn't.The logic would be When [Field 5] equals [Field 6] but not equal to [Field 7] return [Record ID#]What needs to go in the butnot location for my logic to work for this Formula Query?GetFieldValues(GetRecords("{5.EX. ' "&[Field 5] &" '} AND {6.EX. ' "&[Field 6] &" '} butnot {7.EX. ' "&[Field 7] &" '} AND {3.EXE. ' "&[Record ID#] &" '}" ),3)------------------------------Jovan Vucovich------------------------------
Hi All,I am having troubles trying to via a button to add a new record then refresh the current record.As a button can't trigger a Pipeline, I've created a checkbox field to act as a trigger field. Currently the button uses an API_EditRecord to edit the checkbox and refresh the record. The API_EditRecord triggers my pipeline however the refresh happens before the Pipeline has a chance to complete.I saw this thread where we can create a HTML Code page to do a pause and refresh.https://community.quickbase.com/discussions/quickbase-discussions/save-new-record-pause-refresh/19873/replies/19876I thought I might be able to tag that to the end of my current URL code to run afterwards, however it seems with the record refresh, it never gets to this part.My current code is as follows.URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_371=1" & "&apptoken=xxxxxxx" & "&rdr=" & URLEncode( URLRoot() & "db/" & Dbid()
Hi there, As my quickbase attachments space is reaching the storage limit, I hope to check all my documents by size and start to remove the largest files. I can sort all documents by the date, by name, or by other fields. However, I was wondering can I create a field to show the size of the files? Like, we can sort emails by attachment size and delete those largest. Thank you. ------------------------------Ning W------------------------------
I have two tables -- Parent Table A and Child Table B.When importing records into Child Table B --- if there is not a Parent Table A "related record" -- I would like to create a new "Related Record" for Parent Table A --- Note: there may be multiple child records that have the same ParentID that need a "new" related parent record --- I'm not sure I would go about creating a Unique List of Parent records that need to be created. - appreciate any help.
Is it possible to add a condition in a pipeline that 'catches' a non-2XX HTTP response from a Fetch JSON or webhooks request. It seems pipelines automatically go into a failed status if anything but a 2XX code is returned.I tried a condition with 'Status' equal to 404 (for example) but the pipeline still failed rather than branching. Thanks
Hi All,I'm trying to add a new button that would copy the text of a field to my clipboard. I've seen posts about this from the past, but they all use JavaScript, and I get the "Only text, Quickbase-accepted functions, fields, variables, and certain HTML tags are allowed in this field. JavaScript is not supported" error when I try saving.Does anyone know how to do this today?Thanks,------------------------------Daniel Johnson------------------------------
Greetings, Am I correct to understand that the new forms do not yet support mobile views? I started building a new app last week using the new forms and it seems the mobile view/app only uses the legacy form. That may also explain why I cannot seem to delete the legacy form. Thanks.------------------------------Rick Putnam------------------------------
Wondering if its possible to have buttons field utilized in a report remain clickable when the report is switched into grid-edit mode?------------------------------Chris Swirtz------------------------------
Right now, I have a table, call it "Issues." There is a Pipeline that is triggered when any field is updated in an Issues record; this creates a new record in the "Edits" table, and Last Modified By and Date Modified are written to this new "Edit" record.What I want to do is find out which field (or fields) caused the Pipeline to trigger. For example, in the "Issue" record, did the user change the value in the Status field or the Next Step field? Or both? I know I can use $prev to access the value before the edit (and ultimately I want to store this in the Edit record). Is there a way to access the name or fid of the field(s) that changed and triggered the pipeline?------------------------------Aaron Alpert------------------------------
I feel like there must be a way to do this that I just can't think of. I have a funnel report that's based on a formula field with an if statement, which itself is based on evaluating whether a variety of different formula checkboxes are checked or not. I have 6 different categories that people could fall into. Each category gets more specific/narrow, but overall they're evaluating basically the same thing (proximity to a particular address). So I want a way to not deduplicate across categories. For instance, Person A meets criteria 1 (lives within 1 mile), 2 (lives within 2 miles, etc.), 3, 4, 5, 6, they currently show up in that slice of the funnel based on which clause of the if statement evaluates to true.But because of how if statements work, this person won't show up in the slice of the funnel for people who meet criteria 1, 2, 3, 4, 5, and so on, which sort of defeats the purpose of a funnel report, as I want to see how the number of people in each category dwindles as it gets m
Hello everyone,We are looking for some assistance with some PowerBI reports that are linked to QB. We already have the channel working and have some reports that were created by a developer who is no longer with the company. The issue is that these reports no longer seem to be updating and we are having some difficulty understanding why. If you have any recommendations, that would be greatly appreciated. Of course, we are willing to bring in a consultant for an hour to help us with this issue as well.Thank you in advance!
New learner here. I'm trying to copy a ticket record and open new copy in edit mode. After I copy, I need the original record I copied from to automatically mark the <Status Field> (which is a text-multiple choice field) to "Expired" and the new ticket record <Status Field> to "Current". I'm not sure the best way to do this, or if there may be a more efficient way not using the <Status Field>.
We have two quickbase apps. Lets say app 1 and app 2. In app 2, i have pulled in table1 from app 1 and added two new fields. I now need to send those two new fields back to app 1. I would assume that it would be a relationship from app 1 table 1 to app 2 table 2 but how do I make the connection on record id #. On app 2 I pulled in the record id from app 1 but not sure how to make that connection back on the record #. Thanks,
I have a use case where the goal is to very quickly scan bar codes into a Quick Base table. The desired workflow is to be sitting on an Add Record form and have the scan also cause the form to save and refresh into the Save and Add Another page, without the user having to click the save button.Does anyone have a native or non native way to do this?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------
On mobile, to activate the scan button, the user must tap the text box. I need "something" to activate the scan button automatically when the user lands on my form. I only have 1 text box and it will be receiving a scan. It would be okay to have a button that saves the scan and goes to a new record and activates the scan button automatically. I have been searching and trying out option on my own but can't seem to get away from the "3 tap" scan scenario. Fast food restaurants will be using this to scan their inventory at receiving so I need it to be quick and easy. Any input is appreciated.
I am working to develop a “queue” for a team of people (around10 or so) to be able to assign any logged tickets in that queue to themselves to work. I came across the following message when two people where assigning the same record to themselves at the same time. Is there a way to prevent another person from editing a record that is already in editing mode? Or some way to prevent conflicts like this from occurring when more than one person at a time is working the queue?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.