Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello,Is it possible to create anchor links on forms? To have a button that will bring you down to a specific spot further down the form?Thanks------------------------------Mackenzie Phillips------------------------------
Is there a way to set default form for new tables in an app to be legacy forms? I've noticed that in older apps, when I create a new table, it uses legacy forms, while in a new app I created recently, new tables default to the new form. The legacy form is available in the table's Form setting, and can be manually switched there.As to why I would want to do that - I'm just used to the old forms and I'm building a demo app with lots of tables, and I don't have time right now to figure out how to do all the things in the new forms that I could do with old forms.thanks!
I have a lookup table that has a relationship with 2 other tables (Table 1 & Table 2).There are 2 different IDs in my lookup table that I need to check in Table 1 & Table 2.I need to check Table 1 if one of the IDs exists, if yes then I need a checkbox ticked. For the other ID, I need to check if it exists in Table 2, if yes then some other checkbox is ticked. How do I go about doing this?
I am looking for a solution that can assign value on click of a button and then saves the record, so that the pipeline can capture the previous values a record. I have different formula URL buttons that updates stage (submitted, rejected, approved) and this change is captured in Audit table through pipeline.URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&apptoken=XYZ" & "&rid=" & [Record ID#] & "&_fid_49=Approved" //Stage = Approved& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=2&z=" & Rurl())I also need to capture the current and previous values of fields that were modified when Approved. The above formula did not work because QB saves the record first, then applies the field changes. This means that by the time a pipeline is triggered, the "previous values" are already overwritten.As an alternative, I excluded fid_49 assignm
Why is my list if formula only returning the first if statement List(", ",If([Engr check]=true and [Engr Approval Status]<>"Approved",UserToName([Engineering Manager Assigned]),If([Production Check]=true and [Production Approval Status]<>"Approved",UserToName([Production Manager Assigned]),If([Quality Check]=true and [Quality Approval Status]<>"Approved",UserToName([Quality Manager Assigned]),If([Additional Check]=true and [Additonal Approval Status]<>"Approved",UserToName([Additional Approval Assigned]))))),"")
Good Afternoon,How do I get an image to display in a document template? Right now all I'm getting is the file name in text. Please see attachments for current document template set up and result.
Wondering if anyone has ever cleared a merge field in a child table?Based upon reference below, we can UPSERT to a child table using a merge field as the surrogate key and the relationship is made (the related parent record id# values are filled in on the child record). Now I am trying to break the relationship so the related value is empty after upsert using the merge field. I have tried 0, "", nil, null and nothing happens. Any ideas are appreciated.Reference below:Link related data by importing into lookup fieldsBuilders now have an easier way to import records with related data or link related data in integrations. Now, any lookup field marked unique on the parent table can be used to match instead of reference fields.RESTful Upsert Records—Users can UPSERT data to lookup fields marked unique in the data array in Record Upsert. https://helpv2.quickbase.com/hc/en-us/articles/31900230487700-Quickbase-November-2024-Release-Notes
Office hours will be held only on Monday and Thursday next week due to EmpowerPro. You can see what's available on the signup page here. Have a great weekend everyone!
In my current application I am building for the purpose of tracking Assets, their monthly rental rates, rental charges for each/month, and monthly invoices for each client.Currently the application has about 10 years' worth of data and this is making some of the reports, forms have long load times as there are at least 3 dozen or so calculations being done across all the tables and forms.My thought was when a month, quarter, year is closed then specific data would be "captured" and moved to another table. The "Archived" table would just hold the results of any calculations previously done, essentially creating a snapshot of that record into another table. The Archived table could then be used for other reports but wouldn't be bogged down with having to do the original calculations, their results would just be summarized.Once this data was captured, the original record would either somehow be closed for editing or get an archived indicator, so they could be excluded from the current mon
I'm trying to paste an image of a map inside a rich text field of a form, but it's not working. I've tried uploading the image and as a URL and it's not displaying.
There is a smart section in the field settings related to the Units description. If this field is filled, the text is supposed to append to the calculated field.When you import this field in a form, append does not work. (See attached pictures).Of course, I can do it straight in the formula but it is a bit sad since this option exists.Somebody knows why ? Is it a bug ?
Hello, I’ve set up an email notification that includes a form with embedded reports. In those reports, each record shows an edit pencil and a view icon next to the record ID. I’d like to remove those icons from the email notification.Currently, access to view or edit is controlled by user roles in QuickBase forms.How can I hide the edit/view options in the embedded reports within the form in the email notifications?
I have a Parent/Child table relationship for two tables. On the Child table there is a date field that I would like to populate up to the Parent table for use on every new child record in the Child table. Do I need to create a new one to many relationship for the current child table to the current Parent table flipping them in this new relationship or can this be done in the current relationsip?ThanksBrian
I have a form (based on a parent table) with 3 embedded reports (based on the same child table).The children reports are the same except that they have one different filter each.I need the Total of a column to calculate another column (class % in my picture).If I use the summary field in the parent table, it gives the total of the all three tables. (See first picture)I also tried with the report formula but I have the same issue.Do that Total field have a name that we can re-use in the formula ?You will find attached some pictures of my form for your understanding
Hi!Use case: On opening a form (new or existing record) I want to auto-populate a field (e.g. timestamp field with now() and a user field with currentUser()) when the fields are currently empty.I tried the following:❌ A trigger that is just user == <other> with a blank field --> should be true on open but does not do anything❌ A custom when formula with the content `true` --> definetly true on open, but does not do anything❌ Record ID != -1 (also always true) does not do anything✅ A trigger "when checkbox is checked" using a helper checkbox: As soon as user checks, checkbox, the field fills correctly. But this is not the intended behaviour🤔 The options to change field value after save and validation also seems to work (mostly) But this is not the intended behaviour.Any way of enabling this pattern of "fill a field when form is opened (and field is empty)" would be helpful.
Whenever I try to create a form rule based that has a record link numeric field as a condition, quickbase crashes withUnexpected error. Something went wrong!One note: This currently is the only field I have for this relationship in my table. I don't have any lookups.I have tried to create a new form with just one of the record link fields and it still fails. Any hints for me?
I have a form I use to enter a new project or edit an existing one. In the middle of it (see attachment) is something called "Task Details," which appears as a clunky table and is absolutely useless for me. Can I move it or get rid of it? Thanks!
Welcome Quickbasers to the Atlanta Qrew community space! This is a community board where we can collaborate and communicate as a group to share ideas, ask questions and plan our next meetups. Our kick off event at Top Golf on September 25th was amazing and so much fun! Thanks to everyone who came and made it such a success! A big shout out to Harrison Hersch, Senior Product Manager, for flying in to show off some REALLY cool new stuff that is in the works. And thanks for Jose Rivera, our Qrew leader for all his help leading the charge for this group! We're excited to keep the momentum going and getting together again virtually on October 23rd! I hope you all can make it! You can register here! Our agenda will cover our next in-person meetup in Q4 and we need your help to make it happen, so bring your ideas! Looking forward to chatting again soon! Skye, Qrew Coach
I am trying to write a formula that will subtract to date fields only when certain conditions are met. The fields for the conditions are checkbox fields. The formula field I started below is numeric. This formula works without the conditions of the checkbox fields. If([RX Ready Date]<[Plan Set -Up All],0,(not IsNull([RX Ready Date])),ToDays(([RX Ready Date]-[Plan Set -Up All])))I want to add to the formula to only subtract the dates when [Pharmacy], true and [Fast Track] is false (both checkbox fields). Any help to add in the conditions is much appreciated.
Hi,I have a Summary field set up as a Combined Text Comment (Rich Text) field. The output is currently wrapped in tags.Does anyone know how I can remove those tags?Example: <p>Market is currently not working</p> <p>tets1&nbsp;</p>
My query is not returning any value for records that meet the conditions.ToNumber(ToText(GetFieldValues(GetRecords("{86.EX.'"&true&"'}" & "{15.EX.'"&[mhe_type]&"'}", [_DBID_BTS_METRICS]), 10)))I need to return the field value (fid 10) from the table [_DBID_BTS_METRICS] when field ID 86 in the queried table is true (checkbox is checked) and the value in field ID 15 is equal to the value in the field [mhe_type] in the querying table.I have tried:punctuation, format, etc numerous timesusing a text field to give the checkbox a yes/no value and using that field (fid 89) in the conditions in case it is the checkbox giving me the problemchanging it to a SumValues query, but then it returned a value of 0.
At the top of the app there is a button that says "Add new record in any table". When a user clicks this button a drop down of every table is shown to them, even tables I have hidden from their role. Is there a way to remove this button completely or at least hide the tables I don't want them seeing?
Is it possible to put Map Reports on Dashboards? I created a map report, but when I go to create a dashboard, I can't find the map report. Are we not able to add map reports to dashboards?------------------------------Amber Gartner------------------------------
Is there a way to color code the pins in a map report?------------------------------Annalise Sansouci------------------------------
Can I import a map of addresses sort of like a route and as I go into accounts that are already loaded could it show me where that account lands in relation to the mapped out addresses?------------------------------Keith Maxwell------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.