Try clearing the "do not replace existing value" check box and see if it now works.
It didnt work Phil
The portal contains 2 fields. The Sort Number and Appendix Item. The Appendix Item is a popup list.
I think it has something to do with the parent record not being refreshed prior to the next portal records being created and consequently the autoentry calc being wrong
I have hammered a solution through by creating an overkill solution.
- refresh, flush cached join result, flush cached external data
This is applied to my data entry popup menu as script trigger. I've applied it to all options, from OnObjectEnter through to OnObjectExit. This now works but I don't understand the logic.
Please can you assist please?
Refresh Window with the "flush" option specified fully refreshes all data refrences in the layout's current record. That can lead to significant delays in getting the layout to update in some situations and thus is an option best avoided.
A commit records step after adding eachy new portal record may be all that you need to get the field to update. You can test this manually by clicking the layout back ground after each new portal record as this forces a commit records.
And if you are using a script to force the update, you could also set up a number field in the parent record and just use Set FIeld to update it with the next value in the series each time you are now using Refresh/flush to update the value.