ContributionsMost RecentMost LikesSolutionsRe: How do I copy the record owner from record A to record B? Good idea, Mark! Thanks! I can't take credit for this solution, though. I have to credit the awesome team of Quickbase SuperUsers at Aetna for their idea! I created a pipeline that creates a record in Table B based on the data from a record in Table A. The pipeline takes the data from the Table A record and copies it to Table B. The problem was the record owner for Table B was not the same as the record owner from Table A. (I guess you can't copy record owners?) Any way, to get around this, I added a "Make Request" Webhook step in my pipeline after record in table B is created. This step changes the record owner for record B to be the same as record A. ------------------------------ Tom ------------------------------ How do I copy the record owner from record A to record B? Ignore this question. I solved the issue. I don't know how to delete a submission after it's been submitted. ------------------------------ Tom ------------------------------ How to write formula for [Due Date] minus 2 weekdaysHow would I write a formula to have the system subtract two weekdays from a date field, please? My formula below will calculate 2 calendar days from the due date. So, if the due date is Monday, 5/23/22, the system should identify Thursday, 5/19/22, not Saturday, 5/21/22. [Due Date]-Days(2) Thank you! ------------------------------ Tom ------------------------------Locating Multiple Choice Field "red text" recordsIs there a way to find records in a table that have orphaned, red text multiple choice options? In the example below, the records have a multiple-choice option that no longer exists. (To be clear, I'm not looking to identify only records with red "Third Party Governance." There are plenty more records in the table that have orphaned records. I need to find all of them.) Any help would be appreciated. Thank you! ------------------------------ Tom ------------------------------Re: How to Email all Application Users?Worked like a charm. Totally didn't even see the button staring me in the face. Thanks, Mark! ------------------------------ Tom ------------------------------ How to Email all Application Users?Is there a way to email an application's users all at once? For example, if there's something I'd like to communicate to them (newly released enhancements, procedure changes, etc.), is there a way to do this in the application? I'd prefer to send one email to all users at once versus sending each user an individual email. According to Quickbase Help, there is a way to do this if you have access to the Billing Account page, but I don't have that access. Any help would be appreciated! Thank you! ------------------------------ Tom ------------------------------Too many entries in multi-select text field. Need solutions, please?I have an app for project managers. When they create an activity, they can assign that activity to a project team member or other resource. The Assigned To field in the Activities table is a multi-select text field. The Assigned To field is pulling from the Resource Namefield in the Resources table. As project managers identify new resources, they can add those resources to the Resources table. The problem now is the Resources table has 118 resources. The Assigned To field, being a multi-select text field, can only handle 100 maximum entries (I didn't know that when I set up the field. Argh!). So, now I can't edit that field, because when I do, I get this error:Choices too long. 118 choices specified. Field may not have more than 100 choices. And over time, we're going to have more than that. My research shows I should have created a one-to-many relationship between the ActivitiesandResourcestables and use the reference field as the source for the dropdown. So, I did that. The problem is I can only select one resource. We need to be able to select multiple resources that will work on that activity, hence why we originally set it up as a multi-select text field. Ideas anyone?? Thank you, in advance, for your help and consideration! ------------------------------ Tom ------------------------------ Re: How to Center a Column?Mark, thank you for your reply, however, I already tried that. The ellipsis does not include that option (see below). That was the first thing I tried, and when I noticed it wasn't there, I thought perhaps I needed to adjust the formula somehow? ------------------------------ Tom ------------------------------ How to Center a Column?Can anyone kindly tell me how I might be able to center the image in this column? The Project Condition field is a Formula-Rich Text field with the following formula: If([Status]="Not Started" and Today()<=[Est Start Date],"<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\" title=\"Inactive\">", If([Status]="Not Started" and Today()>[Est Start Date], "<img src=\"https://images.quickbase.com/si/16/221-point_red.png\" title=\"Delayed Start\">", If([Status]="In Progress", "<img src=\"https://images.quickbase.com/si/16/222-point_green.png\" title=\"In Progress\">", If([Status]="Issue", "<img src=\"https://images.quickbase.com/si/16/223-point_yellow.png\" title=\"Issue\">", If([Status]="Completed", "<img src=\"https://images.quickbase.com/si/16/211-check_all.png\" title=\"Complete\">", If([Status]="On Hold" or [Status]="Canceled","<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\" title=\"Inactive\">", "<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\" title=\"Inactive\">" )))))) Thank you for your assistance! ------------------------------ Thomas Gause ------------------------------ Display predecessors for related projects only?I recently downloaded the Simple Project Manager app from Exchange and I would like to make a change to it, if this is possible. I'm hoping someone may be able to provide me with a solution. When you add a new task to a project using this app, you have the option of adding predecessors to that task you just created (see Predecessor Link image). When you click the Add Predecessor link, it displays all tasks for all projects (seeSelect a Taskimage). Is it possible to somehow have this record picker display only those tasks that are related to this particular project? As more projects are added to this app, it will become cumbersome for users to sift through all of the tasks for all of the projects. Any assistance would be greatly appreciated. ------------------------------ Thomas Gause ------------------------------