DebbieSmith1
Quickbase Staff
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Practice exam app builder not working
Hi, Please try it now. The exam platform was unexpectedly down Sunday and Monday. It is back up now. https://university.quickbase.com/cp07-2019-certification-app-builder-practice-exam ------------------------------ Debbie Smith Certification Program Developer Quick Base Plymouth MA 2394106333 ------------------------------Re: Trouble setting up tables
Hi Ashley, There are always many different ways to approach a solution. To simplify the structure and get the reports that you need, you may want to consider using 2 tables. A States table and a Requirements table. You can relate each requirement to a State and then use summary fields to show past due, open status and closed, etc. You would create the report for this on the States table. On the requirements table, you would create the report by functional area. If you want your managers to see these 2 reports at the same time, you can create a custom home page for the manager role and put both of these reports on it. You can add any other reports that they need too. ------------------------------ Debbie Smith Certification Program Developer Quick Base Plymouth MA 2394106333 ------------------------------Re: Join Existing Data
I think the easiest way to accomplish this would be to create relationships between the tables and use form rules to have the user choose if they are paying a vendor or an employee. Create a pay to field that has a choice of employee or vendor. Create a relationship between Payments and Employees with Payments as the parent Create a relationship between Payments and Vendors with Payments as the parent On the Payments table set a form rule to show: The other option is to create a payees table and then create a relationship to the employees, vendors, and payments tables and then create an automation to add a record to the payee table each time a vendor or employee is created. ------------------------------ Debbie Smith Certification Program Developer Quick Base Plymouth MA 2394106333 ------------------------------Re: Adding records (tasks) more effectively
Hi Andrew, On my Projects table form, I changed the tasks report "Embedded for Projects" to editable. There is a checkbox in the Elements tab of the form editor that you can use for this. That way when a user adds the tasks it will save to the correct project.Re: How to create table relationship model for this table?
Hi Syaeful, You could do this with just 2 tables. You can create a relationship between table a and table b and then use a summary field to total all of the Child Header- Cost Projects by Header and create a report that shows the Header and Cost Project.Re: When can I expect the cert for 2019?
Hi Raul, Great Question. If you have earned either the Builder or the Expert Certification, you will need to complete the 4 Continuing Educations courses by January 31, 2019. We will begin issuing the 2019 Certifications next week. Please let me know if I can help in any other way! Smiles, Debbie
