Be present when listening

My pick from my Sunday breakfast watching TED Talks is Celeste Headlee: 10 ways to have a better conversation.

My takeaway is: “Be present when listening” I am aware that when listening to trainees tell me about their requirements at the start of a course, I have to resist mentally multi tasking and focus!

Office 365 Planning, Migrating, Adoption resources

Microsoft have gathered a range of resources for Office 365 covering SharePoint, Office and Skype for Business as well as planning and end user adoption at http://fasttrack.office.com/. When you get there click about a bit, a lot of the “good stuff” is a couple of clicks down.

These resources are of use to you if you have recently moved to one of the many varieties of Office 365. I’ll be reviewing this in more detail myself next month as part of revamping my own SharePoint site.

Go Explore…

Two Live Cycle Designer Questions

Q. Can I total values in a table, e.g. one amount in a number field per row?

To cover a related question, this approach should work for check boxes in a table which gave been allocated values

Assuming you have a table with repeating rows in place

Form with Table prepared , rows and fields renamed
Form with Table prepared , rows and fields renamed

You then need to open the script editor panel via the Window menu.

Select the field that will act as the grand total – in my example, this is called Total.

In the Object panel set value to Calculated Read Only

Set Value to Calculated Read Only

Set Value to Calculated Read Only

In the Script Editor panel choose calculate

In the Script Editor panel, choose Calculate
In the Script Editor panel, choose Calculate

Set the Language to FormCalc

Set language to FormCalc
Set language to FormCalc

Then in the panel add the following code – Use your table name, row name and field name. Read  [*] as saying “for each instance of the object” “This” refers to the currently selected object, in this case the grand total field.

this=sum(Table1.DataRow[*].Amount[*])

Save and test

Use tab key to move from field to field
Use tab key to move from field to field. This will trigger the recalculation of the total.

Q. Can I auto-number my rows?

Yes you can, but you will need to be comfortable with adding some code.  Please read this very good article here “Numbering rows in a LiveCycle Designer table or repeating subform” which also has a sample file.

I’d like to do a video on this, but due to time limitations, I wont make promises I can’t keep.

Best Wishes

Steven

Ted Talk- “This is what happens when you reply to spam email”

A Ted talk to lighten your day: James Veitch: This is what happens when you reply to spam email. I usually recommend deeper technical or data oriented TED talks. This one is fun and good place to start with TED talks.

Fresh OneNote resources for Schools

Always looking for new uses of OneNote and found two that I’d like to share with you.

Free eBook for teachers: “Liberating Genius: The First 20 Days” by Angela Maiers – which is an e-book using OneNote as its “host”. This has got me thinking about going beyond my current use of OneNote as a scrapbook for course resources to using it for courseware.

College prep planning resources and virtual event for students use OneNote as a resource to support an online session. Its aimed at american students going to college, but its worth Australian and other schools getting a copy to explore the approach.

Power BI Windows 10 universal app and Power BI Desktop update

As people may know I am currently doing the Data Analysis course via Duke University and Coursera. While I am my data kick I am keeping track of news of new and updated tools. And so I have two bits of news:

Microsoft has released an update for Power BI desktop and also a universal app (to suit Windows tablets, phones and PCs). I will explore these tools further after I have complete the current module of the data analysis course.

Office 365 Tools for Lawyers and Legal Professionals

Broadening the base of potential Office 365/SharePoint Online users is the Legal Matters Center for Office 365. I attended an early session on this at the Ignite conference in Chicago.

Resources can be found at: