Migration issues - Pro to Forte

[vario]

Two questions to begin:

1) I would like to customise subform WHERE clause so only records matching a date range are retrieved (rather than everything matching the PK). In Pro the SQL is on the Subform tab, but can't find it in Forte.

2) In Pro I used nuLoadEdit() to position the cursor at the first empty row (new record) of the subform. How do I do this in Forte?

Neil.

[kev1n]

Hi,

1) Click the 3 dots, then Form Properties and modify the SQL in the Tab Browse

form_properties.png

2) JavaScript under the Custom Code Tab of your Form:

Code: Select all

if(nuFormType() == 'edit'){
  // Your code here...
}

[kev1n]

to position the cursor at the first empty row (new record) of the subform. How do I do this in Forte?

Code: Select all

function setSubformCellFocus(subform, id, row) {
    if (row === undefined) {
        var r = nuSubformObject(subform).rows.length - 1;
    } else {
        var r = row;
    }
    $('#' + subform + nuPad3(r) + id).focus();
}


if(nuFormType() == 'edit'){
   // Replace accform with the Subform ID and slf_zzzzsys_form_idcode with the Object Id
    setSubformCellFocus('accform', 'slf_zzzzsys_form_idcode');
}

[vario]

Thanks for the reply.
One problem - there is no Browse tab on the subform. I have directly modified sfo_browse_sql in zzzzsys_form which so far seems to work but a user-friendly way would be good!

[kev1n]

It shouldn't be like that, it's a bug.

The workaround is to set the form type to "Edit". Then the Browse Tab becomes visible and the SQL can be edited. Afterwards, the Form Type can be changed back to Subform.

[kev1n]

That fix is now on Github.