vi-solutions
Software + Internet

Joomla 5 Notice

We are pleased to announce that as of January 29, 2024, all of our Joomla extensions are compatible with Joomla 5.

For all who are still updateing from Joomla 3 to Joomla 4: Joomla 4 Migration instructions are available here:

There is now a separate Documentation for Visforms for Joomla 4 and for Visforms for Joomla 5!

Forum

Visforms Subscription user can ask questions in our forum. Please log in with the relevant user first.
Everybody can access the forum for reading.

Please only ask 1 question per topic.

Important information for almost every question:
V1: Which Visforms version is running?
V2: Which Joomla version is running?
V3: Which PHP version is running?

Display number of records

More
4 weeks 45 minutes ago - 3 weeks 4 days ago #11749 by PFS_hansi
Display number of records was created by PFS_hansi
I want to display the number of records from the form with ID 2 and with fieldID 29 = "My Headline"
How can I do this?

Code:
{vfdataview}{"formid":"2","fieldselect":{"29":"My Headline"},"count":"1","displaycounter":"true","sortorder":"created","sortdirection":"desc","show_page_heading":"false","showlabel":"false","layout":"list"}{/vfdataview}


rg
Hansis
Last edit: 3 weeks 4 days ago by PFS_hansi. Reason: Rechtschreibfehler

More
3 weeks 4 days ago #11750 by Administrator AV
Replied by Administrator AV on topic Display number of records
Hi Hansis,

The Data View plugin is used to display the records submitted for a form.
The plugin's configuration allows you to specify which fields the data is displayed for, how many records are displayed on a page, whether search filters are enabled, and similar settings.
The plugin cannot be used to aggregate data content.
For example, it cannot be used to count the number of records.

One way to achieve your desired goal would be:

- Create a new form
- This form has exactly one field of type Listbox SQL (and no submit button)
- Activate the 'Display as Data List' option in this field.
- Write an SQL statement that counts the number of records in the desired form for which the desired field is not empty
- Display this form using the Form View plugin in the same location where you are currently using the Data View plugin.

Regards,
Aicha
:idea: I recommend you the new and up-to-date documentation for Joomla 5:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 4.
Please only ask 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 5:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 4.
Bitte immer nur 1 Frage pro Thema stellen :-).
The following user(s) said Thank You: PFS_hansi

Moderators: Administrator AV, Administrator IV
Powered by Kunena Forum

Visforms Subscription

Visforms Extensions

Useful extensions for Visforms which enable you to integrate your forms perfectly into your website and to perform special tasks which turn Visforms into much more than just a form generator.

Info