^\d{10}$
It is working perfectly thank you so much!!!
I want to hide regular expression formula part in mobile device.
How is calculation type of question can be build? I have not got it from the choice of drag panel.
Unfortunately, Epicollect5 does not feature any calculation question type we are afraid.
However, calculations can easily be added in the post-processing of data, using Excel or similar.
To add a calculation cell or column in Excel, you can use formulas to perform calculations based on other cells’ values. Here’s how you can do it:
- Single Calculation Cell:
Let’s say you want to calculate the sum of values in cells A1 to A5 and display the result in cell A6:
- Click on cell A6 where you want the result to appear.
- In the formula bar, type
=SUM(A1:A5)and press Enter. - The result of the sum of values in cells A1 to A5 will be displayed in cell A6.
- Calculation Column:If you want to create a calculation column based on existing columns, you can follow these steps:
- For example, let’s say you have numeric values in column B (B2 to B6) and you want to calculate their squares in column C (C2 to C6).
- In cell C2, type
=B2^2and press Enter. This formula calculates the square of the value in cell B2. - Click on cell C2 and hover over the small square at the bottom-right corner (called the fill handle). Your cursor will turn into a crosshair.
- Click and drag the fill handle down to copy the formula to cells C3 to C6. Excel will automatically adjust the formula for each row.
Remember that the formulas you use will depend on the specific calculations you want to perform. Excel offers a wide range of functions and operators to help you achieve various calculations.
Note: Excel operates in a similar way across different versions, but some features and options might be located in slightly different places based on the version you’re using.