Batch Access Level

Hi Visforms Team, 

Once again, thank you for a wonderful Joomla! product.

I was wondering if you could help me with something. I created a basic form with 88 fields that have (for example) front data-view Access Level 1. I then need to copy/create these fields into a second form that will then contain additional fields, for a total of 108 fields with Access Level 2. I then need to copy the form again twice more, with Level 3 (128 fields) and Level 4 (148 fields). 

Is there a way to batch change the access levels for all 384 new fields!!! I would absolutely hate to waste my time doing this manually. Or, is the only solution to create a plugin that will add a new batch process to the administrator menu for batch actions? If so, do you have any reference material as to how to do that?

Any help to cut down time would be greatly appreciated. 

Nelson

PS: May I suggest two things for upcoming Visforms versions:
(1) adding certain basic form actions that can be changed through the batch process in the administration area, such as, i) show label, ii) required, iii) read-only iv) front-data view access levels, v) edit-only fields to name a few; and
(2) adding access levels to each field individually, so that if I have a membership/subscription website, I can simply create one form that will only show fields that match the logged-in user's access level.

Hello LittleCloud,

I'm happy to hear, that you like Visforms.

At the moment, it is not possible to set field options easily for lots of fields at once with a batch process.
But I think this would be a great feature, which we will implement.
I have created a development issue for the feature wish list:
Issue [VF-952] : Add batch processes to set selected field options on multiple fields

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

Sadly just nobody thought about it earlier.

In my experince it is not possible to add a batch process by wrting a plugin.
I think this must be implemented in the Visforms code directly.

So, the only way I see to cut down time would be, to access the database directly (with phpMyAdmin) and execute some SQL Statements.
With regards to the data view access level this would be quite easy.
If you consider that an option, please let us know.
We could help you with the SQL Statements.

Thank you again for the contribution!

Regards,
Aicha

Hi Aisha, 

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

Thank you. I think it will make the product even greater! I appreciate your efforts in improving Visforms.

So, the only way I see to cut down time would be, to access the database directly (with phpMyAdmin) and execute some SQL Statements.

Thank you for the suggestion. I already started working on some SQL Statements. 

With regards to the data view access level this would be quite easy.
If you consider that an option, please let us know.
We could help you with the SQL Statements.

Yes, I would be very interested in finding a way to change a field's data view access level via sql statements. I hope we're talking the same language: I would love to know how to make one field AccessLevel1 while another is AccessLevel2 in the same form. This would help me out with my subscription-based website. I'd be able to go from 4 forms to 1!! If you already examples or snippets, I'd greatly appreciate it. 

Thank you so much for the reply.

Sincerely,
Nelson


 

Hi Nelson,

Maybe we were not talking exacty the same language.

There is a big difference between the form view and the data view.
In the form view, the access level is always the same for all fields.
The requirement to allow different access levels for different fields in the form view is quite specific.
Unfortunately, it doesn't fit well with other valuable Visforms features where there are dependencies between different form fields.
Such as the conditional display of fields and the calculation.
If fields are completely removed from the form because a user does not have access rights, then these features will no longer work.
There are no plans to allow field-level access for the form view.

In the data view, there is no dependency between different form fields.
That's why there is the option to set the access level for the data view at field level.

The planned feature development refers to the fact that certain existing field options can be set more easily via batch editing.

Kind Regards,
Aicha

Hello Nelson,

Issue [VF-952] : Add batch processes to set selected field options on multiple fields

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

Kind regards, Ingmar