Forum Discussion

JeffreyPierce's avatar
JeffreyPierce
Qrew Trainee
5 years ago

Long-distance relationships; or secondary keys

Imagine an Offer Block (part of an advertisement on some kind of page) which contains a Long Sleeve Shirt Style and a Short Sleeve Shirt Style; but each Style is really a Group consisting of many...
JeffreyPierce's avatar
JeffreyPierce
Qrew Trainee
5 years ago
Here's how I resolved this, for now.

One automation: when a record is added to Offer Block Members, then ...
  1. Action 1: Copy records from Grouped Items to Offer Block Data where Grouped Items.Group ID matches Offer Block Members.Group ID
  2. Action 2: Modify records: Insert Offer Block Items.Offer Block ID into Offer Block Data.Offer Block ID where Offer Block Data.Group ID matches Offer Block Members.Group ID and Offer Block ID is blank

I'd like to tighten up the Filter criteria for Action 2 to avoid two users cross-populating each other's records, but so far matching on Record Owner (me) isn't working as expected.  Thanks for reading ...

------------------------------
Jeffrey Pierce
------------------------------