Hello,
I have two tables (“Table 1” and “Table 2”) that are linked on a single field (“My Field 2”) with a many-to-many relationship.
I’m trying to write a script to gets all of the records from the table Table 1 where the field My Field 2 does not c...
I’m trying to delete duplicate records from a table.
I have table “Table1” that contains linked fields “Field1” and “Field2”. Where multiple records have the same values in “Field1” and the same values in “Field2”, I want to delete all duplicate reco...
Hello.
I’m trying to write a script that loops through all of the records in the table MyTable1, and for each record in MyTable1 loops through all of the records in table MyTable2, and at each iteration checks to see if table MyTable3 contains a reco...
@JonathanBowen, in your example, you got an array of unique company names as strings from the People table. What I’m trying to do is for each unique company name in the array, I don’t want the unique company name as a string, I want to get the whole ...
@JonathanBowen, thank you for that write up. It’s been very helpful for me as well!
If you don’t mind me asking, as a follow-up question, instead of returning a list of unique values, is it possible to adapt this script to return the record objects o...
@Jeremy_Oglesby, would you be able to provide some examples of how to do this? This is actually something that I’ve been looking for instructions on how to accomplish and haven’t really been able to find anything that clearly explains the process.
Th...
