ContributionsMost RecentMost LikesSolutionsRe: How do I create a button to initiate an email from Outlook?This works: // create 3 text variables then execute them in order // first variable holds the email address & content var text URLONE = "MailTo:" & URLEncode([EmailAddressFieldName]) &"?subject=TYPE YOUR SUBJECT HERE" &"&body=TYPE THE BODY OF YOUR EMAIL HERE, IF YOU INCLUDE FIELDS, DO IT LIKE THIS:� & URLEncode([FieldName]) & "MORE EMAIL BODY UNTIL YOU�RE DONE, THE NEXT BIT IS HOW TO CREATE CARRIAGE RETURNS IN THE EMAIL BODY:" &"%0A" // this makes a carriage return &"%0A"; //make sure to include the semicolon to end the variable declaration statement // this is a little bonus, it checks a box on the record that indicates you�ve sent the email (so you remember not to send it twice) var text URLTWO = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&" & "rid=" & URLEncode([Record ID#]) & "&_fid_91=1"; // this is the checkbox field ID, and you set it to equal 1, which is TRUE or Checked // this re-loads the page when you�re done var text URLTHREE = URLRoot() & "db/" & [_DBID_CAMPAIGNS] // replace with your table ID name & "?a=dr&rid=" & [Related Campaign]; // id of the table you�re redirecting to (the button on this case was on a child record, therefor the �related� part... // this �runs� the script: checks the box, then reloads the page, then sends the email, in that order $URLTWO & "&rdr=" & URLEncode($URLTHREE) & URLEncode("&rdr=" & URLEncode($URLONE)) Re: Webhook only works for 1st record added on Import of multiple recordsHi Evan, Given your suggestion (and Keith's example), is there a way to do this in JSON? The example is with XML. The body of our message is currently just the key:value pairs for data which we send to an external endpoint. What would be the syntax for JSON to implement the looping of the new records (it seems to be %Repeaton% and %Repeatoff% in Keith's example). Thanks, MichaelRe: Webhook only works for 1st record added on Import of multiple recordsHi Keith & Evan, Thanks for the suggestions. I'll pass these along to my developer and see if he can make it work. Best, MichaelRe: Webhook only works for 1st record added on Import of multiple recordsHi Evan, In that case, is there a workaround that would allow us to still import using the normal import/export UI in Quickbase? It seems like you're suggesting that we build our own import portal from scratch and use the ImportFromCSVmethod. What if the webhook was re-written to query the table's Date Created (Field ID#1) or Date Modified (Field ID#2), and get all the records that were just created in the last 1 minute (or some short time period). Then a separate script could loop through them and push them to the external API we're integrating with. In other words, the webhook triggers a query on that table, then collects the recently created or modified records (it may be just one or maybe several), and then pushes them out from there. What do you think? Does it seem like a good solution? Thanks, MichaelRe: Webhook only works for 1st record added on Import of multiple recordsHi Evan, To clarify, we're not doing a bulk movement of information. It just seems the webhook works for the first record, and not the other records when we import to QB. I think the webhook should fire for each new record added, but there's a rate limit on webhooks of 10 per second. I think this is why the webhook doesn't fire for the other records in the import. Do you know how to work around this rate limit when importing to QB, and the import creates a lot of records in a fraction of a second? (If that's even the problem.)Re: Webhook only works for 1st record added on Import of multiple recordsThanks Evan, I'll try that. Does it matter if the import is from CSV or Excel? I'm using the webhook to take the information and send it to an external service - does that make a difference using API_ImportfromCSV?Webhook only works for 1st record added on Import of multiple recordsI created a webhook that fires when a new record is added or modified in a table. When I add records one at a time, it works fine. But when I import multiple records to that table, it only works for the first record from the Excel, but not for the other records. (All the records do get imported correctly to Quickbase, so it doesn't seem to be an issue with the import function. Also, the webhook is not throwing any errors.)Re: webhooks doesn't work for all usersThanks Neil, I'll have them look into that!webhooks doesn't work for all usersI hired an outside developer to create an integration between QuickBase and WhenIWork. When the QuickBase user creates a new record (on a particular table), a webhook fires and creates a new record in WhenIWork (via their API). The integration works when the developer tests it. But it doesn't work when our users test it. Any ideas so I can point the developer in the right direction to fix this? Thanks!Re: How do I create a button to initiate an email from Outlook?Is it possible to embed a table of child records when creating an email like this?