2
Try this:
=IF(LEN([YourColumn])=9,IF(MID([YourColumn],6,1)=".",IF(ISNUMBER(VALUE((MID([YourColumn],1,5)))),ISNUMBER(VALUE((MID([YourColumn],7,3)))),FALSE),FALSE),FALSE)
First it validates if it's a 9 character string or not, then checks if the 6th character is a dot (.), then it validates the first 5 and last 3 characters.
Of course, it might be ...
2
You just need to concatenate items[i]['Title'] with items[i]['Job_Title'] at below line.
data.addRow([items[i]['Title'] +'</br>' + items[i]['Job_Title'],items[i]['Manager']['Title'],'']);
The Output based on my test
Unfortunately, the above change would work only for one level org chart, because the Goole Org-Chart code mainly depends on the Name ...
answered Jan 15 at 0:24
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
custom-list × 1431list × 230
sharepoint-online × 228
2013 × 196
sharepoint-enterprise × 162
sharepoint-designer × 151
javascript × 115
sharepoint-server × 89
list-view × 86
2010 × 84
workflow × 78
custom-form × 71
lookup-column × 56
calculated-column × 55
development × 53
sharepoint-foundation × 51
content-type × 50
infopath × 48
designer-workflow × 44
list-form × 44
document-library × 43
web-part × 40
permissions × 35
2007 × 35
column × 35