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.

Redirect to the detail after form sent

More
5 months 5 days ago #10095 by Administrator IV
Replied by Administrator IV on topic Redirect to the detail after form sent
Hello gms,

1: it is possible to have the field pre-selected and hidden.

In the field configuration, tab 'Basic Options' you have to make the following settings:
Option 'Preselect solitary option' = 'True'
Option 'Hide when preselected' = 'True'

Your solution works well and is probably sufficient for you.

The solution with a 'Visforms Custom Plugin'
- would be the technically safe option and
- requires little code.

2: A technically safe option means here:

The next record ID to be assigned is fetched 'early'.
However, if the form is sent 'late', the next data record ID to be assigned may already be different because other forms have been sent by other users in the meantime.
In such a case, the redirection would be to another user's data.

In a 'Visforms Custom Plugin', however, you can access the data record ID that is actually used.

3: The secure SQL statement looks like this.
Code:
select ifnull(max(id),0) + 1 as label, ifnull(max(id),0) + 1 as value from #__visforms_[form-id];

This SQL statement also works for the very first submission of the form if there is no data in the data table yet.
In this case the SQL function max() would return 'null'.
And a 'null + 1' would also return a 'null', i.e. not 1 and there would be an error in the redirect URL.

SQL max() function with null values:
www.w3resource.com/sql/aggregate-functio...with_null_values.php
MySQL IFNULL() Function:
www.w3schools.com/sql/func_mysql_ifnull.asp

4: We think your requirement is a good addition to the existing options for a redirect as a simple configuration.

I have created an issue for development in the wish list:
Issue [VF-1004] Forum: Redirect after Form Submit: Add Option: Redirect to detail-view of submitted form data

When we release the new feature, you will be explicitly informed about the release here in the topic.
Thank you again for your contribution!

Kind regards, Ingmar

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

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-).

More
5 months 4 days ago #10098 by qms
Replied by qms on topic Redirect to the detail after form sent
Superb!!!
yes my solution is not technically save
but since only 1 user using  the form at any given time this is enough for now (might be changed in the future)
i still gonna play with custom plugin for a bit, though

Thanks for the outstanding support
i'm glad i choose this form

Cheers
 

More
5 months 2 days ago #10100 by Administrator IV
Replied by Administrator IV on topic Redirect to the detail after form sent
Thanks for your great feedback and you're welcome!
We try our best...

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

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-).

More
1 month 4 days ago #10474 by Administrator IV
Replied by Administrator IV on topic Redirect to the detail after form sent
Hello gms,

The options for forwarding actions on the 'Result' tab in the form configuration are already quite detailed and now also very flexible (see below).
A redirect to the detail view is a very specific requirement, others want a redirect to the edit view.

Instead of one or even many new options, the following new option can be used here.
All Visforms placeholders can be used in the 'Redirect URL' parameter.
This is much more flexible and at the same time keeps the configuration clear.

The new feature is included in the latest release from June 13, 2024 for Joomla 5:
Visforms 5.1.0
docs.joomla-5.visforms.vi-solutions.de/e...es/j5/version-5-1-0/
Visforms Subscription 5.1.0
docs.joomla-5.visforms.vi-solutions.de/e...5/sub-version-5-1-0/

What the URLs must look like is described in the documentation.
Redirect Options:
docs.joomla-5.visforms.vi-solutions.de/e...orm/redirect-option/

Best regards, Ingmar

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

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-).

Moderators: Administrator AVAdministrator IV
Powered by Kunena Forum