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 start date field in my Position table. I need to create a reminder that sends an email to the email address in the Supervisor Email Address field 30 days before the start date in the current year to remind them to complete and submit an annual evaluation. I can't figure out how to write a formula to calculate the number of days from the start date, but in the current year. Also, I'm finding that the reminders won't allow me to pull in the Supervisor Email Address -- while a notification will only fire if the position is added or modified, which wouldn't be the case in this situation. Suggestions on how I might accomplish this? Do I need to parse the date into separate fields like month and day and then try to create the same month and day but with the current year? If so, how do I do that?Thanks in advance for any help/advice!------------------------------Andrea Johannes------------------------------
I need to use Pipelines to make an API call into Microsoft Azure and then map some fields back into Quickbase.Does anyone know how to do this? I don't really know where to start. I suspect it is not something simple enough to learn through the community, but am able to pay for some consulting hours. Thanks.------------------------------Mike Tamoush------------------------------
I have a Pipeline that currently works great, but it duplicates the record anytime a change is made. Here's what I have:TriggerRecord Updated: [Contract Ending] which is a formula field:If([Contract Extension Date text]<>"", [Contract Extension Date], [Contract End Date])Create an Event: (to the selected Google calendar with the fields filled in)All the [Contract Ending] records are on the calendar now, but it's duplicating the event any time I make a change to ANY of the contract dates since it's a formula. So then I tried Search Events and then Update Event. Then I tried doing a query expression but I'm not sure how to format it. Maybe it needs to trigger from the other date fields?Basically, I need an event created to a Google calendar, with the [Contract Ending] date, which is either the [Contract End Date] or [Contract Extension Date], depending. Then, IF there is a change (most likely only in the extension field), I want it to update on the
Hi,I need help with a formula that would create a new record in the same table when a specific field is not blank.Thank you------------------------------Fatima Khan------------------------------
Hi folks,I am working on a HTML page which uses API_GeneResultsTable api to put a table. The header of the data has a formatting , something like this and I want to change that. I have tried playing with css but it doesn't help. Does someone know how we can do this? The issue is that when i print this page to a PDF file the headings becomes grayed out and user can't read itScreenshot showing the problematic area enclosed.thanks a lot------------------------------DineshRampalDINESH.RAMPAL@APOLLOTYRES.COM------------------------------
So I work for a real estate company and there are multiple agents listed on a transaction record. Each agent can't see the other's information which is listed in the transaction. I want to be able to hide fields if the user is in the role "agent 1" or hide different fields if the user is in the role "agent 2"The solution is NOT to have a different record per agent per transaction, it won't work for a bunch of reasons I won't bore you with.Thank you!!------------------------------Karah Weber------------------------------
App A has a join table field for projects and organizations to allow multiple organizations to be added in an embedded form within App A. In each each join table in each AppProject Field: Relates back to the "projects" table in the respective appOrganization Field: App A (source of truth), App B - uses a connected table from App AWould like App B to use populate the field correctly when its information is imported to App A in a daily automation. Projects from App B are imported over to App A daily - should I create a relationship in App B to the the project table in App A or use the one in App B. The related project needs to match up in both Apps to make the import process work?------------------------------Lashell Thomas------------------------------
I am looking to combine two buttons I've found solutions to via this community (thank you!!), but I am unsure how/if it's possible. Button 1: "Save & Keep Working" Rich Text Field "<div class='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>Generate Document</div>" Button 2: "Change a checkbox" URL Formula Field var text Token ="TOKEN"; var bool NewValue = not [checkboxfield]; var text URL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken="& $Token &"&rid="& [Record ID# #] & "&_fid_checkboxfield=" & URLEncode($NewValue) & "&disprec=1"; "javascript:" & "$.get('" & $URL & "',function(){" & "location.reload(true);" & "});" & "void(0);" Objective: Clicking a single button that saves any changes to a record first, then changes a checkbox on the same record that triggers a pipeline, automation and/or webhook to run. So from a flow standpoint, I want a user to b
I want to create a button, that when checked it opens a specific field from a different table. Once the selection in that field is made it will then send a webhook to Zapier to trigger an email So A button is added to my order. If the button is selected I want it to prompt the user to select a value from the template ID field ( This is a multi-choice field and goes from 1- 6). The template ID field sits in a different App ( No objections to it sitting in the same App) . Can anyone tell me the best way to add this?------------------------------Kelly Grewar------------------------------
So I'm not sure this is possible without some major reworking. I have a formula URL that passes some info to create a new parent record. What I need is to pull on of the parent record fields and return it once the parent is saved. The parent record contains projects and information on them and the child record is quotes. So when a quote is awarded we want to make the project record. From the Project Record I'm looking to return the Project Number to the Quote so I can link them. I've attached the code I have so far. URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=API_GenAddRecordForm&_fid_317=" & URLEncode ([Record ID#]) //transfer Division information to new project & "&_fid_6=" & [Division] //transfer Quote Name to new project as Project Name & "&_fid_75=" & [Quote Name] //transfer Customer information to new project & "&_fid_49=" & [Related Customer] //transfer Contact information to new project & "&_fid_25=" &
I have formulas set to calculate cash flows based on annual benefits and costs, but I have never created a script in QuickBase and I'm struggling to find a good resource. The cash flow fields are independent formula fields for years 0 -5.Any links or videos on scripting would be helpful, especially those that incorporate finance functions like NPV and IRR.
Is URLEncode() not functional inside of a Formula Query? When I attempt to use it, I receive this error message. Here is my formula: Size(GetRecords("{52.EX." & URLEncode([Job]) & "}AND{276.XEX.2}AND{276.XEX.3}AND{276.XEX.5}AND{55.EX.''}", [_DBID_FABRICATIONS]))// fid: 52 [Job]// Issued For Fabrication Status// fid: 276 [Related IFF Status] is not equal to:// 2 - On Hold// 3 - Cancelled// 5 - Prerelease// fid: 55 [Scope Item Name] is equal to nullTrying to avoid creating a table to table relationship to get this value. I'm getting this same error on another formula query to a different table where I am also using URLEncode(). ------------------------------Jon FroderbergPRIME DeveloperHarder Mechanical Contractorshttps://www.harder.comPortland, OR801.946.0576------------------------------
I have created a Staked Bar Chart with Users as X Axis & # of Tasks grouped by Status as Y Axis. For larger values, the numbers are visible, for smaller values it is not. How to enable smaller values.
I have a table with a record for each Cohort. Within a Cohort Record are fields for identifying the Director, Manager, Analyst assigned to that Cohort.For example: Cohort A; Director=Tom, Manager=Jane, Analyst=MaryCohort B; Director=Angela, Manager=Glen, Analyst=StefI have a second table with tasks by position.For example:Task 1; create kickoff presentation; DirectorTask 2; Schedule presentation; ManagerTask 3; Present; AnalystIn the second Table, when I select the Cohort for a task, I want to pull in the appropriate person based on the Position that owns the task.For example:I assign Cohort A on Task 1. Since the Position is Director I want to pull in Tom.I assign Cohort B on Task 2. Since the Position is Manager I want to Pull in Glen.I have created a table to table relationship that allows me to Choose the Cohort for the task in Table 2 from Table 1. But I can't figure out how to make the person field populate based on the combination of Cohort and Position.I
Hello,Does anybody know if there's a way to use a URL formula as a button to open/link a G Drive on PC?Or any another way to use a button to open/link a G Drive?Thanks,Derek------------------------------Derek Pipal------------------------------
Hi, We have a Notification, custom html using %recdata% with a short form that only has a report link field. The Notification report looks great! But the email includes the App Name: table name (record name) giant header right above the report and we don't want that to be there. How to exclude the Big table header right above the report? I unchecked everything in the form properties but to no avail. Didn't find anything in the previous posts. Thanks in advance, Jim ------------------------------Jim Harrison------------------------------
I'm trying to use an IF statement in a Formula Rich Text formula field in a report. I want a yellow triangle to populate of a certain date is or before today. Here is my formula, which seems fine until I save the report, and then I get the attached warning.If([Collections_Lien Review Date]<=Today(),"<img src='https:\\images.quickbase.com/si/16/241-triang_yellow.png'>","")This is the warning I get, and I'm not sure why it refers to CASE when I'm using IF.Formula error -- Bad or missing arguments in function call The types of the arguments or the number of arguments supplied do not meet the requirements of the function Case.The function is defined to be Case ( x, val1, result1, ..., else-result). You may need to do one of the following to fix the problem: Choose the right number and type of arguments. Use a type conversion function to convert the arguments you are using to the correct type. Choose a different function. -----------
Good evening Colleague,I am trying to make the amount of an excel file to a table in quickbase with 90000 records, but I get an error. Have you ever had something similar happen or is it because of the number of records?I would appreciate your guidance on this matter.------------------------------Jaime Fonseca------------------------------
I have an app to schedule vacation requests. The user logging in should only be able to see vacation requests of his own or his subordinates ( so He can approve requests)How can I restrict the view in this fashion.Ex. I don't have any subordinates that I would need to approve vacation requests; I don't need to see any requests but my own. My supervisor should be able to see his as well as mine and any other subordinates he has but he doesn't need to see anyone else'sI have a table for employees that has a many to many to identify the supervisor of the employee. I have another table for vacation requests. Lastly, I have a report that views as a calendar for vacation scheduling conflicts; again. The supervisor will have a custom view of his subordinates.------------------------------Rhonda Parriet------------------------------
Becoming Builder certified and a successful application builder comes with different lessons learned along the way. I’ve discussed several key topics that will help you in achieving the goal of becoming Quickbase Builder Certified. These topics are: App planning Relationships Complex relationships User and permissions The last critical piece into becoming builder certified is managing your application. How to manage your application(s) You’ve just created this awesome application and it is ready to go live. Your job is done, right? Wrong! Now is the time to manage your application and continually set it up for success. My “aha” moment struck me in a sense of comparing app management to coaching a soccer team. I won’t win a championship by simply gathering players and making a team. I need to game plan to put these players in positions that showcase their strengths, work on team/individual weaknesses, and adapt to changes in order to w
Per current report functionality/permission setup, only the user who has submitted the form is able to edit the form. In that user's absence no one is able to edit the form. So need some ideas, solution how can we create/update permissions, rules so that if user who has submitted the form can assign some other as delegate and allow to edit all required fields and submit form successfully. Please advise. Thank you!------------------------------Mrunali Kadam------------------------------
I have a parent and child relationship. Projects have many Monthly Summaries. On that monthly summary I have about 30 pertinent fields shown in a nice pretty grid on the form.On my project, I want to show the most recent monthly summary. I can think of 2 ways:1. Make a ton (about 30) summary fields filtering for the most recent summary. Then simply display them on my project.2. Make a button to pop up and show the most recent summary. I can make a specific form to show only the fields I want.My question is - can I somehow use a report link or other trick to show a specific form of a specific record, right on my parent? So if I want to display it right on my project I dont need to make 30 summary fields?------------------------------Mike Tamoush------------------------------
Does anyone know if a Summary field (say a total of numbers) or a formula query which gathers the same info, is more resource heavy?I'm wondering if there is a rule of thumb, like - for a basic summary field on a parent, use summaries. If the summary field will be pulled to a grandparent or great grandparent, use a formula query.------------------------------Mike Tamoush------------------------------
A client of ours is requesting a button to send bulk emails linked to a specific Sendgrid template. So essentially they want to open an order/report and have a button on said order that will allow them to select a template out of Sendgrid and email it to the customer. Has anyone had this issue and is it possible? P.s. I have set up a Zapier call but it only has 1 trigger and the customer wants to do it on the fly, so Zapier is not exactly what they need------------------------------Kelly Grewar------------------------------
Hi, I'm looking for some help with a pipeline. I've created step A which sends an api call for a MLS property search. This first step I used the Make a Request function under webhooks. It gets an access token and runs a property search, which comes back with the following results at the end of this post. The only data I need from the results is the corelogicPropertyId, which I need for step B in order to get the property data back using this ID. The URL I need to make the B call is https://property.corelogicapi.com/v2/properties/<clip>/ownership<clip> is where I need to insert the corelogicProperyId into the URL for step B. How do I pull this # to step B? I'm kind of stuck at this point, any help would be very appreciated. Thanks!Step A results:{ "pageNumber": 1, "pageSize": 1, "totalRecords": 1, "totalPages": 1, "data": [ { "corelogicPropertyId": "48243:74130542", "compositePropertyId": "48243:74130542", "fipsCode": "
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.