Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello:I have a contract application.Goal: When the Contract Expiration Date field is on or before today, and the Exception to the Expiration Date Dynamic Form Rule field is unchecked, I want the Contract Status field to automatically change to Expired.Question: What is the best method to accomplish the above goal, form rule, text formula, or pipeline?1. I tried the below form rule. However, it works intermittently. I still see expired contracts that show as active 2. I created a formula - Text field named Contract Status Formula, but I am unsure whether my formula is correct.If(Today() <= [Contract Expiration Date], "Expired") 3. I tried to create a pipeline. My first attempt was to Search Records/Update Record. My second attempt was to On New Event/Search Records/Update Record. However, I know I am missing a step.Any step-by-step guidance would be greatly appreciated.Thank you,Roula
Hi Mobile Workflow Customer Network Qrew! Our next meeting is on Wednesday May 15th at 12pm EST. Click here to register and login to the meeting Agenda for the meeting: Josh Martin and Todd Webber from Gulf Coast Underground (GCU) will share a FastField Mobile to Quickbase customer use case. Polina Georgieva will do a quick recap of what was announced at Empower 2024 and showcase the new Quickbase Mobile Forms with an opportunity to join the Beta program. I am looking forward to this meeting because this will be our very first mobile customer use case shared with the group, and you'll get to hear GCU's FastField-turned-Quickbase customer journey. A fascinating perspective worth checking out. I'm also looking forward to hearing your feedback and questions for Polina Georgieva and the mobile product team after their product roadmap announcements at Empower. See you on Wednesday May 15th! - Esther
Hello and welcome to the Mobile Qrew page! As Mobile Workflow Customer Network admin, I'll post Mobile Workflow Customer Network meeting recaps, gather feedback, and help answer questions posted on this page. Join the Discussion by: Posting and answer technical and non-technical questions about your mobile use case. There's a huge network of experts you can connect with that offer smart solutions and ideas in a timely manner. Reading up on events and new feature highlights on our blog. Connecting with other Qrew members that engage on Qrew Discussions by clicking on the mailbox icon on the top righthand corner of this page. Reading the customer network meeting recaps. I look forward to seeing this page grow and flourish. - Esther
I am using a Pipeline to create a single record in a table with a Post Method from a Make a Request step. I cannot use a Create Record Step as the number of possible destination tables is too large. After much trial and tribulation that is working now. The next piece of my workflow I need the Record ID from the record just created. The REST API logic says to use a 'fields ToReturn 'Looking at the Activity I can see that the RID is getting back to the Pipeline. However I do not know how to use it inside of the Pipeline in a future Step.Any suggestions from the Python/ JSON and Jinja wizards?
Simplest formula out there. Year([Date]) - It works in the formula checker, but nothing is showing up in my table in the Year field. What could be causing this?
If you are looking to parse a JSON response in a Pipeline and you know where and what value are looking for there is a simple way to get to a specific piece of data. Credit for this goes to Jenny on the QB Support Team for getting me the solution.There are five parts to the Jinja ExpressionThe STEP that the JSON is resident inThe SECTION of the JSON to getWhat part of the ARRAY to getThe FIELD to get The valueHere is the expression{{STEP.json.SECTION[ARRAY]['FIELD'].value}}So here is what my JSON looked like{ 'data': [{'3': {'value': 14}}], 'metadata': {'updatedRecordIds': [], 'createdRecordIds': [14],'unchangedRecordIds': [],'totalNumberOfRecordsProcessed': 1}}{createdRecordIds}}This is a really small array. In the 'data' section is only one piece of data for FID3 and its value is 14. That is what I wanted to get.So my working Jinja Expression is {{b.json.data[0]['3'].value}}The JSON was coming from Step B. data is the section I w
Hi,I have two related tables: Request Table and a Requisition Table. The workflow is to enter the Request information first. Then from the Request table, click on the Add Requisition button to add the Requisition information.This is working as expected. When a Requisition is added from the Request form, the # of Requisition records summary field is updated correctly.What I am needing help with is passing the associated Requisition number into a field in the Requests report. Currently the # of Requisition records summary field shows on the Request report. But the Related Requisition Number or Related Requisition does not show in the report. I have to go to the Requisition Table itself, and then manually link the related Request to the Requisition.I hope this all makes sense. It is difficult to explain. Thank you in advance for your assistance.
I know I can connect QuickBase to an email account and attach incoming emails to certain records, based on rules. But in this case, the incoming emails have an attachment (Docusign contract) and I want to store the attachment as a "document" attached to a particular record within my app. Can this be done in QuickBase?
Hello all! This is my first post in this forum.I am trying to create a formula URL field that displays as a button on a table report that is filtered by a single date.This button when executed should add the record, save it and return to the report with the same filters that the user started on.This is what I have set up:var text urlone = URLRoot() & "db/" & Dbid() & "?a=API_GenAddRecordForm&_fid_6=" & [Related Placement] & "&_fid_12=" & [Week Ending Date] & "&_fid_504=" & [Job Notes] & "&_fid_505=" & [Placement Notes] & "&apptoken=(my app token)"; var text urltwo = URLEncode(URLRoot() & "db/" & Dbid() & "/tablereport?a=q&qid=16&nv=1&v0=" & [Week Ending Date]);$urlone & $urltwoThis will generate the form with the appropriate field populated, but the user must press the save button on the record to return to the filtered report. I have also tried modifying urltwo to var text ur
I'm trying to build a very basic form for external users to enter some data and hitting a roadblock and hoping someone here can point me in the right direction.The people this form is intended for are not employees and don't have any experience with QB so I'm trying to keep it very simple. The plan is for them to access it through a browser on either a computer or their phone. I created a form to be used for these users which works fine on a computer but when using a phone, a few of the elements are missing. Specifically a report link and a button to add new child records. Attached are screenshots showing the same form.Saving the record on the phone returns them to the app homepage but the purpose of this form requires them to add child records, so having them return to the home page adds extra steps/complexity on their part. So, I guess my question is - how can I set this up so the user can create an Order record, then easily add child records on their phone. It functions fine on
I created a form using the new form design option and displayed a report in a section. I selected the option from "Advanced Setting - Show Create Record button".This displays a "New Record button" for me when I tried to open the form. But then its not visible to people with roles other than Admin. How can I make this available to every role.
We need to base our record pickers in our People table on their roles in the Users table. How do we make a field in the People table that shows their role?------------------------------Krissy Mayes------------------------------
I'm using the ToUserList function to create the list (user names) of required approvers for specific records. Ideally I would like the order of those approvers to match the roles listed in an adjacent section of the record. I wrote the function to have approver 1, approver 2, etc. in the preferred order, however it seems that they are only displayed alphabetically on the form. Is there a way to change this default? I've looked and cannot find it.
I don't know how to fix this error. It used to work fine now it does not.I am extracting tracking number from the response however It is giving me an error. I had help setting this up so I'm not too good at fixing the code. But in step I and J I am doing an applied expressions and getting all the info. In step K I am attempting to put that info into my fields in QuickBase.
Hi Everyone, Happy Empower Day!!! This thread will be monitored throughout the day by the members of our Product Management team. If you have a product specific question from content you saw today during Empower, drop the question here and we'll have a member of our team respond!
I am using the new form and trying to hide/show fields like buttons and checkboxes however they are not showing up as options to select when I make the from rule. I click to show fields and then my field is not even an option??? How do I fix this?------------------------------NOEL HODGES------------------------------
Trying to create an API button to open a new record in another table (ideally will love to build this out while passing details on to specified fields. But. I can't even just get it to do a new record). What gives? I've compared this to some of my other similar records, and can't figure out why this won't work.Thanks!
I have two tables one called Provider records and one called descriptions. The Provider is the child and the descriptions is the parent. The descrition table has two fields named Record Type and Record Description. There is one Record Type/Description combination that I don't want to appear in the drop down list on the form but I can't seem to hide it. The user picks the Record Type 1st and in a second field is presented with a list of desriptions that match the chosen record type. In the related description field on the form, I changed it from record picker report to another embeded report and I filtered that embeded report to not include the description that I no long want showing in the drop down but it's still there.What am I doing wrong?
Hi Qrewmates We are looking to get feedback from you all on what you would like to discuss in upcoming collabs. We have plenty of ideas but we want to hear from YOU about what gets you curious or what topics you would like to crowdsource ideas from other Qrewmates. Floor is open so dont be shy to speak your mind!!!------------------------------Nicholas Cantillo------------------------------
Who's excited for Empower tomorrow? Nico and I will be hosting a Empower Happy Hour tomorrow at 4:00pm MT if anyone wants to hop on and chat about empower and share any reactions or what you may be most excited about. Hope to see you there!Follow this ---> link <--- to register and we'll send you an invite to the post-Empower Happy Hour.
I created a check box field and it's currently used in 7 forms/reports. When I copied it to add in another area of the same form it shows as only being used in 2 forms/reports. How can I add it to the additional areas I need it in? I want the copies to function the same as the original. I attached screen shots of the original and the copy. Thank you!!
I'm trying to build a conditional url formula where if a multiple choice field equals a certain person, display this url. Unfortunately, it's not pulling in anything. Here is my current syntax in the formula URL field:If(ToText([Contractor Operations Manager])="Sally Struthers","https://calendly.com/sally.struthers") &If(ToText([Contractor Operations Manager])="Fred Flinstone","https://calendly.com/fred-flinstone")Any thoughts?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.