Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2012
    Location
    Huntsville, AL
    Posts
    337

    Help with treatment of multiple items within a field

    I have three questions for the BD gurus here (examples of my problems appear on the attached screenshot):

    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.

    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.

    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?

    Can anyone offer a solution to these three questions?

    Tomorrow ends my 30-day evaluation period of Brilliant Database. I would really like to use purchase and use this software but I cannot seem to make much in regards to any forwards strides...

    Thanks,
    Daryl G
    Attached Thumbnails Attached Thumbnails data2.png  
    Last edited by fireant911; 12-31-12 at 16:27.

  2. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    640
    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.

    Regards
    James
    Attached Files Attached Files

  3. #3
    Join Date
    Jul 2011
    Posts
    137
    Quote Originally Posted by fireant911 View Post
    I have three questions for the BD gurus here (examples of my problems appear on the attached screenshot):

    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.

    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.

    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?

    Can anyone offer a solution to these three questions?

    Tomorrow ends my 30-day evaluation period of Brilliant Database. I would really like to use purchase and use this software but I cannot seem to make much in regards to any forwards strides...

    Thanks,
    Daryl G
    I understood your full problem. You can send your database file. I will correct and send back.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •