Hi,

I'm trying to populate a form with data from another form using a Schedule function but can't seem to get a syntax that works.  I have the following:

Form = Job_Details

Field = Location_ID   string

Field = File_URL   URL

Form = Site_Documents

Field = Folder_ID   string

Field = Folder_URL   URL

Field = URL_Transferred  Decision (true)

I have a report based on Site_Documents that filters the records by URL_Transferred = false and if I edit any of the records individually from that report I have a simple script that populates the File_URL field in Job_Details and URL_Transferred field in Site_Documents based on Job_Details.Location_ID = Site_Documents.Folder_ID and this loads correctly on Load and saves them both on Submit.

My challenge is that I need this to happen automatically behind the scenes without user input so I thought I could schedule a function to run every x hours that could do this but no matter which way I approach it from I don't seem to be able to get a script that works or has the correct syntax.  The only match between the 2 forms is Job_Details.Location_ID = Site_Documents.Folder_ID and I don't know how I can relate the forms using their normal ID fields because the record in Site_Documents is created externally from Dropbox via a Zapier connection so there is no immediate relationship available, otherwise I would simply use a subform.  Is anybody able to point my in the right direction or give me another suggestion if what I'm trying isn't possible?