Custom join condition

[Mary Stamper]

Is there a way to create a custom join condition?

Given

Form F1 with column C1

Form F2 with column C2

On form F2 create a Link to Form F1 where F1.C1 contains F2.C2

F1.C1 data:

sag mal

schonmal

F2.C2 data

mal

F2 Idiomatic Expressions shows rows from F1 that contain the expression “mal”

sag mal

ein mal

I would like this to dynamically update if new qualifying expressions are added to F1

Since this could occurs thousands of times, I don’t want to create saved searches per se. Guessing this could maybe be implemented using the saved search library functions?

 

 

• This topic was modified 1 year, 3 months ago by Mary Stamper.

[Brendan]

Join type relationships can only do a direct equals comparison and not a contains type comparison. But you can use a Script or Calculation field to return some value in both form F1 and F2 that would do the special function to get an appropriate value (such as matched) and then use the Join from and to fields to join with those fields in each form.

[Mary Stamper]

Thanks. I’ll think about this one. Just started using scripting. I’ll try to figure it out.

[Author]

Posts