ContributionsMost RecentMost LikesSolutionsRe: Connecting two child databases?Is there a way to automate that? I want to place restrictions to the homeowners that a user can view based on the date of the sales appointment. Homeowners are attached to a forum like thing on their accounts so users can view all of the interactions someone had with a homeowner. Not all homeowners have appointments, but all homeowners will eventually have an interaction. And some users should only be able to see homeowners that their appointments are linked to / appointments for the whole team for that day I'm not sure if there is a way to jump on a call with you or another consultant as well as get someone on the app to see it to help get this in place?Re: Geolocation and form fieldsHi Dan, I'm a little late to this, but would you mind sharing the modification to the script to run the geolocation as soon as the page loads?Re: Connecting two child databases?Changed the relationship before I did the combined text, unfortunately the Maximum Appointment Date didn't work either. There is sample data in there, is that the second question you're asking? I think I'm confused because the series of events go like this: 1. User inputs homeowner data to Canvassing Leads 2. Canvassing Leads updates Homeowner Contact Details with an automation 3. User adds appointment data by looking up the homeowner using the Canvassing Leads data 4. At this point, the user would have to lookup the homeowner appointments by linking the homeowner to appointments on the Homeowner Contact Details page via a dropdown or something? Does that sound right? So sorry for all of my confusion, I really appreciate your help with this (and the help you've given previously so we newbies can google it!) Also, PS, the three fields I would need to pull from appointments in to the homeowner details are status (multiple choice), Date (date), and time (multi select)Re: Connecting two child databases?I don't know if it makes a difference, but the homeowner name, address, etc are automatically being added to Homeowner Contacts from Canvassing Leads via an automationRe: Connecting two child databases?OK, so that didn't give me any errors. However, it's not showing up :-\ I'm not even sure where to begin debugging this. Possibly a relationship issue? Re: Connecting two child databases?Okay, so this is what I have in a Formula - Text field on the parent record:ToDate(ToText([Combined Text Appointment Date in Text Format])) Error I'm getting is: "Expecting text but found dateRe: Connecting two child databases?I have a report link in the Homeowner Contact Details connecting to sales appointments. Am I able to pull information from specific fields using report link? What I'm looking for is to pull a status, a date, and a time from Sales Appointments to Homeowner Contact Details.Re: Connecting two child databases?Totally agree that Homeowner Contact Details should be connected the opposite way to Sales Appointments. What I was running in to though, is that I cannot do a combined text field of the Appointment Date, I get this error "That summary function cannot be applied to this field..."Connecting two child databases?I have three tables. Canvassing Leads which creates records in Sales Appointments and Homeowner Contact details. Now I need to grab the appointment day and time from Sales Appointments and put them in to Homeowner Contact details. I guess the issues is is that I don't know how to make Sales Appointments update the correct Homeowner Contact, which got it's info from Canvassing leads. Here's my relationship diagram.