Lock data entry row total cell only
Hi BOARD team,
I had a data entry table as following. Can I lock data entry for the row total only (allow data entry at the detailed level, but not the total)?
Can I add a validation based on the TOTAL? When user make data entry at detailed level, the total must be added to 1, otherwise system pop up an alert and does not allow save the data entry. Thanks
Thanks
Accepted Answer
-
Hi @Harry Sun ,
there is unfortunately no direct method to achieve that.
You can switch off the row totals for the data entry enabled block and then
- display its values separately in a further block without the detail by and no data entry or
- use the rt(<block>) function to calculate the row total or
- use Nexel to calculate the row total
All of those have a common disadvantage: they will only show the new values after data entry has been saved. Any validation as to their sum needing to be a special value (1 in your case) needs to be performed after data entry, which is not very user-friendly.
You might want to propose an idea regarding that behaviour.
Best,
Helmut0
Answers
-
Thanks a lot Helmut.
1