Folks we all know how useful the "unread" badge icon on your telephone can be, I'd like to try and implement something like this into my FM SP database. 

I've a filter on the invoice list view that allows me to see any orders that need invoicing to the customer. 

The search criteria is:

OMIT = invoice posted = "1"
FIND = Quantity Remaining = "0"

I've tried to make a button on a button bar in the preferences layout using the same process as the tab formatting, namely: 

Let     (     [     number = Count ( T14m_preferences_INVOICES||id_constant::ID_Invoice ) ;     label = If ( number = 1 ; "Inv" ; "Invs" ) ;     findmode = "Invs" ;     size = 22 ;     color =  RGB ( 154 ; 154 ; 154 ) ;  // Grey     sizedNumber = TextSize ( number ; size ) ;     styledNumber = TextStyleAdd ( sizedNumber ; Plain ) ;     coloredLabel = TextColor ( label ; color )     ] ;     If     ( Get ( WindowMode ) = 1 ; findmode ;         styledNumber & " " & TextSize ( coloredLabel ; 13 )         )     )

I've associated the T14m table with the preferences using ID constants, so:

ID_Constant_Zero ("0") = quantity_remaining_total
ID_Constant ("1") NOT= Invoice_Posted

So far, the button just shows "INV ?" 

Feel like that link between the two tables isn't right. 

Anyhow, is there a better way to do this, say with pretty numbers like iOS has on it's icons? 

 

Thanks in advance. 

 

 

Hey jt,

This is one of those issue that would really benefit from a screen-sharing session, or a phone call at least.

Email me at [email protected], and we can schedule a time to take a look at this together.

Thanks,

Jonathan Hogle