JustinParker
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Create a formula date field to show the last time a meeting took place
As part of my business, my managers are required to have monthly meetings and record the meeting notes into QuickBase. Each meeting is saved as its own record. I would like to be able to build a formula date field that outputs the date of when the MOST RECENT Contract meeting took place so I can be alerted if a meeting is missed. I have a text field [Contract] and a date field [Date of Meeting] Any help would be greatly appreciatedCreate a Formula Text Field that converts job titles to competencies
I have an existing text field [Current Job Title] that has over 50 different types of Job Titles. To better bucket employees I would like to create a Text Formula Field [Competency] that based on the job title selected, the Competency would automatically be selected for that employee. For example: If an employee has one of these job titles I would like the [Competency] field to automatically say "Configuration Management" CM Specialist (Junior) CM Specialist (Mid) CM Specialist (Mid)/DPM CM Specialist (Senior) If an employee has one of these job titles I would like the [Competency] field to automatically say "Cyber Security" Cyber Security Engineer (Junior) Cyber Security Engineer (Mid) Cyber Security Engineer (Senior) Cybersecurity Analyst Cybersecurity Engineer (Senior) Cybersecurity Policy Consultant (Senior) And so on and so on. I'll probably have around 10 competencies total Any help would be greatly appreciated.12Views1like2CommentsRe: Age Calculation
Here you go! // var date DOB = [Date of Hire]; var number Years = Year(Today())-Year($DOB) - If( Month(Today())<Month($DOB) or (Month(Today())=Month($DOB) and Day(Today())<Day($DOB)),1,0); var number MonthsDifference = Month(Today()) - Month($DOB) ; var number Months = If($MonthsDifference > 0, $MonthsDifference, 12 + $MonthsDifference); Round($Years + $Months/12,0.1) //5Views0likes0CommentsRe: Age Calculation
Hello, I am using this formula field to calculate years with the company in my QB App and Im getting the following bug. The bug occurs when the employee start month/day is after the same month/day for that month. It fixes itself after the month changes. Here are 2 examples. Employee Joe Smith is hired on March 3rd 2018. His "years with company" field will display 1.0 until April 1st when it will revert to 0.1 Employee Jane Doe will be with the company for 1 year on March 20th 2018. On March 20th her "years with the company" will display 1.0. On March 21st her "years with the company field" will switch to 2.0 until April 1st well it will revert to 1.1 Any help would be great!6Views0likes0CommentsAnyone ever created an API between Quickbase and Deltek GCS Premiere?
Before I call a few folks and really dig through the API user guide I thought I would ask if anyone has ever set up an API to pull Data from Deltek GCS Premiere to a Quickbase Table? Deltek is a ERP software suite and I would like to be able to pull things like employee hours and rates. Thanks!