Is there a common list of requested Expressions available?

Question

The Support desk must get asked how to do certain expressions all of the time. Do you have a list of these available?

Answer

Following the expressions webinar on 10th June 2016, we have created the following page for expressions to be made available that get asked for consistently. We will continue to add to this as we go along.

Explanation

Date Added	Region	Relevant Data	Expression	Example Output	Description
13th June 2016	UK and ASTM	Date	now()	13/06/2016 11:26:33	Displays the current date and time in the format specified on the local machine by its regional settings.
13th June 2016	UK and ASTM	Date	text(now(),'dd MMM yyyy')	13 Jun 2016	Displays the current date in UK format with the month written as its 3 letter abbreviation.
13th June 2016	UK and ASTM	Date	text(now(),'dd MMMM yyyy')	13 June 2016	Displays the current date in UK format with the month written in full.
13th June 2016	UK	Date	text(now(),'dd')+if(in(text(now(),'dd'),1,21,31),'st',if(in(text(now(),'dd'),2,22),'nd',if(in(text(now(),'dd'),3,23),'rd','th')))+' '+text(now(),'MMMM yyyy')	13th June 2016	Displays the current date in UK format with the month written in full.
13th June 2016	ASTM	Date	text(now(),'MMMM dd')+if(in(text(now(),'dd'),1,21,31),'st',if(in(text(now(),'dd'),2,22),'nd',if(in(text(now(),'dd'),3,23),'rd','th')))+' '+text(now(),'yyyy')	June 13th 2016	Displays the current date in US format with the month written in full.
13th June 2016	UK	Water Strikes	if(find('no water',text([WaterStrikeGeneral.Remarks]), 0)>-1,'Arrow','Circle')	Circle or Arrow Symbol	Shows a Circle if 'no water' appears in remarks, if not show an arrow.
13th June 2016	UK	Water Strikes	if(count([Aggregate.WaterStrikeGeneral.DepthStrike])=0,'No Ground Water Encountered','')	No Ground Water Encountered	Queries whether there are any water strike records in the location, if there are not any then will display No Ground Water Encountered.
13th June 2016	UK	SPTs	'N='+if([SPT.NValue]<51,text(fixed([SPT.NValue],0,false)),if([SPT.NValue]<1000,''+text(fixed([SPT.NValue],0,false)),'*'+text(fixed([SPT.NValue],0,false))))	N=25 N=145 N=*1000	Calculates whether the N value falls within certain ranges and prefixes a value depending on these ranges.
13th June 2016	UK and ASTM	Locations	if(len(text([LocationDetails.LocalXGrid])) > 0,'Local Grid','National Grid')	Local Grid National Grid	Displays whether a local grid or a national grid is being used in the project.
13th June 2016	UK and ASTM	Locations	if(len(text([LocationDetails.LocalXGrid])) > 0,'X'+text(fixed([LocationDetails.LocalXGrid], 2, false)),'E'+text(fixed([LocationDetails.Easting], 2, false)))	X123.45 E124555.56	Displays the local grid coordinates if used in a project, if not then show the eastings.
13th June 2016	UK and ASTM	Locations	if(len(text([LocationDetails.LocalYGrid])) > 0,'Y'+text(fixed([LocationDetails.LocalYGrid], 2, false)),'N'+text(fixed([LocationDetails.Northing], 2, false)))	Y123.45 Y123455.67	Displays the local grid coordinates if used in a project, if not then show the northings.
13th June 2016	UK and ASTM	Locations	if(len(text([LocationDetails.LocalLevel])) > 0,'Site Datum','Ground Level')	Site Datum Ground Level	Show whether a Site Datum was used on this project or a standard ground level.
13th June 2016	UK and ASTM	Locations	if(len(text([LocationDetails.LocalLevel])) > 0,if([LocationDetails.LocalLevel] > 0,text('+'),'')+text(fixed([LocationDetails.LocalLevel], 2, false))+'mD',if([LocationDetails.GroundLevel] > 0,text('+'),'')+text(fixed([LocationDetails.GroundLevel], 2, false))+'mOD')	123mD 123mOD	Displays the local ground level value if used, if not then use the national one.