LijaKoch
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Type-Ahead"" Search Picker
I created a case to get early access to type-ahead search picker. However, when I edit the form for related record fields (lets call it Related Contact) based on a record picker, it does not show the fields as it used to. When I click inside the Related Contact field, the record picker fields are there, but once selected, the field only shows the contacts name (first record picker) not the other two - email and phone. Is there a way other than creating another field that shows when editing the form all the record picker fields in that Related Contact field?Re: QuickBase automation add a new record with conditions
Hi, Thank you so much for your response. I think the only part I do not understand is how does the task table know to do this when the record does not exist. I created an automation under the tasks table that when a task is modified, deleted, added to then create a task child record under the document control table. But because no task exists, how does the table know if the Next Update field (field in the document control table) is after today's date? I created a relationship between the documents table (parent) and the task table (child) and did a "look up" to the tasks table to look up the "Next Update" date field. The problem I think is how does the task table know if the Next update field is if the record does not exist. I created a formula field to be "1" if the Next Update Date is past today's date and 2 if it is not. Because automation does not let you do a condition based on a date field, this was my best option. So, I added the condition that if the Document - Next Update Date Trigger is = 1 to add the task record, but currently this is not working because I think the task record does not exist and does know know what the next update Date trigger field is. The reason I would like the task table to have the automation is because users edit and modify tasks more than they would be editing anything or any record from the document control table.QuickBase automation add a new record with conditions
I have a question when it comes to creating an automation that creates a new record. I have a parent table called "Document Control". There is a field under that table called "Next Update Date" that tells the user when they should be reviewing the document next. Under the Document Control table is a child relationship to Tasks. Documents will have many tasks. I would like to create an automation when the "Next Update Date" is today's date, to add a new task record to that document. (I do know to have the Related Document Control = document control record Id) So for example, say the Next Update date is today's date, then I would like a task record to be created under the document control parent table. The problem I think is, is because the task record does not exist, the task does not know if the Next Update Date is today/past due. I also do not want to just add a task record as other Parent Tables have a child relationship to the tasks table. For, example, the parent table Projects has many tasks. I do not want tasks to be created randomly without a link to the parent nor do i want many tasks being created under the Projects table. Is there a way to do this better?Connected Tables and reporting
Hi, So my company has multiple applications within Quickbase that I have built. I got asked a question today from a manager asking if she could have a report that combines project information from two applications. I created a new combined database and used QuickBase Sync to create tables in the database that link to the tables I needed from the other two databases. The First Table which is a connected table to Database #1 with fields such as status and project ID. The second table is a connected table as well to Database #2 with the same fields (status and project ID). The databases are very similar but separated due to program budgets. Basically I am super confused on how to create a report that combines these two connected tables?
