Microsoft 365 Apps for Windows 10:Default file format
Hi, when deploying M365 Apps via Intune it is mandatory to define the "Default file format". Either "Office Open Document Format" or "Office Open XML Format". This selection leads to the situation, that when saving an excel worksheet one of the above file formats are are set as the default file format to save as. How would I be able to let e.g. xlms be the default file format? cheers, heinzelrumpel
Unique Field Format for a Calculated Field
I am trying to create a new Calculated Field in a table that populates the field in a specific format. The expression I am using is [Intake Date] & [Intake Count] is for a Field I named Intake ID. The new field will be used as the Primary Key for the Table which basically counts the record entries for a given day and converts them into a reference number. To illustrate an example, I want the combination of the Intake Date input of 2/14/2022 and the Intake Count (an AutoNumber) of 1 to read as 202202140001 in the Intake ID Field. This represents yyyymmdd####. I have played around with it a bit, but cannot get it to display the way I want. Any suggestions or examples would be greatly appreciated.
