Automatically update field from portal field without any script
Hi, I have a field A that I need to automatically update with data from a field B in a portal. I did an script with SETFIELD (current table field A; data from portal field B) and it does work because when I run the script, it replaces the contents of the field A with the data from the portal... so this is exactly what I "need" BUT I need it to be updated automatically, without having the user press a button that triggers the script. I tried to set the script to trigger when I open or close the file, but it doesn´t do anything, it only works when I use a button that has to be clicked to trigger the script.
is there anyway that I could get the field to do this script without a script and only as a calculation? but I don´t find the set field function for calculated fields...