ContributionsMost RecentMost LikesSolutionsRe: Connected Table Auto Refresh More Frequently Please see both attached images, This is how I just set up the webhook(in Pipeline) and it works. I am not sure if you are missing anything. Thank you ------------------------------ Razi D. WEP Forms http://www.destatechs.com ------------------------------ Re: Connected Table Auto Refresh More Frequently Hi Aidon, You don't need Authentication, User Name and password in Pipeline Webhook request. You may want to add content type to headers. That should work. Please don't share your user token here. Thank you ------------------------------ Razi D. WEP Forms http://www.destatechs.com ------------------------------ Re: There was an error copying the records. Contact the application administrator with the error details below. Error Details: CopyMasterDetail does not allow looping relationshipsYou can add relfid to your formula as below "javascript:void(copyMasterDetailButtonHandler('&relfids=xx,yy,zz©Fid=6&destrid=0&sourcerid=" & [Record ID#] & "', 'bsixb4euj'))" and change xx, yy, zz to filed ids of report links field ids(You can find these in relationships). Try it with one of them at a time to see which relationship is causing issue. "javascript:void(copyMasterDetailButtonHandler('&relfids=xx©Fid=6&destrid=0&sourcerid=" & [Record ID#] & "', 'bsixb4euj'))" As Mark said you can always contact Quickbase support to get help. I hope this helps ------------------------------ Razi D. WEP Forms http://www.destatechs.com ------------------------------ Re: Alert or notification based on datetime field of another recordHi Matthew; You can add ToText() function to formula like below: var text recs=ToText(GetRecords("{'8'.OAF.'"&[Start Date and Time of Activity]&"'}AND{'8'.OBF.'"&[End Date and Time of Activity]&"'}", "aaaaaa")); if($recs="", true, false) Or you can do: var number recs=Size(GetRecords("{'8'.OAF.'"&[Start Date and Time of Activity]&"'}AND{'8'.OBF.'"&[End Date and Time of Activity]&"'}", "aaaaaa")); if($recs>0, false, true) ------------------------------ Razi D. WEP Forms http://www.destatechs.com ------------------------------ Re: Alert or notification based on datetime field of another recordHI Matthew; You can create formula check box in the table to see if there is any record conflicting: This formula will show if it is okay to create record for those time: var text recs=GetRecords("{xx.OAF.'"&[Start Time]&"'}AND{'xx'.OBF.'"&[End Time]&"'}", "aaaaaa") if($recs="", true, false) In this formula: xx= Field id of Start Time aaaaaa=Table Dbid() You can add more conditions to query above. After you create this field you can create form rule to prevent user to save record if this checkbox field is true. Or you can create notification to be triggered when record is added and this checkbox field is equal to checked. I hope this helps. ------------------------------ Razi D. WEP Forms http://www.destatechs.com ------------------------------ Re: Pipeline to Place a CSV file on a FTP Path?Good to know, Thank you Mark. ------------------------------ Razi D. WEP Forms http://www.destatechs.com ------------------------------ Re: Pipeline to Place a CSV file on a FTP Path?The other thing you may want to try is uploading file to Google drive. After file is uploaded you can trigger Google App Script to upload file to FTP. There are some script examples online or you can use Zapier: https://zapier.com/apps/easyftp/integrations/google-drive/913565/upload-new-google-drive-files-in-easyftp ------------------------------ Razi D. Desta Tech LLC razi@destatechs.com ------------------------------ Re: Pipeline to Place a CSV file on a FTP Path?Hi Mark; I don't think there is a channel for that. If there was, you would know it before us :) You may use ftp api in webhook or JSON handler(fetch JSON). There is a service and they have examples to show you how o use it. But I am not sure it is safe or goof to use. Link to site: https://www.ftp-api.com/ ------------------------------ Razi D. Desta Tech LLC razi@destatechs.com ------------------------------ Re: Using Look Up and Search in PipelinesHI, Look Up a Record returns only one record. This can be used for get values for field(s) of a record and you can used this record in next steps. Search Record may return multiple records and you can add step(s) or action for each record. I hope this helps. ------------------------------ Razi D. Desta Tech LLC razi@destatechs.com ------------------------------ Re: Query Question - search after dateIt is maybe happening because of parenthesis you have for query. Try this: Size(GetRecords("{6.EX."&[CustomerID]&"}AND{8.AF."&[Activity Date]&"}",[_DBID_ACTIVITIES])) ------------------------------ Razi D. Desta Tech LLC razi@destatechs.com ------------------------------