Is the comment itself entered by hand or entered via a script? My concern about hand entering this data is that data entry errors can keep any script that checks it for patterns from working correctly in cases where a typographical error occurred. If you use a script to enter this text in the first place (perhaps via selecting from a value list on a field with a script trigger), that same script can handle the additional tasks that you specify in this post.
I enter it by hand. And even if typo errors occur, script trigger will not close current layout, so I'll be able to fix it, at least I will see record created and will still have to enter a_type field - whether next action is a call/meet or mail.
my idea for calculation would be this (as most of the parts is text) - create variable, which substitutes a_info field all the numbers to let's say 9. And then I will search for Position of 999999 99.99 (substituted from 140910 10.15) and then I will be able to extract date and time of next action and put those in proper format. It's highly unlikely, that I will put 6 digit number for other than date, so that should work.
I was able to accomplish it.
Though, I'm not quite happy, that I need to go to different layout (as portal is based from different table), create record of next action and after going back, I need to scroll down to the very last record in the portal.
Is there a way to automate it via script that when script goes back to original layout, it would go to the last record of the portal and go to the specified field?
Go to portal row [last] will scroll the last portal row into view. But be careful to first use go to object to put the focus on the correct portal.
But it's possible to create a new record in a portal's table without changing layouts if that's why your script changes layouts.
And I still think using a script to enter this text--either from a button click or via a script trigger equipped value list makes for simpler, faster and above all, more accurate data entry.
go to portal row [last] doesn't work for me. my script goes likes this: 1) go to layout [original] 2) go to object [Object Name: "Action History"']// I tried setting here object name for either all portal or just a field in a portal, same results // 3) Go to portal row [Select; Last]
I also tried go to portal row first/previous/next, but they all went to the very first row of the portal, not last.