2022.2

l
Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending
(Z-A)order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnum-
bers,itwillbesortedasatext.
3. ClickFinishtoopenthedatabase.
Afteraddingdatafromadatabase,theData Modelpaneattherighthandbottomshowsthedatafields
thatoccurinthedata.
TheValuecolumndisplaysdatafromthefirstrecordinthedatafile.UsetheFirst,Previous,Nextand
Lastbuttonstobrowsethroughtherecords.
AddingJSONsampledata
JSONdatacaneitherbeadded to,orreplacetheDataModelinatemplate.
ToaddJSONsampledatatotheDataModel:
1. SelectFile > Add Data > JSON sample data,fromthemenu.Alternatively,clicktheJSON
Sample DatatoolbarbuttonontheDataModelpane.
2. Eitherbrowsetothelocationofthefileandselectit,orpasteorwritetheJSONdirectlyinthebox
belowthefilename.
Tip: IfadatafieldcontainsJSONdatayoucouldusethatdataassampledata:right-click
thefield,selectCopytocopytheJSONdatatotheclipboard;thenopentheJSONSample
Datadialogandpastethedatathere.
3. ReviewtheJSON;youmayedititifyoulike.
4. SelecttheReplace Data ModeloptionifyouwanttheJSONtoreplacetheexistingDataModel.
Otherwise,theJSONdatawillbemappedtocorrespondingfieldsintheexistingDataModel,and
datathatcannotbemappedtoanyfieldwillbediscarded.
5. ClickFinish.
Valuesareconvertedtotextstrings.IfavalueinarecordobjectisanotherJSONobject,it
isignored.
AddacounterusingtheGenerateCounterWizard
Generatingacounterisusefulfornumberedticketsoranyothertemplaterequiringsequentialnumbers
butnovariabledata.
TheGenerateCounterWizardcreatesarecordsetwithaCounterfieldandinthatfield,thecurrent
countervalueforeachrecord.TheCounterstartsandstopsatsetvaluesandisincrementedbyaset
valueaswell.
Page 306