RickyWhite
Qrew Member
Joined 3 years ago
User Profile
User Widgets
Contributions
API from Users table
The roles in Quickbase that we have set up don't allow our users to see the Users table to see if the user is registered or not by the status field. Since this is a pre-existing table it doesn't seem possible to create a relationship between the Users table and our Employees table. Is there a Query that I could use to get the status of an employee to distinguish if they are Registered, Unregistered, Unverified, Deactivated, or Denied in another table?38Views0likes0CommentsConnected Table Error
Not sure if anyone would be able to help with this due to not much info. I have a connected table from another Quickbase app and keep having a refresh error. The history says, "The error was: Error parsing record. Tracker ID: [565bjjqqr2a2]" which I can not figure out why. When I search this error I just see "Error parsing csv.". Could anyone explain what the parsing record is and what is the Tracker ID?110Views0likes1CommentRe: Auto-generate Name of User
Okay, that worked. I was thinking doing it that way would mess up if someone was to edit the form again it would change the name, but it only seems change if the field changes from false to true, which I have the condition set to is not blank. So, thank you! ------------------------------ Ricky White Ricky ------------------------------29Views0likes0CommentsURL Add Record then Save
I need an URL to allow me to Add a record, then save it, and then allow me to edit it. When hitting the add record button it creates a form filled out but the users need to add a document then hit a checkbox on a report link. When the users hit save the checkbox from the report link did not go through. They then have to edit the record and hit the checkbox again. This checkbox is in a report link that is to another table. I need it to where they don't have to keep going back to reselect the checkbox. This is the current formula: URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&_fid_8=" & URLEncode ([Field 1]) & "&_fid_22=" & URLEncode("Document") & "&z=" ------------------------------ Ricky White Ricky ------------------------------156Views0likes14CommentsAttrition Summary
I made a YTD formula-text field that states if End Date is null then "New Hires" and if not null "Separations". I then created a Summary Report that shows the number of employees that are separated between the "New Hires" and the "Separations". I'm not sure if this is possible, but I would like for the total to show a percent of the totals between the two. The percentage formula being Separations/New Hires*100. Could I add the formula in the YTD field, in the summary report, or do I need to take a whole different approach to this? ------------------------------ Ricky ------------------------------2Views0likes0CommentsAttrition Chart
I am struggling on creating an Attrition Chart in Quickbase. I need to create a Total YTD New Hires and Total YTD Separations that shows the Attrition %. An example would be Separations YTD = 14 and YTD New Hires = 57 to the attrition being 12%. The New Hires field is Start Date and Separations field is End Date. ----------- Ricky -----------12Views0likes1Comment