ContributionsMost RecentMost LikesSolutionsRe: Many to Many Relationship - 3+ TablesKey Fields: Intake: Record ID# Info: Data ID# (renamed Record ID) Alias: Alias (text field) Unsub: Unsub (text field) Relationships: INTAKE: Many Intake Reports belong to a Single Alias Many Intake Reports belong to a Single Unsub INFO: Many Data Points Belong to a Single Unsub ALIAS Many ALIAS belong to One Unsub UNSUB has the three references prior.Many to Many Relationship - 3+ TablesScenario: (will be using terms from Criminal Minds) Table: Intake Intake collects up to 5 Phone Numbers 5 Email Addresses 5 Websites 1 Name 1 Alias Names are not Unique Alias Must be Table: Info Each Verified Phone Number has a new record with the Phone and Alias Each Verified Email has a new record with Email and Alias Each Verified Website has a new record with Website and Alias Table: Alias Contains All known Aliases Uses a Report Link to pull Every Phone associated to the Alias from Info Every Email Associated to the Alias from Info Every Website Associated to the Alias from Info Every Name associated to the Alias from Info Table: Unsub Links multiple Alias's together based on what our goal state is. Goal: We want to from the Alias table see any other Alias that a given Phone,Email, or Website may be linked to. Any given piece of the contact info could show up on more than one Alias Current State: Any attempts I've made to run reports or build relationships from the Alias table: only return data that matches the Alias Does not return related data to the given phone, email, or website regardless of how I've built the Report Links. Example: Intake record could have: Record 1: Alias: BAU Name: JJ Phone 1: 202 555 5555 Phone 2: 555 867 5309 Record 2 Alias: BAU 1 Name: Reed Phone 1: 555 123 4567 Phone 2: 202 555 5555 When I look at the Alias table for BAU, I want to see that 202-555-5555 also showed up in BAU1 Using a Multi Select Field on the Parent Record of a RelationshipI have a contact parent record with the Multi Select field: "Group" Each Contact may have multiple groups. Each Group has Unique Products Can I set a relationship so that when I pick two or more groups, the product drop down will show only the products for the selected groups? Note: No issue with One Group > Product Relationship. The moment we try to do multi select, it breaks.Re: Is there a way to write a conditional formula that runs an API Edit record without user input?Actually - yes. Yes it would!Re: Is there a way to write a conditional formula that runs an API Edit record without user input?Thanks. That is sadly unfortunate.Is there a way to write a conditional formula that runs an API Edit record without user input?Basically - I want to be able to trigger an checkbox on a condition without any of my users having to edit the record manually. The check box then being seen as an API Edit record triggers an email response. ie: IF( [1st Notification Date]=False AND [Notification Date]=Today() URLRoot() & "db/" & "dbid" & "?act=API_EditRecord&apptoken=xxxxxxxx &key=" &[Key Field Name] & "&_fid_xx=" & URLEncode ("1") WebHooks and QuickBase actions need an Add or Edit record to trigger so I didn't think they would work for me in this instance.