ContributionsMost RecentMost LikesSolutionsRe: URL Link in Table to Table Relatioship Ok, I'll look at the relationship again and let you know if I can fix. Thanks, -g Gwen Peters Director of Global Events Gwen.Peters@blackline.com Keep up with what's new in Modern Finance: Twitter | LinkedIn | Modern Finance Blog URL Link in Table to Table RelatioshipMy parent table includes a url upload field. In my child table I'd like to pull in the URL link from the parent table. Is that possible? If so, please let me know what I am doing wrong. Thank you! -g ------------------------------ Gwen Peters ------------------------------ Re: Calculate the difference between two dates Thank you Mark, the solution below worked perfectly! Gwen Peters Director of Global Events Direct: 747.242.2826 | Cell: 805.844.4927 |Main:818.223.9008 |Web:www.BlackLine.com Gwen.Peters@blackline.com Keep up with what's new in Modern Finance: Twitter | LinkedIn | Modern Finance Blog Calculate the difference between two datesI have a formula numeric field (called Duration) where I'd like to show in days (excluding weekends) the difference between the start date (date field) and end date (date field). I'm using the following formula, but the number in the Duration field is not right(([End Date:] - [Start Date:]) / Days(30)). Please let me know what am I doing wrong. Thank you! -g ------------------------------ Gwen Peters ------------------------------ Re: Auto-populate fields from one table into another If you have time today Mark, I would love to jump on a call. Please let me know. Gwen Peters Director of Global Events Direct: 747.242.2826 | Cell: 805.844.4927 |Main:818.223.9008 |Web:www.BlackLine.com Gwen.Peters@blackline.com Keep up with what's new in Modern Finance: Twitter | LinkedIn | Modern Finance Blog Re: Auto-populate fields from one table into another Here you are... Gwen Peters Director of Global Events Direct: 747.242.2826 | Cell: 805.844.4927 |Main:818.223.9008 |Web:www.BlackLine.com Gwen.Peters@blackline.com Keep up with what's new in Modern Finance: Twitter | LinkedIn | Modern Finance Blog Re: Auto-populate fields from one table into another I tried creating the automation, but I get the following error. Not sure what I'm doing wrong. Gwen Peters Director of Global Events |Web:www.BlackLine.com Keep up with what's new in Modern Finance: Twitter | LinkedIn | Modern Finance Blog Re: Auto-populate fields from one table into another Thank you Mark. I will try this. In addition to the auto-populated tasks, will I still be able to add new tasks to the project if necessary? Gwen Peters Director of Global Events Web:www.BlackLine.com Keep up with what's new in Modern Finance: Twitter | LinkedIn | Modern Finance Blog Auto-populate fields from one table into anotherI've created a project table to record ongoing projects. Separately, I have a tasks table that lists activities that are associated to ongoing projects. I created a relationship between the two tables without a problem; however, what I would like to do is have a set of pre-determined tasks automatically populate into the project table based on a drop-down field selection within the project table. Example: In my project table, if I select the event type as "webinar", I'd like all the assignments from the task table that relate to a webinar to automatically appear in the projects table. Can this be done? Thanks everyone! ------------------------------ Gwen Peters ------------------------------ Automatically Filter ReportsI've created a table report that list an events calendar for 2020. I'd like this report to automatically filter out events as their end dates pass. Is this possible in QuickBase? ------------------------------ Gwen Peters ------------------------------