I have a simple Let statement = Let ( [$LN = player_data::_last_name] ; $LN ) that works perfectly in the Data Viewer but not in the Text Field that I put it in as a Auto Enter Calculation.
What could be the cause of this?
If context is correct - have you unchecked do not replace existing value of field (if any)?
This will trigger when player_data::_last_name changes
Sometimes people get tripped up by this detail:
If you have records in your table, and you then add or modify an auto-enter calculation. The value in this field for the existing records will not automatically change due to the change made to the auto-enter calculation. Only a new record or an edit to one of the fields referenced in the calculation will cause an update of the value in the field.
The fix, if you want that update to happen to your existing records, is to either use the same calculation with a replace field contents operation or:
Change the field to a field of type calculation, exit Manage Database (you'll get a pause while the field recalculates.) then return to manage database and change the type back to the original type and re-enable the auto-enter option. (during these changes, the calulcated expression is preserved.) Note that this option won't work if you use "self" in your calculation.
Retrieving data ...