In this post we learn about how to count records in omniscript data coming from dataraptor. With the help of formula.Let us take an example to get it done.
Example :- We create an omniscript , extract dataraptor as a datasource. As we get the record we use formula to count record coming from dataraptor.
Step:-1 Create an omniscript and drag a dataraptor to get records.
Also drag a formula field to count records, and a text block to make the record visible on the screen.
Create dataraptor and map all the fields that we want to get .
And select dataraptor on omniscript page.
map fields as shown in the below image.
Step :-2 Preview omniscript and see in which node record is coming.
An pass node in text block in %% sign ,to see record on page.
Step :-3 Add the formula field and write formula like this ..
IF(COUNT(%Account%)<=0,”0″,COUNT(%Account%))
Because record is coming in %Account% we use this.
Step :-4 Preview omniscript and see the result How much record has come.
If the dataraptor return zero record it show count zero.
