Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a basic understanding of how to create, link, limit data on an exact form. I understand how to show specific child records and know how to format the query to show, sort and/or group records.What I am interested in determining is how do I bring over color coding from a child report? I have a table of data and on a report have color coded the rows of data depending on a specific value in that row. When viewing in either a QB form or report you see the coloring, however, when I reference that table in the exact form it is not displaying the information with the related color coding.Is it not possible to have an exact form display the same color coding settings from a specific form or report?Thanks------------------------------Ember------------------------------
Hi all,I am trying to pass the current user to a code page but can't see anyway to do so. I am familiar with passing field values of the current record etc to a code page but am not sure about passing the current user. Does anyone have any experience doing so or know if it's possible?I am specifically looking into nesting a Codepage into a homepage and passing the current user.------------------------------Anthony Cole------------------------------
On requesting a full Application Overwrite restore, I have read it will not restore Automations. What exactly happens, are the ones that exist in the current app before the restore still remain after the restore or are they deleted completely after the restore?On the same note, how about Pipelines? The ones that are there, are left there or are they deleted after the restore?------------------------------Rick Miller, Trinity------------------------------
Hello. I don't know if this is possible but I have tried several formulas to no avail. I am trying to assign a color to show if a field has a blank date in a report. like this:------------------------------Jessica Stevens------------------------------
This was working fine last time it ran. Not working now------------------------------BuildPro------------------------------
I was under the impression that if we missed a session live, we could go back and watch it. This does not seem to be the case, as the two I was most interested in (New Forms, and API's/3rd Party Integrations) are not available.Does anyone know if they will be available in time? Or was this the plan all along, to only allow certain sessions to be viewed as a recording?------------------------------Mike Tamoush------------------------------
I'd like to have a field that calculates an index representing a chronological order, relative to all the other records in the field, based on a user-entered date field. Is that possible? e.g. I have 5 records and each one has a user entered date that may be different than the record creation date. I'd like a formula field that indicates the chronological order of those records based on the user entered date field. Thanks!------------------------------Peter Schultz------------------------------
TABLE 1 :_DBID_COPY_OF_NEW_BUDGETSTABLE 2:_DBID_HOUSESTABLE 1 FIELD :[GM %.TOTAL JOB] - FIELD ID: 426TABLE 2 FIELD:[GM %.TOTAL JOB] - FIELD ID: 3645I would like for this to automatically happen: DESIRED RESULT= FIELD 3645 = FIELD 426The tables are related and I have a report link that shows this info. However, I want the value from FIELD ID 426 to populate TO FIELD ID 3645. I do not want to have to click the ADD COPY OF NEW BUDGETS button because I already have a pipeline set up to CREATE NEW RECORD in COPY OF NEW BUDGETS table that "creates the new budget...triggered by a field in the HOUSES table; the value in FIELD 426 populates at the time the record is created in COPY OF NEW BUDGETS table.I did find this formula, but it does not work:[ADD MARGINS]formula field :ToText(GetFieldValues(GetRecords("{426.EX.'" & [GM %.TOTAL JOB] & "'}", [_DBID_COPY_OF_NEW_BUDGETS]),426))thank you ------------------------------BuildPro---------------------------
I would like to be able edit a date field in a parent table ( Patient table) from several different child tables as well as enter account notes from my child tables (tables names are estimate and invoice) in my App. I know I cannot edit a look up field so I am trying to figure out how to add various fields from my parent tables (Patients table) to my forms/table in the above child tables. I have the table relationships built, and have tried many ways, but just cannot figure this out. Currently, I have to leave the child table to go to the parent table and/or another child table to edit various fields. Any ideas I can try out?Thanks------------------------------Kelly Lyons------------------------------
Why isn't this working? thxIF([All Tasks]="04.Hang"=true,true,[All Tasks]="06.Scrap"=true,true,[All Tasks]="08.Finish"=true,true,[All Tasks]="09.Finish.Gar Tape"=true,true,[All Tasks]="10.Sand"=true,true,[All Tasks]="12.PT/UP"=true,true,[All Tasks]="17.Coffered Hang"=true,true,[All Tasks]="18.Coffered Finish"=true,true,[All Tasks]="19.Coffered Sand"=true,true,false)------------------------------BuildPro------------------------------
There are probably easier ways to do this, but I am looking for a way to create a child record on a parent, pass some values to the child and have users add data into two fields using a code page. For ease of use, we do not want Users to interact with the child records, other than the fields they are entering data into when the record is created (why we're using a code page).Currently, I am able to create a code page that will Add a record to a table with as many field updates as I want, but I am unable to relate this record to a parent.Additionally, I am able to create a child record, pass certain values to the child and redirect the user to a code page for data entry into one field. That Button lives on the parent record, and the code page opens a field for users to enter a value for a field (see line 9 of the screenshot below, that is the field where the data entry is dropped into):borrowed code page from the Magic Buttons applicationNow if only I could do the combination of t
I need to clear the value of a multi-select text field as the last step in a pipeline. But the only options available are the ones in field properties. Is there an equivalent for the {{CLEAR}} that is used to clear out a date field that will work for multi-select text fields?------------------------------Paul Peterson------------------------------
Forcing a change to the new style of reports is not going to make anyone happy. Can't you just remove it? We like it the way it is!------------------------------Renee Wankel------------------------------
Is there a way to trigger an auto-save event after a certain field on a form is filled and then have the same record stay open for continued edit.Kind of like how the autosave occurs for the parent when entering a child record.------------------------------Steven Nelson------------------------------
Has anyone used the Is During Operator? If I want to say 'Is During Current Year' how to do specify current year? (Or current month, etc).Right now, I have to go the long way and say is OnOrAfter firstdayofyear, and OnOrBefore last day of year. But I'd love to learn the shortcut if there is one!@Quick Base Junkie ??------------------------------Mike Tamoush------------------------------
I have a table of Weekly Work Plans where each Plan can have many Planned Activities. Also shown on the form is an embedded report of Primavera P6 Schedule IDs filtered for tasks that are due to start in the next three calendar weeks. Currently users must take note of the Sched. ID they need, click the [ + Planned Act. ] button to add a Planned Activity, then find the Sched. ID in a dropdown list and save the record. That's a lot of extra steps.I want the user to be able to review the list of Schedule IDs and click a button on the one they want to create a Planned Activity for, and subsequently have the record generate and the Sched. ID to be populated on it.The challenge is this, the button would be located on the Sched. ID record in the embedded report, and would not know record ID of the Weekly Plan needed for the API_GenAddRecordForm function. The Record ID is available in the URL of the form, but I don't know how to grab it for the button without using JS.---
I am trying to create a field where the words are colorized based on day of week.FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]FIELD TYPE: RICH TEXT FORMULAThen, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.------------------------------BuildPro------------------------------
Parent table: ComputersI want a field in this table to reflect the most recent "status" that was entered for each child record in a Statuses table.I'm sorry -- I'm sure this has been answered somewhere, but I've tried about five different searches to see where the answer for this question would be.Thank you!
Hey,When I open a form the time entered field shows the current time instead of the time it was created. How do I show the time the form was made on a field. It currently can only be seen at the very bottom of the form like this.I wish for this date and time to be available on the field rather than something on the bottom of the form.Thank You------------------------------Wadood Syed------------------------------
I can't log into Empower which starts in 5 minutes. I have registered and used all lower case letters of the email I have registered. When I try to register again it says I'm already registered. ------------------------------Bob T.------------------------------
I am not sure if you have tried to filter a report to show a specific set of records that may not have a common relationship other than having a value in the same column. In my company, we frequently need to edit a set of specific records. This is core functionality in the system that is being replaced by Quickbase, but I haven't been able to find a good way to do in in Quickbase, until now. Here's the use case: I need to filter a report to display a specific step of projects, but there isn't a clear way to filter and only see the orders needed.The approach I used starts with an Excel worksheet to quickly format the data. The raw data is pasted into column A and this formula is in column B, =IF(ISBLANK(A2), "", CONCAT(CHAR(34),A2,CHAR(34),IF(ISBLANK(A3), ");", ", ")))The output from column B will be pasted into the Report Formula.Then I edit the report where I want the data to appear and create a formula checkbox report formula. I start off by typing
Good morning,I'm trying to create a line chart that shows a running total of the number of installs completed each week. I'm able to show the number completed each week, but I also need to show the running total.e.g. Week 1 completed 5, running total=5Week2 completed 5, running total=10Is this something I can do with a report formula?TIAKim------------------------------Kim------------------------------
I have a table that pulls in information from multiple other tables. For this exercise, say one table is Projects Table, and the other is an Events Table.Each project has a single manager.Events do not have managers.I have a report that shows a mix of events and projects. I want to be able to have a dynamic filter on the report that allows me to filter by manager, with the catch that I ALWAYS want ALL Events still showing. Essentially, the projects filter but the events don't.The only way I can think to do this is with a report filter where one set of the 'Or' opertor is 'Ask the User'.Any creative way to do this with a dynamic formula? I am trying to think of a create formula I can make that will trick QB into doing this, but so far am coming up blank.------------------------------Mike Tamoush------------------------------
Hi All,Please can you confirm if after changing the Record ID (which is also a key field) name for a different name there will be no impact on the formulas and relationship?Thank you.------------------------------Iryna Pylypenko------------------------------
Hello, I have a table with the following fields: Program Name (Type: Text) Health Date (Type: Date) Health Color (Type: Text) I would like to add a field that would automatically return the health color from the previous month. The desired end result would look something like:I'm guessing this would be a query formula but so far I haven't had any luck. Any help is much appreciated! Thank you.------------------------------Addie Brunson------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.