This video I will tell you about adding fees and formulas in our art to get a table.
So here we have a simple article table with Mark statement of seven students and we'll use this table
in our example.
So I'll start with the field.
So using fields you can add intelligent information to add and those informations are updated automatically.
So in this case I'll add the filename which is a student score in this cell here.
So I select the cell and now as an engine select cell you'll notice this table cell tab which has this
field option.
So now from this insert panel select this field and this will open this feed window from here called
the field name drop down and select filename and now select the format so I'll select uppercase format
and select filename only radio button.
Now also make a sure that this and display file extension is unchecked.
We don't want the file extension and you can see the final preview here.
So we have the previous year.
Let's get going.
OK.
And now we have the field here.
You can see it quite clearly.
Students scored.
So although the field really appeared with this great background but when you plot your drawing the
gray background will not remain visible.
And this creep background has been added only to identify this field from rest of the text.
Now in this case you can clearly see that the field mentions students scored here.
So you can see that it's written as a in school.
If you change the file name the field will change automatically.
So in this case we have the student score.
Let's change it.
So I'll change the filename so I can see as I specify next stop as the location.
And now I'll add a card as a new text and let's conceive again.
And let's look at the feed.
And here we have a new field the student's score card.
So in this way it is automatically updated.
And we don't need to manually change the value here.
And if for some reason you are not able to update these fields then you can use r e e common to read
and read the complete drawing and the fields will be updated.
Now let's move to the formulas.
So in this case we can also use the formulas just like Aksel and using the formulas you can add the
information here.
So in this case let's say that we want to add total marks of all of these students in this cell for
that ulcerate the cell and I'll go to formula.
Now obviously we need to add the sum of all of these marks so I'll select some.
And now on the first cell from where you want to start calculation.
And the last cell.
So we want a sum of all of these cells.
And here we have it now click outside and we have the result here as a field.
So in this case you can see that the complete value is 5 0 4.
Now this is also a field as indicated by the gray background.
And if you change any of these values the field will update.
So in this case we have 5 0 for change any of these values so I'll change this text.
So we have 46 here.
Let's change it to 56.
Now click outside and let's look at the feed.
Now we have 5 1 4 instead of 5 0 4.
So the field is automatically updated.
And in this case also if your field is not updated you can use our e command to updated manually.
Now here we have an average marks.
Let's add that also so I select the cell.
Now I will go to formula and select average once again and click on the first cell and the last cell
and the average formula has been added outside and we have the average value here accurate up to the
decimal points which is specified in the current template.
So we have the average 7 3 point 4 2 8 5 7 1.
So that was all about adding fields and formulas in order at table.