I have a membership database which includes a fees payments table with an element recording the year that a payment relates to. The membership year runs from 1st May to 30th April. While payments are usually for the current year or for the year that will commence in a few weeks time, this is not always the case, so the person administering the database has to be able to choose which membership year to assign each payment to.
The field uses the dropdown plugin, which works well except for one point which could be improved. For the sake of convenience, I set a default value for the dropdown corresponding ti the year that most new payments will relate to. As things are, this can only be done from the back end. It would be good if the person using the database was able to set the default from the front end, but I can't find any way of enabling this (they are able to add new years to the dropdown, but not new defaults).
Alternatively, if that isn't possible, is there any way that some php code could be used to automatically generate the values for the dropdown list (presumably quite easy to generate a list of the required years, both before now and in the future) while also generating the default? I suspect not, as the default is stored in the params field in the fabrik_elements table ("sub_initial_selection").
It's obviously no big deal for me to edit the default once a year, I'm really just curious as to whether there's a way to enable the front end or to automate it.
The field uses the dropdown plugin, which works well except for one point which could be improved. For the sake of convenience, I set a default value for the dropdown corresponding ti the year that most new payments will relate to. As things are, this can only be done from the back end. It would be good if the person using the database was able to set the default from the front end, but I can't find any way of enabling this (they are able to add new years to the dropdown, but not new defaults).
Alternatively, if that isn't possible, is there any way that some php code could be used to automatically generate the values for the dropdown list (presumably quite easy to generate a list of the required years, both before now and in the future) while also generating the default? I suspect not, as the default is stored in the params field in the fabrik_elements table ("sub_initial_selection").
It's obviously no big deal for me to edit the default once a year, I'm really just curious as to whether there's a way to enable the front end or to automate it.