HunterB
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Pipeline to Auto-Assign Trainings to Employees by "Profile"
I have three tables in Quickbase: Employees Trainings Profiles I’m trying to build a Pipeline that automatically assigns trainings to employees based on their "profile". Example: The "profile" called “Basic”requires: CPR Training First Aid Training If John Doe is assigned the “Basic” profile, the Pipeline should automatically add John Doe to the existing CPR and First Aid training records. A few important requirements: The Pipeline should only add trainings where the Employee Profile matches the Training Profile. The Pipeline must check for duplicate trainings and NOT add the employee to a training if they are already associated with it. If this can be done without a Pipeline I am all ears.60Views0likes3CommentsSet Height for Rich Text Field
I have a form rule that automatically puts text into a rich text field but I would like the rich text field height bigger. How can I do that? I added the the formala rule to set the height to a certain number of pixels but it doesn't seem to be affecting it.Solved115Views0likes1CommentRe: Create Report of Weekly Timecard Completion
This is really close to what I am looking for. If I filter the results to timecards created this week it does not show me employees who created no timecards for the week since those records don't exist but I would like to see employee's with no timecards for the week as well. Is that possible?28Views0likes0CommentsCreate Report of Weekly Timecard Completion
Hello, I have a timecard app and I would like to create a report that displays a yes or no if a timecard was completed for each week day. The report would show all employees. Is this possible? Or can something similar be achieved? Additionally I would also like to show a month total completion number such as 23/30 days completed. Employee Mon Tues Wed Thurs Fri Month Total Name yes no yes no yes 25/30 Name yes yes yes yes yes 30/30 Name yes no yes yes yes 15/3037Views0likes2CommentsHave Approve Button Direct back to the Master Record
I have an approve button and right now when the user uses it it directs them to the detail record that the approval button is for. How do I change the button to have it direct them back to the page they were on before they clicked the approve button. Here is how the formula is setup now. URLRoot() & "db/" & [_DBID_Onboarding_details] & "?act=API_EditRecord&apptoken=*AppToken*&_fid_15=" & URLEncode(User()) & "&_fid_16=" & URLEncode(Today()) & "&_fid_26=1" & "&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])Solved136Views0likes1CommentSend Weekly Reminder Email based on Criteria
Hello, I would like to send a weekly reminder email 7 days after the record is created and would like it to keep sending until the Est. Start Date field is filled out. Can this been done? I would like it to only send the records that they are the record owner on. As an added bonus is there is a way to have the reminder email to start up again once it reaches the date in the Est. Start Date?37Views0likes1Comment