January 25, 20214 yr Newbies Consider a long list of records in list view. For each record there is a field. When an entry is made in the field, a script is run and at the conclusion the next record is selected. When reaching the bottom of the layout, the next record is not visible unless the user scrolls up. This has to be repeated for all of the remaining records. Is there a way to always keep the selected record, say in the middle of the layout? Or t least always visible?
January 25, 20214 yr You could do some math store in a variable the current record compare that to the record count and when approaching bottom of the list go to last record then go to record +- adjacent then back to the target record. It's not ideal.
January 25, 20214 yr 41 minutes ago, areegee said: When an entry is made in the field, a script is run and at the conclusion the next record is selected. When reaching the bottom of the layout, the next record is not visible unless the user scrolls up. This has to be repeated for all of the remaining records. I am not sure I fully understand the process you describe here. It seems to me that you could execute this in a new window and close it at the end - thus returning to the original window displaying exactly the same records you started with, with the original record being the current record and visible at the exact position it was when you started.
January 25, 20214 yr 48 minutes ago, areegee said: When an entry is made in the field, a script is run details?
January 26, 20214 yr Author Newbies Imagine a list of school kids. Say 100 of them. They take a test. The layout, in list view shows 100 records with a field to enter the test score. When the score is entered and RETURN, a script trigger executes a script that updates the students average and comes back and goes to the next record. When you get to the bottom of the visible layout, you have to scroll up to get to the active record.
January 26, 20214 yr 4 hours ago, areegee said: When the score is entered and RETURN, a script trigger executes a script that updates the students average and comes back and goes to the next record. When you get to the bottom of the visible layout, you have to scroll up to get to the active record. I am afraid this makes no sense to me at all. First, why is it necessary to run a script in order to update an average? And then, if your script goes to the next record, then that record becomes the active record - and if necessary, the layout scrolls down to make it visible.
January 26, 20214 yr It sounds like you leave the layout then return – don't leave the layout create a new window do you operation and then close the window. Your list will remain as you left it. If it is an 'expensive' operation where you have to find sets of records and update them you could even craft a script then run PSOS (Perform Script on Server) It could open a season on server go to the record in question do math or create or delete records and then even return a value for you to set in to the record all in a flash.
January 26, 20214 yr Hi aregee, welcome to FMForums! 😁 As Comment suggests, an average can be simple summary field. As bcooney sugests, having more information (such as a copy of your script which is triggered) would help. And as Ocean West suggests, you may not need to leave the layout even if you need a scripted process which leaves the layout. Odds are, with more information and a copy of your script, you can simplify your process and get specifically what you really need. You are being assisted by very nice and knowledgeable folks above!
Create an account or sign in to comment