Deluge version history display Calcutta time instead of Europe
Hi, We are based in Germany, using the .eu servers. When looking at a deluge file history, time are displayed in Calcutta time. This not really relevant. We should have CET time for EU customers...
Dynamically Selecting and Updating Multiple Records
Hi All- I have a form ("Equipment Form") that contains multiple pieces of equipment of multiple equipment types from multiple locations. One field in this current form is a "Runtime Meter". I would like to provide a user the ability to select a location and equipment type (lookups), fetch and display the applicable current "Runtime Meter" and allow for that field and a "Meter Reading Date" field to be updated with a new meter reading. Essentially, the user will dynamically select, view current
Button in subform to refresh deluge script for updated response
Hi, I have an expenses form I've built that pulls live currency rates into it for each item in a subform (so items could all be in different currencies) and then makes a running total in our base currency USD (so GBP and EUR are all converted by Deluge into a USD total). Is there a way I can add a button "UPDATE" that runs the script again to refresh the values? I notice it always has to be on user input but sometimes I just want the user to be able to update each line in the subform via running
Filter LookUp Field
Hello, I would like to filter lookup field using Deluge i tried doing it using below code but it just clears the records in the field it doesn't filter the records. Code: for each rec in Product_Master[Units.contains("Mtr") && ID != 0] { match = count(Product_Master[Units.contains("Mtr") && ID != 0]); if(match>0) { input.Product_Master:ui.add(rec.Design_No); } } //Units is the Drop Down Field
ignore duplicates in for each
Hi, I am using the following programme to return values (Bin Numbers) and dates that have been used in the report. a = Collections[Bin_Number != "" && Site_Name.Customer_No == "WXH" && Date_Time > zoho.currentdate.subMonth(1)]; b = Master_Bin_List[Bin_Number not in a.Bin_Number.getall() && Site_Name.Customer_No == "WXH" && Ignore_in_count1 != "yes"].Bin_Number.getAll(); c = Collections[Bin_Number in b] sort by Date_Time desc; d = Master_Bin_List[Bin_Number not in c.Bin_Number.getall() && Bin_Number
Problem calling Writer from Books to merge and download
Hi, I'm building a function in Books which calls Writer to merge data into a document. I found zoho.writer.mergeAndDownload(<document_id>, <output_format>, <values_map>, <connection>) which is recognized in Books custom function editor. https://www.zoho.com/deluge/help/writer/merge-and-download.html
Refresh Authtokens generated by Zoho CRM
Hi, After some troubleshooting i ran into a problem. 1. I have a Zoho One account with the apps Zoho CRM and Zoho Books activated. 2. i went to https://accounts.zoho.eu/u/h#sessions/userauthtoken and there were no active auth tokens 3. i wrote a small custom function in Zoho CRM, where ofcourse the orgId and estimate_numbers where filled in with the correct values: info zoho.books.getRecordsByID("Estimates","orgId","estimate_number"); return "";4. The script returned the Estimate and it looked fine
自動で商談名を「取引先名＋様＋作成日付＋商品･サービス」にするコード
自動で商談名を「取引先名＋様＋作成日付＋商品･サービス」にするコード です。 需要あるか分かりませんが、必要な方お使いください。 例：「＊＊＊＊様 20200213 ワッペン」 関連タブ 商談 SHODAN_ID = 商談.商談のID 以下はDelugeコード dealDetails = zoho.crm.getRecordById("Deals",SHODAN_ID.toLong()); newdealname = ifnull(dealDetails.get("field19"),""); mp = Map(); mp.put("Deal_Name",newdealname); update = zoho.crm.updateRecord("Deals",SHODAN_ID.toLong(),mp); info mp; info update; 「 field19 」は カスタマイズ ＞ タブ＆項目 ＞ 商談 ＞ 項目 ＞ 商談名自動生成；数式（文字列） 「 field19 」の数式は「Concat(${商談.取引先名},'様',' ',Substring(Tostring(${商談.作成日時}),1,4),Substring(Tostring(${商談.作成日時}),6,7),Substring(Tostring(${商談.作成日時}),9,10),'
Unable to use HTML email in a Custom Function using Deluge sendmail[]
Hi, I'm trying to create a custom function that sends an email, an HTML email with formatting and images, to be used with a business rule in Zoho Projects. I've stripped the 'message' part of the sendmail function right back to basics but it still fails. In the example below, removing the DIV styling tags allows it to save successfully. Won't save with styling tags, or image tags.If the message is changed to a simple "<div>TEST</div>" it saves. Can anybody please shed some light on what the problem
Automate Birthday Wish
Hello, How do i automate birthday wishes on DOB using sms integration. I am gonna use Clickatell for sms integration. Thanks.
Stock Update
Hello, I have an application where i want to update the stock. Data is as follows: Design No.: Shade No.: Quantity: 56459 250 35.00 56459 250 35.00 56459 250 35.00 Now i want to dispatch 35.00 meters and it should update the record as follows: Data is not supposed to be deleted Design No.: Shade No.: Quantity: 56459 250 35.00 56459 250
null.toString() --> "null"
Hello, we have a function that copies product description field from one entity to another. When that description (field) is empty/null, the value that is being copied is (the string) "null" instead of an empty/null value. Is there a way to prevent that? M.
Zoho Creator Update a Task in Zoho Projects (DELUGE) Error 6890
Hello, I'm trying to update a simple task on my Zoho Projects using Deluge on the app i've created on Zoho Creator. This app haves a worklow that runs on record update. This is my function on Zoho Creator Workflow: And this is the error i get everytime: I've tried to change the function, for exemple to only get the projects status or something else. Everytime i get this error. Thanks
Return a list/map and use it on the on the next block
Hello, Im trying to make a simple custom function that converts my Unix Epoch time to Date (that is done), but i have to convert two dates and return that two dates in two vars, and theres when the problems begin. I only can return them if i use a list or map, but doing it doesn't make them appear on the next block (the app where i want to put those dates) I've taken some prints, i've tried the function with List Output: Then with MAP output: In both outputs (list and map) i wasn't able to get the
Add Employee Profile (no User) from Api/Deluge Script level
Hello, I want to add new Employee Profile to the zoho people instance. But It need be done programmable, from Custom Function level. Is there any way to add new record to employee form, but not as User, but as Employee Profile ? Best regards
Count Function
Hello, There is form called Delivery Challan where there is a subform in which there are 2 lookup fields Design No. and Shade No. Now the problem i want to validate whether the particular design no or shade no exist in the stock or not and for that i believe count function is the only feasible option (if there is another do recommend). Now i have tried the code but it seems to doesnot work with subform i guess. Following is the code: if(Outward_Type == "Fabric") { for each rec_Fab in Fabric { Fab_Obj
Create Tasks or Scheduled Calls (from a Google Sheet) with Deluge Scripts
Hi Zoho gurus, During the migration of our old (SugarOnDemand) to Zoho CRM, I had several hundred calls and tasks that needed to be added to cover the gap in operations. However, a regular import could mess with the migration process - plus there is always a need to bring in tasks and calls. For example, set up tasks and call scheduled in support of external events. I've created two Flows that may be useful for others. One for adding Tasks and the other for adding Scheduled calls. Currently,
Compare two lookup lists
What is the best way to achieve the following: (a) I have a data inventory form, and each record tells me whether a certain assurance activity should be undertaken by the data it holds. For instance the data says a special audit should be undertaken. (b) I have a second form which details the special audits that have occured. As an audit can cover multiple data inventory records under (a) the ID's of the records from form (a) covered by the audit are recorded as a list on form (b) - call it b_in_scope_records
Display fields in Zoho Creator from Zoho CRM
I would like to populate a database in Zoho Creator with fields from Zoho CRM. I know I can include some standard fields through the "Integration" but I have other customer fields in CRM that I would like to include in the database. I would like to display these fields in a report and trigger workflows based on fields changes (in Zoho) which would also change Creator. If deluge is required, syntax would help as I'm not a developer.
Send Mass Email to Customer
Hi Everyone! I have a portal customer and i want to send a mass email when i import some data on a form. The data cointains number that are related with pay invoices. For example: This NumDoc is relate to some email customer, so when I import the csv, i need that send an email to the customer that indicates that the invoices was paid. The currently code that i made is the below, but send me email by all the records. rec_acc = Dream[Doctype == input.DocType && NumDoc == input.NumDoc]; rec_rut = Vendors[Account
Update Records When in Created or Edited
Hi, I have 2 forms 1) Inward 2) Stock Report Both forms deluge code is under created or edited format. When i enter the record and successfully submit the record data is mapped to Stock Report. Following is the Code i am using if(Inward_Type == "Fabric") { for each rec in Fabric_Inward { duplicate_Record = insert into Fabric_Stock_Master [ Added_User=zoho.loginuser Design_No=rec.Design_No Shade_No=rec.Shade_No Meter=rec.Meter Quality=rec.Quality Width=rec.Width Count_Construction=rec.Count_Construction
Delete Records using Multiple Conditions
Hello, I have "Kids" form where i have design no, shade no and multiple sizes say 28, 30, 32, 34 and so on and they are updated when delivery challan is created. Now i want to delete the particular design no. when all the sizes of the particular design no is reduced to 0.
Financial Year
Hello, How do i setup financial year in Zoho Creator.
Help counting and calculating date differences in arrayed data
I have no experience scripting for arrays, indexed lists, etc. and need help to deluge-script the following business need: I have an event_form, with a date_field, employee_field and time_field. For any given date, the number of records logged by a employee varies from one date to another. I also have a summary_form, with a date_field, employee_field, recordcount_field, and hours_field. The script should accomplish something like this, diagramed in plain English: For each date_field value and each
SubForm Formula/Date Field Autoupdate
Hello, Is there a way to auto-update a date field inside a subform upon change? I tried using a formula field but it updates all the other lines as well. From: Test Date / Formula Field Test 1 11/24/2019 10:20 AM Test 2 11/23/2019 09:19 AM To: Test Date / Formula Field Test 1 Updated 11/25/2019 09:46 AM Test 2 11/23/2019 09:19 AM
How to add new Line to Button Action
Hey guys, Got a very simple function that looks at an account and returns a basic stack of information for that account that we need to keep our vendor's happy. The function is simple, it goes into the Account, finds all the data and returns a string. The only issue is the "\n" (Newline) is not being encoded to <br> on when the button is actioned. I tried \r but that actually returns the string "\r". Is this a bug or is there another way to implement line breaks? accountId = accID.toLong(); rec
compare 2 reports for the same data
Hi All, I seem to not be getting any information back in my emails when executing this script. " b = Collections[Bin_Number != ""]; bincheck = Master_Bin_List[Bin_Number != b.Bin_Number && Ignore_in_count != false].Bin_Number.getAll(); if(bincheck != null) { sendmail [ from: zoho.adminuserid to: "email address" subject: "bin check" message: bincheck ] } " I am essentially checking if any bins have not been used, and then send an email list if they have not been used. Anyone can help?
Users Module List in Deluge
Hello everyone, I am using deluge function for to get users list. I can take all user list but I need to specific field For example : GetUser.get("status"); status field but it is not working. Result null Do you have any idea? Note: you can see result of code from screenshot GetLead = zoho.crm.getRecordById("Leads",LeadID); PersonelID = GetLead.get("Owner").get("id"); GetUser = zoho.crm.getRecordById("users",PersonelID); status = GetUser.get("status"); info status ;
Use a user's previously entered information to do calculations on current form
Hi! My premise is that a user will access the app, enter data in a form for example: amount of bananas: 1 banana. Next day they go in and enter the same form, while other users also update their own form data, stating the banana amount for that day. I would like to add logic so that if the bananas are a different amount from the previous day, it adds a question: "why are there less bananas today?" so that the user can say what happened to the banana.. So basically it's stock taking. How can I retrieve
Last 5 yeard addresses...
Hey community, We have to create a script to compleate the addresses the users had in the last 5 years and I wonder if there is any delug scrip premade for that.
Fetching one Subform data into another Subform
Hello, I am trying to fetch data of one Subform's data to another using a Number field (Inward_No.) But i encountered an error. Please someone help me in solving this. Following is the Code: And following is the error i encountered.
Create automated event after sales order status is changed to "in progress"?
Hello there, i trying to figure this out. When a sales order ist created with status "in progress" ist should automatically create an event into the calender the sales order has tow date fields "start" and "end". Also the name of the event should be the customer name with a präfix. The event details should contain phonenumber of customer and productdetails. Is this possible with custom functions?
Aggregate Records
How do i aggregate records Item wise??
How do you insert a record in a second form with a lookup field that is being created in the current form?
I have two forms that are connected via a lookup field. When I successfully create a record in Form1, I want to add a record in Form2. My code looks something like this: insert into Form2 [ LookupField = input.LookupField <field> = <expression> ] I get the following error (LookupField=200): Error details: Error in executing On Add - On Success script. Due to invalid expressions insert statement is terminated Line:(12) Error on inserting value for field 'LookupField'. Given value '200' doesn't exist
Stock Update
Hi, I have Design No., Shade No. and Meter in Stock I have multiple entries in same Design No. and shade No. (for Understanding purpose please refer the attachment) I am updating stock when the "Dispatch challan" is updated. Now For eg: I have dispatched 40 Meters, Stock should get updated as follows: 56459>250 0.00 90.00 But the Stock is getting Updated like : 56459>250 -10.00
Using Multiple fields to update Stock
Hi, I want to use multiple fields to update stock for eg: i have Design No., Shade No., and Meter using the reference of Design No and Shade No meter should get updated. Note: Design No. and shade no. can have multiple entries of same number. I have tried that but it doesn't seem to work. Following is the code i tried. for each Stock_Record_Obj in input.Fabric_Details { //fetch fabric stock record by using the ID of the record from the lookup field product_Obj = Fabric_Stock[ID = Stock_Record_Obj.Design_No];
Fetch 2 records in one collection variable?
Hello Can i fetch 2 fields record in one collection variable?
Inventory Update using Deluge
Hi, Can someone share the code on how to update Stock after product is Dispatched automatically. Ex: I have Design No., Shade and Meter in stock and i would like to update them on Dispatch. I tried but i am not able to find an answer for that. Please help me ASAP
Using Deluge to fetch data into a journey
Is it possible to run a Deluge script in a journey? I wish to have an reactivation campaign that gives the user a unique (timed) URL to order a heavily discounted product. I can fetch the unique URL from my URL management service via API (JSON) but just need to know how to call such an script from within Journeys. Best regards, Joe
Zobot follow-up messages
Hi, I'd like to add a feature to my Zobot which would allow the bot to send a second message to the user after a certain period of time. For example, we would display the user with a phone number to call in to. After say 5 minutes, if the user is still on our site, we would want to follow up with something like "Now not a good time? Do you want to schedule a call for a later date?" Is this possible with Deluge?
Next Page