Forum Discussion

KatherineOakey's avatar
KatherineOakey
Qrew Member
4 years ago

What am I missing with open email notification to an external Email field

The fields for the notification get changed (there are 3 fields with ANY/OR). The notification is permission 'open' Notify Whom is a Email field in the table. Message type is custom. I am ...
NotificationsEmail
Quickbase Automations
KatherineOakey's avatar
KatherineOakey
Qrew Member
4 years ago
I've done more poking...

Even though a Bulk Upsert block is being used, as long as it is nested in a For Each block I should be good with getting an individual record update and the resulting external Notification to an external user Email field?

I have 3 automations, two of which have run for this event but I can update the one that should run tomorrow morning and see what happens :)

------------------------------
Katherine Oakey
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
A Bulk Upsert will be a mass update, so you don't want that.  You just want to search the records for the qualifying records and then 

FOR EACH

do the update.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    The Automation  probably migrated in a way that was most efficient for QuickBase to process.  That would be to use the Bulk Upsert.

    But it will not meet your needs. So you will not be able to use the method that the migration tool suggested.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------