Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hey all,Running into an issue when trying to assign any data to created custom fields in QBO via a Create or Update Estimate step in Pipelines. No matter what I try to pass, it errors out on me with the following:Remote service reported an error: Property Name:failed to parse json object; a property specified is unsupported or invalid intuit_tid: 1-6785955b-5d1bbc6935b5cc642b5ee13eNow, there is no Property Name on an Estimate in QBO, and none of the custom fields set up are titled Property Name. All I've been trying to do is figure out which of the 3 custom fields are which, since the names of the field don't show up in Pipelines and I only want to pass information to one.Any idea what restrictions there are on utilizing these custom fields here?
Hi all.I have a request to create a dashboard widget that has potentially 7 calculated columns. I am not sure the best way to accomplish this. I am relatively new to QuickBase and I have taken some of the training, but this seems a little beyond what I learned. Its also only the second app I have worked on. In a nutshell, I have a table we can call DATA, in that table are Market Classes, Close Dates, and $$ Values. Example: DATA Market Class CloseDate $$ValuePepsi 1/13/25 100.00Coke 1/21/25 85.00Fanta 6/1/25 200.00Cok
I have seen post about this error but I have yet to find anything to help me figure out how to resolve the error with my pipeline. Validation error: Incorrect template "{{c.related_member}}". ValueError: invalid literal for int() with base 10: 'related_member' This related member field is a text field that holds email addresses when populated. The field I am looking to update records with is also a text field and holds email addresses. I don't know what to do to resolve this. Any input would be greatly appreciated.------------------------------James Carr------------------------------
Hello,I'm attempting to build a formula field that will mark a checkbox if [Date] is within 2 days of [Original Referral Date] OR [Date] is within 2 days of [Client - Re-opened Date] OR [Date] is within 2 days of [Client - Re-opened Date 2] OR [Date] is within 2 days of [Client - Re-opened Date 3] OR [Date] is within 2 days of [Client - Re-opened Date 4]. Essentially if the Date is within 2 Days of any of the above days I want to the checkbox to be marked! Here is the formula I've built to attempt this:If(ToDate([Date]<=([Client - Original Referral Date]+Days(2)) or ToDate([Date]<=([Client - Original Referral Date]+Days(2)) or ToDate([Date]<=([Client - Re-Opened Date 2]+Days(2))or ToDate([Date]<=([Client - Re-Opened Date 3]+Days(2)) or ToDate([Date]<=([Client - Re-Opened Date 4]+Days(2)), true)I keep getting an error on the last portion of this formula: "Expecting text/datetime/workdate/number but found bool" :(Any ideas as to what I can do differently? This is
I have used this function before on other projects. With the current client I am working with, the invoice creation always sets up as $0.00. It doesnt matter if i pull the number from a field of just type a value. I have tried all different types of values. It sets up the customer fine, but when it sets up the invoice, the product/service and amount are blank. I really hope someone can help here. I don't get what is happening.
I'd like to limit the number of rows displayed on a report to only rows where data already exists. I have several forms where a report is editable whenever displayed on a form in edit mode. The risk is that users can type in those rows. I've done scenario testing and I can see how a user could create some problems that will actually get them locked into a no win scenario where they are in conflict with form rules and unable to remove the extra rows created while unable to proceed. It's particularly true if one of the fields is a required field. Obviously orphans can occur if they have to close the browser. Below is a screenshot of an example where the report renders 3 rows but shows 4 additional rows.Is there a way to limit editable rows to only those already containing data when rendered?
I am wondering if it is possible to create a report that asks the user for a value to be found in a multiline text field. For instance, when I click to generate the report a field will display asking what you would like to search for. If I entered the value "Jason", it would search all records that have the word "Jason" in a particular text field.Is this possible?Brian
I'm not proud, lol. Asking for help with my tail between my legs. I'm missing something here. I'm in a form in Table "A". I want my button to open a different form in the same table in edit mode and check a checkbox. THAT'S IT! Here's what I currently have: URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "&dfid=14" & "&apptoken=apptoken" & "&_fid_216=1" & "&z=" & Rurl()Thanks for any suggestions!
I have been out of QuickBase for a couple years and a lot has changed. Hence, my return to Empower this year! I am playing around with Forms and want to see if there is a way to integrate this view into my Tables as a primary view instead of a report/ legacy view? It seems this would be a nice view to have within the tool as well instead of just for use in other places? Let me know if I am missing something as I cannot find how to use forms without a link/ email/ etc. Thanks in advance!
Any idea why I'm getting this weird behavior when trying to add a start date field to a predecessor field? A transparent circle with a shadow shows up, but no date options (and I definitely have date fields):
I have a Button in our QB App that creates a Folder for that Child Account name in Dropbox, it then takes the Dropbox Link for that Folder and puts it into a Field in the Child Account Form. I want a Field that creates a QR Code that takes the person scanning the QR to that Specific Dropbox Folder.This is the Formula that i have write now, but its not opening the folder.var text URL = URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Dropbox Folder URL]);"<img src='https://quickchart.io/chart?cht=qr&chs=180x180&chl=" & URLEncode($URL)& "'>"
I've been with quickbase for almost 20 years. Never once have I had an issue with importing data into an existing database or one I just created. Now, since last week, importing just 9 fields from a simple MS Excel CSV, it imports into just 2 fields instead of 9. This isn't even slightly complicated; just 9 simple fields. I recreated the database and the spreadsheet into different formats several times and still it ends up this way.I provided support access to the database last week, Friday and have not heard back from them since. This is a new client's database my company needs now and I'm lost on what to do.
Hi. I have a requirement to provide access to a user in following manner. Please let me know the best solution.Requirement:If a user is record owner and record's region is ABC, then user should have access to modify all field information in the record.If the same user is not the record owner, irrespective of the region, the user should have access to modify only one field (checkbox field) in the record.
Hello Construction Qrew! I hope everyone is having a good new year so far. I want to share with the Construction Qrew that we will be cancelling January’s Construction Qrew Meet up and resume with a new agenda and update for February. Please stay tuned for more details. In the meantime, I want to invite you our Safety Apps Overview Qrew Meet Up we are hosting on tomorrow Wednesday 1/8/25 at 12pm EST. This meeting is open to all customers and will walk through our safety suite with a Quickbase expert. Register and login here: https://quickbase.zoom.us/meeting/register/tJAsduyuqjwoEt20a29KdKHnHj4vwTn8fexD Feel free to reach out with any questions or feedback. Thank you and I look forward to seeing you at an upcoming Qrew Meet Up.
My objective is to prevent users from exceeding the available budget when logging time. Users can attach multiple task records to the DSR (Daily Status Report), and those tasks can belong to different budgets.I want to use a Formula query to obtain the value in the [Remainder (Available)] Field 64 of _dbid_budget, and compare the total of hours logged in [Units Delivered] Field 103 of _DBID_TASKS. Once all tasks are attached to a DSR, the Total Units Delivered Field 108 of _DBID_TIME_CARD (where the DSRs reside), I would want to compare available budget to hours consumed on tasks, and if there is an overage i will stop the flow of the report until it is resolved.I used a summary [Budget Line - Record ID# (Text)] field 267 on the DSR form configured for combined text, and was able to validate that I can see two correct record ID's when attaching 3 tasks and two of them using the same budget.The [Total Available Budget] field 268 formula on _DBID_TIME_CARD has no errors, but
Hi ,I'm using QB & struggling to complete my formula with a date.Basically I want to write:==> If([Release Date (Manual)]<>null,ToDate([Release Date]),[Release Date (Manual)]So 'if the Manual field is empty, take the normal release date field, otherwise: take the manual field'.--> However, it's giving an error on the red part: "Expecting text/datetime/workdate but found date"What am I doing wrong :( ? Thx !
All:I have an application that I want to build an integration with monday.com with. When a new "record" is entered or when a record is updated in monday.com, I want to create/or update a record in the QB application. Anyone do this RECENTLY with a pipeline?Thanks!Melissa
Hello All!This is my first post to the discussion board. I'm hoping someone can help me with a button and a pipeline.I have a button that when pushed is supposed to start my pipeline to link to Formstack and generate a document with data from QuickBase. However, when this butt is clicked, we receive a URL error "about:blank#blocked" Formstack reviewed my internet settings and we have tried different browsers to end up with the same error. Can anyone help me with this? TIA!
Hi all, I've been trying to sort this out for too long. I have a form (Form A) with a URL link to another form (Form B) for the same Table. When you click the link it should save the form, create the RECORD ID and use that RID to go to Form B. For some reason the "%%rid%%" functionality isn't working for this. Here is the formula I am using:var text recordid = "%%rid%%";URLRoot() & "db/*********=er&dfid=24&rid=" & $recordid & "&z=" & Rurl() & "&ifv=1"It says: "DRS Record not found". When I look at the URL that it directed me to it still has "%%rid"" in the actual URL instead of the new Record ID.I have tested this url by hard coding in the next RECORD ID that will be created and the URL link works. I just need the new RECORD ID to be in the formula - URL and it's all golden.
Maybe this is not possible, but I'd like to insert variables in the class definition so that the stat of the record referenced changes the color and text of button in the report.The button [Edit DSR on Active Page] exists in a report on the user home page.The user initiates editing of an incomplete record by hitting that button, editing it until they they hit [Save & Continue] which will increment the [Active Form] which is a page counter. User also decrement [Active Form] it if they hit the [Back] button.When the user reaches form 4, they are there simply to review their work. If they hit [Save & Finish Later] they return to the home page --- That's where the scenario changes. I'm attempting to use fields to provide dynamic color values so when they see the record in the report on their home page it will be green instead of blue and black text instead of red. If possible I'd also change the text.I made a copy of [Edit DSR on Active Page] and labeled it "Update DSR", then
Does anyone know if QB will sunset legacy forms? If so, what is the date, if known? I am curious if I should start rebuilding in the new format now in preparation.
I'm trying to create a field that combines an employee's alphanumeric id from one field, with the date in another field. I can't find a formula that will allow me to link a text field with a date field, but am wondering if I'm able to convert the date to text?------------------------------Monica Bridges------------------------------
I have created a parent table called "time reports" and a child table called "time spend on projects."On the "Time Reports" form, the user is able to enter the percent of their time they worked on each project using a grid edit/editable embedded table. The child records in the report have already been created by a pipeline. The user just enters the percent. The user does not create any new rows. I'd like the user to be able to see that their percents total 100%. I have created a summary field on the "Time Reports" form, but it doesn't update until the record is saved. I tried creating a button to just reload the page (having the auto-save setting turned on), but the data entered in the embedded table isn't saving, so it totally clears their work.Do you know a way to check the total value of child records while on a parent record live? Or a work around?I looked for past posts on this topic, but couldn't find any. Maybe I was trying the wrong key words. If you know of another p
Hello everyone, I am a master’s student, currently working on my thesis in the field of low-code development. I have compiled a list of requirements and would like to determine how well the platform meets them. It would be sufficient if you could simply respond to each requirement with “yes,” “no,” or “partially.” I hope it’s alright that I’m posting this here. I’ve tested the free trial versions extensively, but I’m still not entirely certain if this platform suits my needs. Thank you in advance for your feedback. (F1) Overview & ProgressStatus, capacities(F2) Notifications & Appointment SchedulingAutomated e-mails, reminders(F3) Document GenerationFor example PDF, digital signatures(F4) Automatic Calculation of DeadlinesFor example: deadline = start date + X days(F5) Central Document RepositoryStructured storage, archiving(F6) Template LibraryDigital forms to be filled out online(F7) Different Role ProfilesPermissions for students vs. supervisors(F8) Document Feedba
Hi all,I have two forms - 2024 and 2025 versions of the same form. I would like to simultaneously allow users to:Click the edit button next to a record and be taken to a certain form (ex. 2024)Click a link and be able to edit either the 2024 or 2025 formRight now #1 is working fine, but #2 brings up the "primary" form (aka the one that is set in the Forms menu for edit permissions for all roles) regardless of the form ID I use in the URL. Is there some way I can override what form is utilized for the URL fields?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.