Workaround Update Col list plugin - update jdate element not working

[ontarget]

Joomla 4.4.10
Fabrik 4.2
Hi
I am trying to update a date element using the Update Col plugin. However it doesnt seem to function correctly.

Update Columns list plugin

This list plug-in allows your users to select multiple rows and update the values in one or two columns. Settings Access - Which user group can see the update column buttons Button label - The text for the update column button Button image - Image to use for button. Looks for the file in...

fabrikar.com

Settings:
Update: Mark Paid on (jdate element) to: undefined
Prompt: -
Allow user selection: = Yes
User selectable elements: = Mark Paid on (jdate element)

The popup shows the range filter instead of a single date element (range filter is enabled on the Mark Paid on (jdate element)).
The calendar icon does not trigger a date selector.
Setting the filter to "none" does then show a single date selector in the update col popup, however the calendar cannot be clicked.
See screen shot

 

[troester]

The popup shows the range filter instead of a single date element

This is a very old issue.

The updateCol (user select) popup is somehow using the Advanced Search setup.
Which won't do if your updateCol elements are also filter elements and the filter type is different to the "usual" element.

Additional issue with the jdate: Advanced Search is not working for jdate, so jdate updateCol userselect is also not doing even if it's no filter element.

Frustrating, but no fix found until now.

 

[ontarget]

Thanks for the reply.
Is there any other method of updating a date element value to the users required value (or any other element) without the user having to go through a multipage form and edit the value in the form?
I was originally using the inline edit plugin.
Thanks

 

[troester]

Inline edit was editing every single row, so you are not looking for batch editing?

You can create a list copy, reduce the form to the minimum (e.g. only the date element), add a redirect to the "full" list.
Add a custom link to this element which opens the reduced form.

I assume you can (depending on the element type) even activate "Submit on enter" in form settings or add JS to the element to submit on change (see e.g. https://fabrikar.com/forums/index.php?threads/autosave-record-on-change-field.55062/

 

[ontarget]

Inline edit was editing every single row, so you are not looking for batch editing?

Ideally batch editing would be best in this instance.
So the admin user could select a bunch of rows and set the mark paid element (jdate) to the date of their preference.
Any ideas if this is possible with any of the list plugins?
I was using inline editing originally as I couldn't get any other solution to work.

 

[troester]

Updatecol with jdate is working with some restrictions:

You can use the user select update popup (if element is no filter) and type the date (SQL format) into the field.

You can use jdate even as range filter if you use the updatecol "Prompt" option (also here the admins have to type the date string).

 

[ontarget]

You can use jdate even as range filter if you use the updatecol "Prompt" option (also here the admins have to type the date string).

This works a treat! Thank you!