ContributionsMost RecentMost LikesSolutionsGrid Edit and API_ImportFromCsv too fast for Webhooks?I am populating a table with API_ImportFromCsv (which is very fast), and I need to execute some complex table interactions on those records after they are entered. It seems like Webhooks and Quick Base Actions will only act on the first row of the import and ignore the rest. I have also tested Grid Edit on this table -- causing a change to many records at once -- and again, Webhooks and Actions seem to only react to one row. I know those (Webhooks/Actions) triggers can only fire up to 10 or 20 times per second. Am I right in thinking that a different technique will be needed, in order to execute logic on my very quickly created records? ------------------------------ Jeffrey Pierce ------------------------------ Re: Automation or Action or whatSteve, If it seems to you like the check box change is NOT triggering the automation like you expect it to, I can attest that this doesn't work for me either. I've had a couple of cases like this, and had to resort to a work around. Instead of checkbox, I used a Text Field with a two-choice list: Y or N. Changing the state of that Text Field using the pick list triggered the automation I wanted. ------------------------------ Jeffrey Pierce ------------------------------ Automation: Trigger on Summary Field ChangeI want to trigger an automation in a parent table, when the number of its children changes. I am using a summary of field, basically "# of children", and I have named that field in my trigger definition "When any of the following fields change:" I can add and drop children, and the summary field (number) reflects that change, but automation does not seem to get triggered. Shouldn't this work? ------------------------------ Jeffrey Pierce ------------------------------ How are lookup fields stored in a child table?When a child table has a lookup field added, does the parent data in that field get duplicated and stored in the child table, thus enlarging the child table by the full size of the looked up data? Or is there just some kind of "pointer" stored in the child table, which enlarges the child table to a much lesser degree?#Relationships #tablespace #Lookup ------------------------------ Jeffrey Pierce ------------------------------ SolvedRe: Font CSS on built-in form is different in one placePer support, this is a known bug:Bug ID: QBE012126. Bug fix is in the works. ------------------------------ Jeffrey Pierce ------------------------------ Re: Font CSS on built-in form is different in one placeTicket entered. Thanks to Austin K and Everett Patterson for confirming this observation. ------------------------------ Jeffrey Pierce ------------------------------ Font CSS on built-in form is different in one placeOn all of my basic "Main Forms", the Section Heading fonts all look like this: I think those Section Headings are displayed in the font "Gibson-SemiBold". Here is the CSS for those strings. body.UXV2 .WithToggleSections .sectionTitle { cursor: pointer; vertical-align: middle; font-size: 16px; font-family: 'Gibson-SemiBold', Helvetica, Arial, Sans-Serif; On just one form, the fonts look like this: Those section headings seem to be HelveticaNeue-Roman, per the CSS: body.UXV2 .WithToggleSections .sectionTitle { margin-left: 0; cursor: pointer; vertical-align: middle; font-size: 18px; font-family: "HelveticaNeue-Roman", "HelveticaNeue", "Helvetica Neue", "Helvetica", "Arial", sans-serif; I created a new form from scratch, and it still looks like this, with blue Helvetica headings. Oddly enough, the preview displays as expected with the Gibson font. Not a fatal problem, but ... can I fix this? ------------------------------ Jeffrey Pierce ------------------------------Re: Long-distance relationships; or secondary keysHere's how I resolved this, for now. One automation: when a record is added to Offer Block Members, then ... Action 1: Copy records from Grouped Items to Offer Block Data where Grouped Items.Group ID matches Offer Block Members.Group ID Action 2: Modify records: Insert Offer Block Items.Offer Block ID into Offer Block Data.Offer Block ID where Offer Block Data.Group ID matches Offer Block Members.Group ID and Offer Block ID is blank I'd like to tighten up the Filter criteria for Action 2 to avoid two users cross-populating each other's records, but so far matching on Record Owner (me) isn't working as expected. Thanks for reading ... ------------------------------ Jeffrey Pierce ------------------------------ Long-distance relationships; or secondary keys Imagine an Offer Block (part of an advertisement on some kind of page) which contains a Long Sleeve Shirt Style and a Short Sleeve Shirt Style; but each Style is really a Group consisting of many individual sizes and colors of that Shirt Style. I have modeled it as shown above, with two many-to-many relationships. Individual Items (at the SKU or barcode level) are grouped into one or more distinct Groups. Groups appear in various combinations in Offer Blocks. I am satisfied with how this is presented in the interface. Problem is: I want to be able to deliver data in two dimensions (one table) where Offer Block ID, Group ID, and Item ID (and their associated details) are all on one row (Offer Block Data). I could not think of any automation or relationship available that will do this. Am I missing something? ------------------------------ Jeffrey Pierce ------------------------------