ContributionsMost RecentMost LikesSolutionsRe: Formula Text to format JSON for webhookSo this is all I could get from support. If anyone else wants to see JSON message as it is after the webhook fills in fields and sends it off go to uservoice and vote! I'm thinking if you want to make a formula field with JSON within it then it may be possible by adding these formats somehow but I'm not sure how to go about it ActionWorkFlows" : [ { "actionId" : 2, "active" : true, "cause" : { "queryString" : "", "triggerFields" : [], "triggerOnAllFields" : true, "typeId" : 1, "typeName" : "OnRecordChange" }, "description" : "", "effect" : { "format" : "JSON", "headers" : { "Content-Type" : "application/json", "api-key" : "XXXXXXXXXX" }, "isComplete" : true, "template" : "{\r\n \"to\":[22],\r\n \"replyTo\": {\"email\": \"email@email.com\", \"name\": \"Chuck\"},\r\n \"templateId\":1,\r\n \"params\": {\r\n \"balance\": \"[23]\",\r\n\"last_payment_date\":\"[24]\"\r\n }\r\n}", "typeId" : 3, "typeName" : "DoWebHook", "url" : "https://api.sendinblue.com/v3/smtp/email", "verb" : "POST" }, "label" : "Past Due Notice", "lastRunDate" : "2019-04-09 15:08:43", "lastRunDateMS" : 1554822523098, "owner" : "email@email.com", "when" : "a" Re: IOL and UserIDThe quickest way to get the userid but its not the full one, the .letters after it look like they can change but not sure if they only change per app? but in console you can type _fid_#.value where # is your user id field in the console and get it. so if you have some javascript running on page to run the add user to role you can grab it there but that value is the user id with the negative format so its not ideal.Re: Formula Text to format JSON for webhookYeah I opened a ticket and they referred me to here but my last message was to ask if I could see the message being sent. We'll see what they say. Thanks for taking the time to look into it with me!Re: Formula Text to format JSON for webhookIt did not like single quotes. I tried doing the entire json message with a static email and single quotes and it said invalid json so it requires double quotes it looks likeRe: Formula Text to format JSON for webhookYeah I saw a request to add what a webhook sends when it throws an error on uservoice so gave it 3 votes as that would be very very helpful. I'll try the quotes and if it works I'll follow up. Thanks for the suggestion!Re: Formula Text to format JSON for webhookHi and thanks for replying! I do have a comma and you are correct. The webhook error is in the log that says invalid json. If I paste the resulting text from the formula directly into the webhook it works fine. I've even tried generating the entire json mesage from a formula and that doesn't work either.Formula Text to format JSON for webhookI'm trying to make a JSON webhook sendinblue and for the emails to use I use a formula text that grabs all the emails related and formats them for the JSON like this [{"email":"me@example.com"}, {"email":"you@example.com"}] So the above is the result of the formula text and this is in my json like this. { "to":[EmailToJSONRemoveBlanks] } (Theres more to that JSON but the rest isn't relevant for this post) If I paste the raw result of the formula text into this it works fine but when I use this it says invalid json format. I'm not sure if the webhook is getting messed up with the array [] brackets and thinks its a field or what. Any thoughts?Re: Newbie - Parent to Child relationship formula issuesHow are you assigning the waves? Is there a dropdown on the Tours table like wave 1,2,3 and when you make a tour? If so then you could just go to the table-to-table relationship and create a summary field on the Parent side. Think default option is a Total of related records, then just make 3 more summary fields that do the same thing but add a filter that says if Tour - Wave = 1, then repeat for each wave. For importing you could import no problem. you just need to make sure you have a column called Related Presentation or whatever the field thats in the tours table that was created from the relationship. Then just put the ID of the presentation in that field for the various tours you have. Hope that helps.Re: Free script to send record values to mandrill email templates.The way it's set up you have to use buttons. Let me know if you would like any help. Chuck.SupportRe: How to construct a formula to calculate time from one record to the nextMake a summary field in Vehicles. For criteria summarize the Stop Time field and change from "Total" to "Maximum" Happy to demo if you're ok paying $1 for my contact info. earn.com/chuck