I’ve got a few questions that I’m having a hard time figuring out the best approach to solve or if it can be solved easily (very much not a JS person)… I want to create a record in a table based on conditions from the original table. The new record should copy information from the original table that are held as different field types.
Something like this:
Conditions for new record:
xTeam is in
thisField, then create new record in
Data to be copied:
otherTable.launch --> (this is currently a lookup between the two tables where
otherTable looks up
otherTable.requestor --> (this is currently a lookup from a 3rd table)
Is this feasible in the scripting block? and are there any good examples/resources on the types of functions to write to execute this?
I’m also concerned about duplicate records, I would want to run this script weekly - is it possible to only run a script on a particular view (e.g. filtering for records created within a certain time period)