Electronic Form & Workflow with SharePoint Online Site Column, Calculated Column, Content Approval on Custom List
Problem As a member of Agile Development team, I've been tasked to utilize SharePoint Online custom list to quickly mock-up electronic form, database, workflow and I found interesting features and limitations that SharePoint Developer should be aware of in order to utilize built-in SharePoint functionalities to suit certain use-cases. Findings Site Column Tips It can be hidden from the list form by configuring Site Content Type. Limitation It must be optional to be dynamically hidden via list form Edit columns | Edit conditional formula . Calculated Site Column Tips 1. Calculated site column can be used to include other site column(s) for list view column formatting reference purpose (i.e. =if(1=1,[CalculatedColumnNameToDispayOnListView],[OtherColumnName1]+[OtherColumnName2]...). 2. Name with : suffix (i.e. Date Submit for Approval: with formula =IF(1=1,IF([Date Submit For Approval]>0,[Date Submit For Approval]," "),[Flow Is Running]+[Form Status]) ) to use on list