In Custom Entity, how to autopopulate field in excel Data Connector add-in

For reference, the thread for the last point is ActivityNumber Not Auto-Populating on Initial Publish for New Excel Add-in Rows. Let’s not duplicate the discussion here.