1). In cases where multiple items exist within a field, is it possible to select each one individually and perform some special action (see $assigned_training variable on left of ‘Script Debug ‘ section - the bottom of the screenshot shows three items in the field that I am referencing)? I would expect that that the 'For each' command would apply but I need to capture each one by itself first.
The only thing I can think off right now is that if the many to many relation field you have is set to open the selected record populated into it with a “double click”.
This can be found in the individually properties tab of the many to many relation field.
When the selected record opens in a popup window, you could then run your script by pressing a button on the forum. You could have this button only viable when the record is viewed in the popup window getting it to check your current folder name.
Or you could run a script automatically when the record is displayed in the popup window by using the option “on selected”.
I've attached an example of this working to this post. If you open the database, just double click on the first item in the many to many relation field, and press the run script button.
This will step through the 4 records.
2). When I step through and debug the code, the results of the variables I set appear as numbers rather than what the value actually is. asokram suggested that my problem resided in the recordset formatting, however, I have made zero progress in correcting this (even after reading and re-reading the user guide… the variables still show as numbers???). This question applies to all three variables – ($employee_name, $assigned_training, and $job_title). If possible, please add a line of script that I need to use as none of my attempts of the demos in the User Guide worked for me.
Sorry but I cannot reproduce that problem here. It's working as expected for me.
Do you have a test file you can share so I can take a look at it?
3). Is it possible to code the program so that the user can 'grab' information from other folders without requiring the program to physically go to these other folders to retrieve the needed information?
Yes, if you run a query it will go an fetch the data and populate a field or variable without actually leaving the screen currently displayed.
If the data is static, then you can run a script that will pull data from the first record of any folder.
There are a number of options available, but it all depends on what your intended use is exactly.