Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi,I have a table with 2 fields of type Address, let's call them: LocationA and LocationB. Depending on some business logic (basically if LocationB is not set) I'd like to set: LocationB = LocationA.Unfortunately, I noticed that we do not have in Quickbase field type: Formula - Address. I know I can do this via a Pipeline. But I'd like to know if there is a way this can be done via formulas somehow.Any help on this question will be appreciated.Thank you.------------------------------Jorge P------------------------------
Is it possible to hide the save button on mobile? There is an old thread with some iol type advice. Anyone know if this still is a viable option?The reason is - since there is no way on mobile to direct to another URL (ie NextURL), I need to create a custom save button that redirects. I am trying to force my user to use my custom save button.My specific use case is I have a button that takes people to a specific form on a record, in edit mode. When they save, it just automatically lands on the default form in view.------------------------------Mike Tamoush------------------------------
Hello,I often copy my application to run different "tests" on ideas. I need to be assured that the pipelines that are copied DO NOT run the pipelines in the original app.thank you------------------------------BuildPro------------------------------
Hello, I'm working on an application that users must use to review and approve transactions on a weekly basis. All data for each locations weekly approval is captured on an exact form. We want to save all of these exact forms for compliance purposes, but I'm having trouble figuring out how to automate this process without having to go in and manually open up each of the 40+ exact forms and save as a PDF weekly. Thanks in advance for your solutions!------------------------------Kojo Acquaah------------------------------
Assuming I've two fields in my tableson1son2I'm trying to create two records in another table using jinja loop(which is happening) but the dynamic names are not out of my reach"to": "bsp8bd9qp","data": [{% for i in range(2) %}{ "17": { "value" : "{{a.son~loop.index}}" }}{% if loop.last == false %},{% endif %}{% endfor %}]}Below works but predictably gives me value for only son1 and not son2{ "17": { "value" : "{{a.son1~loop.index}}" }}------------------------------Prashant Maheshwari------------------------------
I had like to request for a zoom recording from anyone who's attending the event.There was a small segment scheduled for * Jinja for loop , which I'm interested in seeing------------------------------Prashant Maheshwari------------------------------
Good Morning All, I want to know how it is possible to submit a form to someone via email to where they receive a link that they can access to complete said form that gets captured in quickbase.Everytime i look on the forums, the only things that come up is how to send emails with changes that have been done to a form or another.. not exactly what I am looking for..------------------------------Douglas------------------------------
Hi there,I'm a complete beginner, so please bear with me.I need a field that shows Weekday, Month and day, with seven days in advance, except for Sundays and Saturdays. So if today is Monday, Jan 1st, I need it to show Monday, Jan 8th. If today is Saturday, Jan 6th, I need it to show Monday, Jan 8th.I know I need a date/Formula field, but I'm not sure what to put in the Formula. Thanks in advance!------------------------------Consuelo Viramonte------------------------------
I am trying to Parse a Text string from a connected database to extract Location and Amount data. The string looks like this: 'FREMONT', null, ('157', null, null, null), null, null, null, 5634.88, null, null, null, 18050.0, null, 0.0, 18050.0, 0.0, null, null, null, null, null, null, null, null), (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'HAGERSTOWN', null, ('109', null, null, null), null, null, null, 5011.86, null, null, null, 20934.0, null, 0.0, 20934.0, null, null, null, null, null, null, null, null, null), (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'OPELIKA', null, ('112', null, null, null), null, null, null, 16224.42, null, null, null, 54332.0, null, 0.0, 54332.0, 0.0, null, null, null, null, null, null, null, null), (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, Is there any way of d
I have two tables, Coach (parent) and Meetings (child). The goal is to figure out if the next meeting is scheduled within 7 days of the last meeting the coach scheduled. So I need to somehow find the previous meeting date record for that coach and bring in that previous date to the current record so I can calculate the duration between the two. For instance, on the Meeting table, Coach 1 has a meeting scheduled on June 29 (record for that coach). The meeting date record before that date for that coach is June 22. How can I pull in the meeting date for the previous meeting record on the Meeting table for that coach (June 22) to the record for the June 29 meeting? All records need to have the previous scheduled meeting on them. Is there a way to do this?------------------------------Dawn Rene------------------------------
Hello, I'm trying to show a countdown of business days to an employee's last day and would like to add conditional formatting as follows: If the countdown is less than 0 days, just show 0 If the countdown is 3-0 days, bold in red font and highlight field yellow If the countdown is greater or equal to 4 days, no need to do any conditional formatting Can you please assist me with the formula and what field type it should be? I was trying to do a formula along the lines of: If(ToDays([Last day]-today())<=3," "<font color=red><b><div style=\"background-color:yellow;\"</div>"&([Last day]-today()), ([Last day]-today())") But I know this won't take into account the 3 different formatting and I was getting error messages related to the field type. Thank you!
Hey I'm trying to make a timesheet app, I want my end of work field (which is a time of day field) to instantly add 8 hours when I put my start time into a different time of day field?------------------------------Jonty Foster------------------------------
Hi,I'm working to create a few custom reports and charts for one of our tables. In one of these tables, we basically have a delta field, which we want to highlight red if the change is negative and green if the change is positive. Based on the info from Quickbase in "color-coding in reports", this should be possible. The issue is that I'm not seeing a "color coding" section anywhere in any of the custom reports (besides the main "List All" table). I've also just tried to add a simple color-coding script in any of the "Add a formula" sections (such as for "Report formulas" and "Summary formulas" sections), but I've had no luck. Any advice is appreciated. Thanks!Shelby------------------------------Shelby Pons------------------------------
Hello,I have seperate Date and Time Fields.I am trying to create a Time Stamp field that with using a pipeline to record the tiggered Date and Time can be put into one Date/Time field.Example: trigger happens Date: 9/22/2022 Time: 12:00 pmPipeline records into a Date/Time field as : 9/22/2022 12:00 pmRight now I am getting an error in my pipeline that says the following: Validation error: Invalid date/time value: 2022-09-22 00:00:00+00:0010:15 AM.------------------------------NOEL HODGES------------------------------
I have two fields- estimated completion date and date completed. I am trying to create a formula to populate the number of days to complete the project ONLY if date completed is null. I can create the formula and make it work if I leave out the completed part, put am getting an error when trying to incorporate the completed field.------------------------------Angela Bowman------------------------------
Hi,I need to change a phone number (555) 555-5555 to this format instead 555-555-5555 .It seems quickbase default format is with () and Im not sure how to get rid of them.------------------------------NOEL HODGES------------------------------
Is there a way to resize columns on embedded reports? If you go to the Full Report you can do that, but does not reflect the same when displayed in the parent record. I noted that in the field properties there is a width of input box but I believe this only affects forms. My company was in the first group to get the table reports update and we have had other issues with column widths.------------------------------Julie Meeker------------------------------
Hello all,I'm part of a BI team that is taking over the support of QB at our company. I'm new to app building and want to see if anyone has heard/had the following scenario: We have many apps in QB which users have access. I'm building a new ticketing app for our team to support users who need help with QB or for other tasks that our team handles. For this app, I want users (either registered or non-registered) to be able to fill out the form I created but not have any other access to the app. The only people who will have access is our team (as admins) and very few managers from other teams (these will likely have QB licenses).My thought was that I would build a homepage that has a button to fill out the form (screenshot attached). Not sure if this is the best way to accomplish my task...so would love some input.My second question is about permissions. I read about EOTI but 1- that sounds risky and 2- we don't need it for anyone outside of our organization. I thought maybe the be
Hello,I am building an expense reporting platform that does the following via a button: Employee hits Submit Expense Report Button It updates the status to the next status category (this works) It creates a task in my main ERP app for the next inline to review the expense report (this does not work, it displays the dashboard of this other app) It should navigate back to the current record in the original app (does not work) I can get through #2, and on #3 above it just displays the dashboard of the other app, no new task is created and I dont navigate back to the current app. here is my code thus far:i appreciate in advance the help!//Button Styling:var text decoration = "text-decoration: none;"; var text bgColor = "background: #009bce;"; var text txtColor = "color: white;"; var text txtAlign = "text-align: center;"; var text txtShadow = "text-shadow: none;"; var text border = "border-radius: 5px;"; var text padding = "padding: 8px 20px;"; var text display = "display: inline-bl
Hi all, I am now setting up a notification with condition of "any field changes", with showing the copy of the record changed (%recData%). However, is it any alternative to show the changed field information in multiple record version? As I found "%recData%" is not applicable in multiple record version. Thanks so much.------------------------------Alex Wong------------------------------
Is it possible to not show Saturday and Sunday in a Calendar Report? If so, how?------------------------------Ricky------------------------------
Is it possible to use WeekDaySub when one of the date fields is "today()"?
Found the answer.
Start with your Rich Text Field. I'll call it "RTF". Then create a second field with a field type of formula-rich text. Use the following formula to replace breaks with nothing:SearchAndReplace([RTF], "\n", "")------------------------------Jeff Reda------------------------------
Hello,I'm once again reaching out to the amazing community of folks way smarter than me for some assistance creating a formula that is absolutely stumping me but probably child's play for the community wizards!I've built an App for managing our fleet of vehicles - inclusive of Inspection Date tracking.For the inspection date tracking, our trailers must be inspected twice each year and said inspections must be performed within specific date "windows". One inspection must occur each year between March 1 and April 30 and then performed again between August 1 and September 30. I need to create a formula that projects the next inspection date for a trailer by referencing the last inspection date. Let's call the two fields "Last Inspection" and "Next Inspection". Given that an inspection can occur on any date within the allowed "window" (March 1 and April 30 and then again between August 1 and September 30), I cannot simply add a fixed addition of days to the "Last Inspection" to populate th
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.