Fieldtype - variable select

pcsintjanbaptist

Hi there,

Let me sketch the situation first:
I have a building. In each building live multiple residents. Each resident can have one or more budgets. (They can also have no budgets)
I made an editable overview per building in which I summarise which resident spend which amount.

My problem:
I would like to link a budget to each expense (fieldtype: select), but stumble over the difficulty that each resident has a different list of budgets. I managed to update the budget list when I'm working with a pop-up (ajax), but inline-editing is a different story.
I'm currently working with the preOpen event but triggering the ajax that retrieves the budget list even when the budget list hasn't been clicked slows everything down. Is there a way to only trigger the ajax when the budget field has been clicked?

Thanks in advance,
Gloria

allan

Use dependent(). That will let you make an Ajax request whenever the host field has its value changed.

There is some more discussion about it here.

Allan

pcsintjanbaptist

Hey Allan,

That does indeed make the updating a lot easier, but that only answers a part of my question.

I would like to run certain validations during the preopen event but only when a certain column has been clicked (and only inline). Is there a way to check which column has been clicked within the preopen event?

Kind regards,
Gloria

pcsintjanbaptist

Update
I have tried using: editor.field().name()
This gives me the error "uncaught exception: Unknown field name - undefined".

When I change it to: editor.field('field_name').name()
The error is gone, but obviously, the only result I get is 'field_name', unrelated to the field I've clicked.

If I change it to:
editor.on( 'preOpen ', function ( e, mode, action ) {
console.log(editor.field(e).name());
}
The error changes to: uncaught exception: Unknown field name - [object Object]

If I change it too:
editor.inline(this, {
submitOnBlur: true,
submit : 'allIfChanged'
});
editor.on( 'preOpen ', function ( e, mode, action ) {
console.log(editor.field(this).name());
}
The error message remains: uncaught exception: Unknown field name - [object Object]

allan

displayed() is the method to use to get the field name of the field(s) displayed.

Can your data be invalid if it is already in the table?

Allan

pcsintjanbaptist

Hey Allan,

The displayed() code also doesn't work inside the preopen event.

So I did:

$('#myTable').on( 'click', 'td', function () {
    editor.inline( this );
    console.log(editor.displayed()[0]);
} );

It looks like this is what I need, except for the small detail that I only get the correct value when the editor hadn't been activated already.

If I jump from residents to price to budget, without deactivating the inline editor, I'll get the result:
'residents' - undefined - undefined

Could this be caused by my version of the editor? (1.7.2)

I was trying to use the preopen event to say that if there aren't any budgets for a certain resident, then the inline editor doesn't need to activate.

Thanks in advance !

pcsintjanbaptist

Update
I found this page: link
And noticed this part of the code:

//  var fieldName = e.currentTarget.s.includeFields[0];
var fieldName = editor.displayed();
fieldVal = eval(`this.field("`+fieldName+`").val()`);

The strange thing is; e.currentTarget.s.includeFields[0] does give me the result I need. editor.displayed() does not.

So I'm going to asume that I have an outdated version of the editor script and simply go along with the e.currentTarget.s.includeFields[0] (which works for me).

Thanks for your help