Display SharePoint Calculated Column on form
I am creating a Skybow Rich form for one of our SharePoint lists. In this list there are 2 calculated columns and I need to display these columns on the form but for some reason they don't appear in the list of fields to add.
Is this a limitation of Skybow forms that calculated columns can't be added to forms, or am I missing a step? Also, if this is a limitation, is there a workaround I can use to display the fields?
Thanks in advance for your help.
-
Hi Gareth Jayne
If you use New or Edit Form then it is normal SharePoint OOB behavior do not show SharePoint Calculated columns on it (because value for such column can be set only from existing columns). Rich Forms by itself based on SharePoint OOB Forms.
As workaround you can try create new column (single line or number type) and then using Rich Forms you can set Calculated Value for this field:
1. Go to Edit Mode of customized by Rich Forms form;
2. Add New field to Form, select then it and go to Behavior Tab;
3. On Behavior Tab you can set Calculated Value using Rich Forms Expression Builder.

Also Enable and Visible Expressions for this field (Control Status Group on Behavior Tab) can help you with displaying such fields for end-users.
Best Regards
Vladyslav Noskov
0
Please sign in to leave a comment.
Comments
1 comment