GrantSmith Coach 
-
Re: Add Grant Access button to pages for Admins
Alternatively just allow admins to automatically load into the page without having to request access or have it added to the page list.2 -
Re: Year = current year
Some minor tweaks to your beast mode: CASE WHEN YEAR(`Booking Year Nbr`)= YEAR(CURDATE()) THEN "CY" ELSE "PY" END3 -
Re: Can Admins Manage Other Users Notification Settings?
Currently no, only the user can modify their own notification settings. That'd likely be a good idea to submit to the idea exchange to give admins more control of notifications.2 -
Re: understanding null vs blank or empty string values
CASE WHEN COALESCE(TRIM(`field`), '') = '' THEN 'Blank' ELSE 'Not Blank' END COALESCE will return the first non-null value it finds, used in this case it'…2 -
Re: MySQL Join Optimisation - 2 hours, for what should take seconds!!
Have you used an SQL transform to add indexes to your two tables on id, id2 and date fields? Alternatively have you used the new MagicETL as that will be much faster.2
