If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Brilliant Database > Help with treatent of multiple items within a field

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Location: Huntsville, AL
Posts: 325
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
Help with treatent of multiple items within a field-data2.png  

Last edited by fireant911; 12-31-12 at 15:27.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Location: Ireland
Posts: 578
Quote:
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.

Quote:
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?

Quote:
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
File Type: zip many2many.zip (36.3 KB, 5 views)
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 130
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On