Difference between revisions of "Drupal/C3/Table-of-Fields-with-Views/English"

Table of Fields with Views

Learning Objectives

• Create a table of fields

System requirement

• Ubuntu Linux Operating System
• Drupal 8 and
• Firefox Web browser

You can use any web browser as per your choice.

Suppose we want to display a list of future events in a table like this.

Here, a user can see some details of the events and their respective dates.

The fields shown here are there in the Events Content type.

Here we display only some of the fields of some of the events.

In particular, we display only events that have dates after the current time.

Such a selected list of content is also called as Reports or Query Results, in other programs.

Let us now create a view for a table of fields.

Go to Shortcuts, then Views and click Add new view.

Now change the Content of type All to Events.

We can do this for any Content type –

Log entries, Files, Content revisions, Taxonomy terms, Users, Custom blocks and so on.

Put a check on Create a page.

And in the Display format, choose Table of fields.

We will keep the default value of 10 in Items to display.

Under Menu, we will choose Main navigation.

And we will call the Link text as Upcoming Events.

• The Display is a page.
• The FORMAT is a table.
• Under FIELDS, we have Title.
• In the FILTER CRITERIA we only want Upcoming events, so we will need to change that.

We have the Path, the Menu, the Access Permission.

And now everybody will have access to the landing page.

We can add a HEADER or a FOOTER by clicking on the Add buttons here.

We can add what to do if there are no results.

And whether there’s a pager at the bottom or not with the Read More link at the bottom of View.

We’ve already connected Events and User Groups.

So, we can actually

• pull in information from User Groups that are sponsoring our Events
• and put them in this View.

This is done by using the RELATIONSHIPS and CONTEXT that we created.

I label my fields very carefully using the Content type name.

So, I can find them easily in Views later on.

Here we will choose some of the settings.

Let’s leave the Date format as default here; in other words medium date.

Don’t worry about any of those right now.

And lastly, click Apply [all displays] button.

And this time scroll down until you find Event Logo.

Let’s choose an Image style of Thumbnail.

Then under Link image to dropdown, choose Content.

But for now, we will choose Thumbnail.

Now, in the preview, we should see the thumbnails that have been generated by devel, for each Event.

This time, scroll down and choose more than one field at a time.

And then click on Apply [all displays] button.

Notice that now we can set up 2 fields at once in Views.

And each one will have its own Settings screen.

We have our title, date, topics and website.

Let’s click on Save. It’s a good habit to save your work frequently.

• Our Display is a Page
• Our FORMAT is a Table
• Our FIELDS are set
• The FILTER CRITERIA and SORT CRITERIA are still wrong.

Scroll down till you find Event Date.

Then, choose the Event Date, and click Apply.

Under Operator dropdown, we will select Is greater than or equal to.

We would then have to put in a new date everyday.

But we could choose An offset of the current time.

And in the Value field, type the word “now”.

This means only those events after the current time will be displayed.

The current time is not the time we are creating this.

It is the time when the user is viewing it.

So the user will only see the future events.

So, let’s manually update some of our events, to make sure our View works correctly.

Filter by Events Type.

Choose any event and click on Edit.

Then change the date to a future day.

Let's click on Save.

Find Upcoming Events. Click on Edit.

We will now go back to editing the view where we left off.

Scroll down to see the preview.

Next we must check the SORT CRITERIA.

By default, Drupal sorts the content by the date of authoring in decreasing order.

For Events it is useful to have the Event Date in ascending order.

Now, under Order, select Sort ascending. That sorts our events from today onwards.

Click Apply.

We should be able to see a listing that looks something like this.

Let’s combine the TITLE and Logo columns.

And then let’s make the TITLE and EVENT DATE sortable.

When we do this, a user can click on the TITLE and it will sort by that feature.

Locate FORMAT, Table.

And next to it, click on the word Settings.

In the Content Event Logo, change the COLUMN dropdown to Title.

For the SEPARATOR up here, just put a simple line break.

Click on the word Title and in the Label, change the word Title to Event Name.

Then click Apply.

Our Event Name and logo and date are all set.

Click on Upcoming Events.

You should see a table nicely laying out the events that are coming up only in the future.

Summary

In this tutorial we have learnt about

• Creating tables of fields

Acknowledgement

• adapted from Acquia and OSTraining
• and revised by Spoken Tutorial Project, IIT Bombay.

Acknowledgement

Pls download and watch it.

Spoken Tutorial Workshops

For more details, please write to us.

Acknowledgement

• NMEICT, Ministry of Human Resource Development and
• NVLI, Ministry of Culture

Government of India.

Thanks for joining.