Page 1 of 2

Browse Tricks, Roster

Posted: Tue Nov 12, 2019 12:28 pm
by markzeryk
Hi,

Thank you for this roster video.


Question: The roster (background colors) disappear when hovering over a row. Can we disable that?
hover.png

Re: Browse Tricks, Roster

Posted: Fri Nov 15, 2019 4:09 am
by admin
markzeryk,

You could remove !important from the stylesheet.
Capture.JPG
Steven

Re: Browse Tricks, Roster

Posted: Fri Nov 15, 2019 7:26 am
by markzeryk
Yeah, that's fine, but then it's gone for all the forms

Re: Browse Tricks, Roster

Posted: Fri Nov 15, 2019 8:06 am
by admin
markzeryk,

You're a hard man to please.

Maybe someone else on the forum has a better answer.

Steven

Re: Browse Tricks, Roster

Posted: Fri Nov 15, 2019 8:35 am
by kev1n
Hi,

Add this Javascript in the form's custom code field:

Code: Select all

if( nuFormType() == 'browse') {  
   $("[id^=" + 'nucell_' + "]").unbind('mouseenter mouseleave');
}   

Re: Browse Tricks, Roster

Posted: Fri Nov 15, 2019 8:58 am
by kev1n
In addition, if you want to underline a cell when your mouse hovers over a cell, use this code:

Code: Select all

if( nuFormType() == 'browse') { 
   $("[id^=" + 'nucell_' + "]").unbind('mouseenter mouseleave');
   
   var element = document.createElement('style');
   element.setAttribute('type', 'text/css');
   element.textContent = ".nuCellEven:hover {color: hotpink;} .nuCellOdd:hover {color: hotpink;}";
}   

Re: Browse Tricks, Roster

Posted: Mon Dec 09, 2019 5:01 pm
by markzeryk
admin wrote:markzeryk,

You're a hard man to please.

Maybe someone else on the forum has a better answer.

Steven
Yeah, I guess that's my fault. I am a perfectionist

Re: Browse Tricks, Roster

Posted: Tue Jan 19, 2021 1:23 pm
by miasoft
Hello all!
I try Roster-example and I can't save my new roster's record. If I add records to Staff or Clients all is Ok.
Is this correct ?

Re: Browse Tricks, Roster

Posted: Thu Jan 21, 2021 8:50 am
by kev1n
Hi,

Saving works fine for me. To be able to help you, we need more details. Like screenshot(s), error messages etc.

Re: Browse Tricks, Roster

Posted: Thu Jan 21, 2021 5:10 pm
by nac
Hello miasoft,

It is worth making sure that your view is updatable (in case you created something slightly different to the example and you are trying to save data on a form that uses a view as the source). Try running this query:

Code: Select all

SELECT TABLE_NAME, IS_UPDATABLE FROM VIEWS WHERE TABLE_SCHEMA = 'mydatabasename'
to show all the views in the database and which of them are updateable.

Neil