Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Table-Material OrdersFYI-The same [JOB NUMBER] is indicated on each of the records listed belowRecord 1: [PAINT CHANGES] (text field) is entered on this record; [ORDER TYPE] (multiple choice field) is "Prime". Record 2: [ORDER TYPE] is "DW" - Need information from Record 1 [PAINT CHANGES] to show on this record------------------------------BuildPro------------------------------
Hello,I have 2 fields, field 1 is a number field and field 2 is a date field from a relationship. I would like a formula that says if field 1 =1 and it's 30 days before the date in field 2 then say complete.but if field 1 =1 and it's 90 days before the date in field 2 then say schedule.How would I write that in a formula? ------------------------------
Has anyone came up with a solution to track emails, similar to dynamics 365. Tracking without regards seems capable, as it based on a contact. Set with regards has to have the option to update different records: Accounts, leads or locations.------------------------------Willis Taylor------------------------------
Is there a way to edit the way apps appear in their mobile form? A lot of the uses of one of my apps is on iPad and I can't figure out how to edit the layout.------------------------------Ethan Kaste------------------------------
Good morning,I have a formula rich text field to display a date with large green characters. I have TR1 Site Survey Date set to show the day of the week and the month as a name, but it is still just showing as a date.I've tried adding ToText(...) but it doesn't make a difference.I tried it here:"<b><span style='color: green; font-size:200%'>" & ToText() & "</span>"... and here:ToText("<b><span style='color: green; font-size:200%'>" & & "</span>")Once I have that figured out, I also need to find a way to convert the day and month to French. I'm sure I can figure that out, but if someone has a formula already, that would be most helpful!Thanks in advance,Kim------------------------------Kim------------------------------
So I've hunted around and haven't been able to find an answer to this so far. I'd like to make a comparison so we can see how we're doing compared to last year. So I'd like to have a report where I can say, "January 2019 estimates vs. January 2018" and maybe see a dollar amount or % of change. I can't seem to crack this nut myself...
I've taken the example here: https://resources.quickbase.com/db/bq8meiyhh?a=dr&key=4and I have it working perfectly in my app, however I'm having a tough time modifying the code to edit more than 1 field. Can anyone show me how you would modify this code to collect input and write the value for 2 or more fields? I cannot figure out what I'm missing to do that.------------------------------Jeff Peterson------------------------------
How do I add color to this field[WALL PAINT] (If 1 color is true, blue. If 2 Color is true, green)If([1 Color]=true,List("_", [Wall Color],[Related Projects - Wall Paint]),[2 Color]=true,List("_", [Wall Color],[Related Projects - Walls-2 Color Paint]),"")------------------------------BuildPro------------------------------
We have created a feature to enable Executives from several different organizations to vote on key features they want in our RoadMap. For each org only the named executive, a named proxy or the portfolio administrator should be able to cast the vote. We have set up Custom User Sets for each organization. How can we limit that the voting field (and associated comments) can only be updated by one of the individuals in the custom user set?------------------------------Annetta Coleman------------------------------
We are ready to implement SAFe Kanban Lanes for a large enterprise QB App. The SAFe Lanes are Intact, Reviewing, Analyzing, Backlog, Implementing MVP, Implementing Full, Done (realize value proposition). For Each Lane we will have colorized Lane Status of Not Started, Work in Progress and Completed. For very large projects that require leadership funding approval we will have various stage gates & decisions that will move work to the next Lane. For these projects, the decision action will update the completion of the current lane and approval for the next lane. For smaller projects we want to be be more nimble and allow Product Teams to drag work from one Lane to place in the next Lane. Naturally we want to control that they are not being overzealous and dragging work to an inappropriate lane nor trying to drag work that is not done in current lane. As the work is dropped into the next Lane, we want to reset the Lane Status to Not Started
I would like to trigger a pipeline when a checkbox is ticked. This is how I did it:I'm not sure why it's not working. Thanks!Consuelo------------------------------Consuelo Viramonte------------------------------
Hello,I need help with quickbase calendar report. I currently have a field called start date which has list of companies. I have a another field called frequency which is multiple choice field consisting of daily weekly semi-monthly and monthly. I want to have calendar show the records which falls in the freqency range from start date. Can it be achieved in quickbase?------------------------------XYZXYZ------------------------------
When I create a notification, with a condition 'When any of the following fields change', this seems to work exactly as expected when the notification fires 'When the record is modified'.However, if done when 'The record is added', it does not fire. I am thinking that when a record is added, QB doesnt see any of the fields as 'changed'? I figured if it wasn't blank, QB would see the field as being changed, but this doesnt seem to be the case.Can anyone confirm, or have better knowledge on the quirks of firing notifications when 'the record is added'? Update: Looks like there may have just been some server issues with QB. 15 minutes later, I got the notification as expected.------------------------------Mike Tamoush------------------------------
I recently built a custom data rule so that a required date field cannot be in the past. I have a webhook that is giving me an error code due to this. When it goes to my other table to edit the record, if the rule is triggered then it send me the error message. Can I add a parameter to ignore this data rule? Or ignore the field? Or automatically change the date in the required field so that the webhook can work?Here is my current API:<qdbapi><udata>mydata</udata> <usertoken>%user.token.b5zzdf_pj8a_dvzv.Webhook%</usertoken> <apptoken>qy4ffub8ki83ibyqqu8ycwdvtyf</apptoken> <rid>[Related Estimate]</rid> <field fid="200">Invoiced / Completed</field></qdbapi> ------------------------------Kelly Lyons------------------------------
Hi, I wanted to know if there is a formula that will allow me to color code every entry in an entire field a specific color. For example, I would like every entry under "What's something you find challenging about your role??" to be blue and every entry under "How can we fix this moving forward??" to be red.------------------------------Kelsey Roach------------------------------
I run a clean & sober housing program where we have 28 houses with over 250 people living in our houses. Our parent table is Houses, the child table is "Beds". We have a summary field called "arrivals" that tracks the "Minimum bed start date" of people coming into our houses and another summary field called "departures" that tracks the "Maximum bed end date". The problem is we also have people that move from house to house sometimes and even within a house from bed to bed. I'm trying to find the number of actual arrivals and departures in our program by house, not the actual program. A person can move from house A to house B and not leave the program. A person can also move from bed 1 to bed 2 within the same house but that person may not have arrived in our program in that house at all. The person may have arrived in our program 1 or 2 houses ago, moved around within different beds in that house, left that house and moved to the new house, moved around that house x # of times and
Hello - I have integrated my quickbase to quickbooks online and it seems to be working well. However, I have two issues I am trying to solve.1. Rate field - I can't seem to figure out which field within the pipeline ties back to the rate field for invoicesin quickbooks. Has anyone figured this out?2. Description - my description uses several fields from quickbooks. However, quickbooks does recognize HTML, so it's adding code to my invoice rather than the formatted description. Any insisted is appreciated. ------------------------------Charlie Kassaseya------------------------------
Please HELP!! I've been trying to figure this out for days!I'm trying to create a formula that will display quarter names (Quarter 1, Quarter 2, Quarter 3, Quarter 4) based on two fields [Meeting Type] and [Meeting Date]. I want the formula to show what quarter it is based only on the Month part of each date. I don't even know if I'll need to use [Meeting Type].I tried using the If formula with Contains, but no luck.Here's what I need: If [Meeting Date] Contains 12= Quarter 1If [Meeting date] Contains 03= Quarter 2If [Meeting Date] Contains 06= Quarter 3If [Meeting Date] Contains 09= Quarter 4Which brings me to my next question. Some meetings were held in a different month than the last month in the quarter- I guess it would just be:If [Meeting date] Contains 03, 02= Quarter 2
Im having trouble getting the API to post the value of the field instead of the literal text name of the field. What am I doing wrong? Obviously I am new to this. It creates the new record in the intended table but the data doesnt come, just the literal text. Here is my URL formula:"https://garychristopher.quickbase.com/db/bs7bhsvxt?a=API_AddRecord&apptoken=dezw24pd9yryghbkmmmfcb75e6zv&_fid_9=$[Sage - Date]&_fid_7=$[Sage - Revenue Credit]&_fid_6=$[Sage - Purchase Debit]&_fid_15=$[Sage - Project Number]&_fid_13=$[Sage - Vendor]&_fid_14=$[Sage - Vendor Invoice Number]&_fid_10=$[Sage - PO Number]"------------------------------Gary Christopher------------------------------
Conditional Drop Down based on a formula
How can I add a button within my Quickbase form that enables users to add additional dropdown fields with associated comment text fields as needed?------------------------------manohar vankireddy------------------------------
How can I update the "status" field in the parent table when there are multiple records with different statuses in the child table, such as "Started," "Inprogress," and "Hold"? I want to update the status in the parent table to "Hold" if there is at least one "Hold" record in the child table; otherwise, update the status to "Inprogress."------------------------------manohar vankireddy------------------------------
Hello, I have embedded several pie charts in a form. The charts are rendered quite large (600px X 450px) and I would like to resize them to be smaller. Is this possible in Quickbase? If so, how? Thanks.------------------------------Uri Goldstein------------------------------
Hi friends! I know that we're unable to add a grid edit report to the new dashboard. However, from the table report added on the new dashboard, when my users select to 'Open Report' any of the filters they selected from the dashboard are removed.We have similar dynamic filters added once the report is opened, but their goal is to use grid edit mode based on the filters they selected from the dashboard. Any thoughts or insight on how I can ensure the filters stay with the table report once it's opened outside of the dashboard?I really appreciate any help you can provide.------------------------------Jessica Adkins------------------------------
Hi , The requirement we have here is Serial number field is Numeric data type. We have to adjust the serial number column in the grid edit while inserting any rows in between the existing rows. I have tried multiple ways but that is not working as we expected. Example: Suppose If we have 10 rows with serial number 1,2,3 ---10. And user insert the two rows in between 2 and 3 , then the expected result is 1,2,3,---12. But we are getting result is 1,2,3,4,3,4,5,6,7,8,9,10. Kindly suggest us if we have any solution. Thanks & Regards, Madhavi. ------------------------------Madhavi Kanugondloola------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.