Forum Discussion

StuLamden1's avatar
StuLamden1
Qrew Member
2 years ago

Notification Limitation?

I'm wondering if there is a notification limitation in Quickbase.  Both searching Quickbase resources and performing google searches has not turned up anything, so hopefully a little guidance from someone who knows more than me can tell me where I'm missing a step: 

I have two tables in an app.  All Other Inventory is the Parent and Employee Records is the Child.

1.    Employee Records – in this table our Help Desk can assign to an employee an inventory item such as an apple pencil along with the qty.

2.    All Other Inventory – in this table I have every Inventory Item listed, along with how many I have of each.  If an employee is assigned 1 Apple Pencil, then the total number in inventory is decreased by 1.  If I remove the apple pencil from the employee, the total number in inventory is increased by 1.  The math works, no matter what the item is, so we're good up to this point.

The issue that I'm running into is with the Notification that I created called Apple Pencil Inventory Low.  Here's the criteria:

Notification when an inventory item is modified.
AND when
Number of Items Available (this a Formula – Numeric Field, [Total Number Of Items in Inventory]-[Number Of Items in Use])
AND when the following conditions are true after the change:
all conditions are true
*Inventory is equal to the value Apple Pencil
and Number of Items Available is less than the value 5

Then a Custom message is sent out to a recipient (myself in my testing).

*Inventory is a field in the All Other Inventory Table that lists each item we have in Inventory, such as a Apple Pencil, Apple Keyboard, Mouse, etc.

My question is, because the field Number of Items Available is a Formula – Numeric field, and not Numeric, is that the reason why the notification will not work?  If so, is there a way around this?

Thanks in advance!

Stu



------------------------------
Stu Lamden
------------------------------

2 Replies

  • Notifications will only fire when a data entry type (Quickbase calls these "Scalar") field is changed.  So for example if a record becomes overdue at midnight tonight that will not trigger a flurry of notifications that some task on a project is overdue. 

    You have two options. One is to create a subscription report which you would receive every morning of inventory which is low. That is actually what I recommend. 

    If you actually want to know the second that inventory becomes low then you would have to set the notification up to fire when the employee record is changed. You would need to look up any totals you need from the parent inventory and trigger off that employee record being changed because that is where the data entry is happening.   



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
  • As Mark explained,notifications are triggered when records changed, and  the parent table doesn't actually experience a change when child data being aggregated to it is changed.
    It is a common requirement in many apps and some workarounds are discussed here



    ------------------------------
    Simon H
    ------------------------------