Badges on TABS

Jacques TUR Ho dumb am I :-).  Set it up and it's working but......

Using this:

if count(NOTES) > 0 then
    function onUpdate(event : any) do
        {
            caption: "LOCATION NOTES",
            color: "#7e7e7e",
            backgroundColor: "#00000",
            tooltip: "Here you can see all notes related for this location only.  ",
            badge: {
                caption: "",
                color: "#00000",
                backgroundColor: "#ffffff"
            }
        }
end;
    true
end

Screenshot:

Doing it this way the TAB is hidden if there are no records in the view which prevents the addition of a note (via + create record) should one be needed.

Is there anyway to have it so that the TAB is always displayed with the badge only showing if there are in fact records in the view.  I have created a formula on the form that counts records but of course this does not help since the TAB is visible ONLY if there are records.

Jacques TUR Thanks - I tried this but the badge does not work if there is a note.  As you can see here there is 1 Loc. Note as per the formula top left.  The TAB however does not display the badge.

Code:

function onUpdate(event : any) do
    if count(NOTES) > 0 then
        {
            caption: "LOCATION NOTES",
            color: "#7e7e7e",
            backgroundColor: "#00000",
            tooltip: "Here you can see all notes related for this location only.  ",
            badge: {
                caption: text(count(NOTES)),
                color: "#00000",
                backgroundColor: "#ffffff"
            }
        }

    else
        {}
    end;
end;

true;

Jacques TUR Thanks for getting back to me - tried your code and now the table/records will not load at all.  All other tables load as per normal but the LOCATIONS table remains like this:

Getting there, your code displays '1' regardless of whether there is a note or not.  In other words if there is no note(s) '1' still shows.  Remember I am displaying a table under the LOCATION NOTES TAB.

In your code I do not see how the count of records in the LOCATION table is being retrieved.

function onUpdate(event : any) do
    var badge := if 1 > 0 then
            {
                caption: text(count(1)),
                color: "#FF0000",
                backgroundColor: "#FFFFFF"
            }
        else
            {}
        end;
    {
        caption: "LOCATION NOTES",
        color: "#7e7e7e",
        backgroundColor: "#FFFFFF",
        tooltip: "Here you can see all notes related for this location only.  ",
        badge: badge
    }
end;
true

Jacques TUR Hi there, sorry for delay.  For some reason I was blocked from posting.  I have sorted the problem out but I did notice that the 'count' does not actually count as such.  Regardless of the number of notes '1' is always reflected.  Because of that I have amended the code to this:

function onUpdate(event : any) do
    var badge := if count(NOTES) > 0 then
            {
                caption: "",
                color: "#FF0000",
                backgroundColor: "#FFFFFF"
            }
        else
            {}
        end;
    {
        caption: "LOCATION NOTES",
        color: "#7e7e7e",
        backgroundColor: "#FFFFFF",
        tooltip: "Here you can see all notes related for this location only.  ",
        badge: badge
    }
end;
true

It would be nicer to have an actual count of the notes but it's not critical.

Thanks