nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to use data on a ConfiForm to update hidden fields prior to Save

Kathleen Janiszewski_e5imvw

I have 52 hidden fields on this form (but not hidden on the TableView macro). I allow the user to edit the data using an Edit Control on a TableView macro. I want to update the data in them with the data in the weekly hours BEFORE the form is actually submitted, basically at the beginning of the onclick event. I have tried using the setValuefunc() on the 3 form definition macros, but that didn't work. I need a function that will run when the user clicks Save. I have tried the Run custom JavaScript after the form is loaded on the ConfiForms (FormView) Registration Control Macro, but that does not work. The 3 fields I need for my calculations are below:

ConfiForms Sample.PNG

In this case, I want to update weeks 9 thru 17, inclusive to be 15, leaving the rest alone. I can write the JavaScript to fill in those hidden fields, but I need to do my calculations when the use clicks Save but before it gets stored. (I have already tried the IFTTT macro, but it doesn't keep the TableView macro updated.) What options do I have?

Accepted answers

All comments

Alex Medved _ConfiForms_

You can set up rules that work on field changes (bound to field) and run a JavaScript function(s) you can develop

https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Field+Definition+Rules#ConfiFormsFieldDefinitionRules-RuncustomJavaScript

Alex

Kathleen Janiszewski_e5imvw

I've tried doing that using the setValueFunc(formName, formId). I first used the same function for all 3 fields, then 3 different functions with similar names in the above format. However I need it to work when the Save button is clicked. If the runs when the field is changed, it won't work correctly. For example, if I change the hours, depending on how quickly I change the other 2 fields, it will set the scheduled hours for the values in the previous date range, or for the first week, but until the end of the year. Sometimes it will work, but not always. I need it to work every time.

Alex Medved _ConfiForms_

ConfiForms does not have an extension point to run before the submit

Field Definition Rules execute on field value changes. But may be you can hook up to the form's on submit event with custom JavaScript

Running it on form-view (Registrations Control macro) initialization ("Execute custom JavaScript function after the form is loaded" parameter)

Kathleen Janiszewski_e5imvw

Alex,

I tried that with a function called customUpdate(formId). I can get the formId, but when I use it to try to get the "#i_weeklyhours", "i_startweek", and "i_endweek", using jquery, those 3 values come back empty. My assumption is it's executing the submit has already occurred before this is function is called. I tried to hijack the onclick for the Save button, but was I not successful. Do you have a way for me to do that?

I know I'm pushing the limits of ConfiForms.

Thank you again.

-Kathleen

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms