AlexWong
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
Webhook for Deleting Multiple Attachment File
Hi All, I am new for the Webhook / API. I would like to create a webhook to delete attachment for a portion of the records. A new field called "Webhook Trigger" is created (containing 0 or 1), to determine which records should trigger the webhook. By referencing this discission (Automatically Delete File Attachments Upon Data Change), I have created below Webhook for modified records with "Webhook Trigger" = 1. HTTP method: POST Message format: XML Message header: QUICKBASE-ACTION API_EditRecord <qdbapi> <usertoken>xxxSAMPLE_USERTOKENxxx</usertoken> <rid>[Record ID#]</rid> <field fid="189" filename="delete"></field> </qdbapi> However, it only works for the first record, and no effect for the rest of the records. Is there any other way so that multiple record deletion of attachment can be performed? Thanks so much! ------------------------------ Alex Wong ------------------------------Multiple Record Version Showing Individual Record Changes
Hi all, I am now setting up a notification with condition of "any field changes", with showing the copy of the record changed (%recData%). However, is it any alternative to show the changed field information in multiple record version? As I found "%recData%" is not applicable in multiple record version. Thanks so much. ------------------------------ Alex Wong ------------------------------Multiple Record Version Showing Individual Record Changes
Hi all, I am now setting up a notification with condition of "any field changes", with showing the copy of the record changed (%recData%). However, is it any alternative to show the changed field information in multiple record version? As I found "%recData%" is not applicable in multiple record version. Thanks so much. ------------------------------ Alex Wong ------------------------------Distinct Count in Stacked Bar Chart
Hi all, I have just successfully built a summary report by having distinct count with an artificial batch key (i.e. customer ID + date). For summary report, i could utilize the summarize data section. However, in Stacked Bar Chart, in section "Data values on y axis", only numeric type field could be selected. Is there any alternatives to show the distinct count of a batch key in stacked bar? Thanks for the help. ------------------------------ Alex Wong ------------------------------Distinct Count in Stacked Bar Chart
Hi all, I have just successfully built a summary report by having distinct count with an artificial batch key (i.e. customer ID + date). For summary report, i could utilize the summarize data section. However, in Stacked Bar Chart, in section "Data values on y axis", only numeric type field could be selected. Is there any alternatives to show the distinct count of a batch key in stacked bar? Thanks for the help. ------------------------------ Alex Wong ------------------------------Showing only a latest text in summarized text field
Hi everyone. I would like to search for a method to achieve showing only a latest text in a summarized text field. For the background information, there are 2 tables with relationship, parent table A and child table B. In parent table A, I have created a summarized field with function "Combined Text". It is a field showing status (Approved/Denied) field from child table. However, since my child table B is a ticket table, there is a possibility that the issue is denied at first but approved finally. Is there a way for me to show the latest status in summarized field in parent table A. Parent table A (Summarized field) Child table B (Records) Thanks so much for the help! ------------------------------ Alex Wong ------------------------------Re: Power Bi connection failure
Thanks xiaonan for mentioning this. I have also experience the same missing "sortBy" field issue for Power BI connection only starting from today. Since there are no any field called "sortBy" in my tables, seems it is a connector issue rather than a personal issue. Hope QuickBase could solve this issue soon. ------------------------------ Alex Wong ------------------------------
