zoho books integrations issue
Hi , I trying to integrate zoho books and zoho creator. I am getting error. {"message":"JSON is not well formed","code":1038} sometimes I am not getting error but the record is not inserted in to books if (((request.Customer_Name != null) && (request.Invoice_No != null)) && (request.Invoice_Date != null)) { itemDetails = map(); for each rowprodetails in Product_Load [ID == request.ID] { proName = Product_Master[ID == rowprodetails.Enter_your_product_details.Product_Name].Product_Name;
Auto Calculate Shift From Timestamp Field(In Subform)
Hy , I have one sub-form with 2 fields on it. First field is Timestamp , which is Date and Time field . second field is Shift , which is drop-down field with values (a)Early Shift , (b) Late shift. needed whenever form opens automatically Timestamp field fills up with current time and date , and accordingly if in Timestamp field time is 7-12 then with Early Shift and if Time is 12-6 then with Late Shift . Please Help me with this . Thank you in Advance . Hope i get reply soon . Have a nice day
notify when record updated
Hello! I have an app set up for our teachers to view records for their students (I have a filter set up so that teachers can only see the students assigned to them). Is there a way to set up a notification such that if one of our administrators makes changes to a student's record that an email can be sent to the teacher to let them know that there were modifications/additions, AND what those edits were? I'm hoping it's possible, and not too complicated.
Equivalent of JavaScript's encodeURIComponent() function for mailto: links?
Hi folks, I need to take a few variables (to, cc, bcc, subject) and a small amount of text (from a Creator rich text field, with some very simple formatting, line breaks, etc.) as a message body, then parse it into a mailto: link to pass to the user's browser so that their default email client opens a compose window with the relevant details filled - ready to edit and send. If I were working in JavaScript, I'd pull the rich text out as HTML, add the variables in the relevant order, and throw the
Adding values to SubForm through Script
New to Creator: I have a single line field in a subform called added by. I would like to be able to articulate who added the new entry. My code is simply input.addedby = zoho.loginuser; However, this doesn't work in the subform. Only in the main form. Is this somehow not supported? Dale
How to pass existing subform records to another subform
Please let me know if you can provide assistance with the following problem: I have a form that lists building materials. Each material type has its own row where its general features are recorded. Because each material is offered by more than one vendor, the vendors and their description and code for the material are listed in a subform within the material record. All working properly. The problem is on the ordering form, I have had difficulty extracting the vendor code and description on an Order
Setting up different clients in creator
I have a Microsoft Access database that I sell to Accountants. They have numerous clients that they have to set up, import the client's information and make changes to the information. So new clients are created and information is imported, and the Accountant can open up any of the other clients and work on them as well. Does Zoho Creator allow for managing separate clients within the app? Each client's information is unique and the user has to switch between the clients. Thanks, Richard
Possible to add a related record from the + (add record) option in a filtered report list?
I have built a page that is accessed but a workflow to view details of a project and the page is for a specific project passed with a variable. I added a report widget on the page that shows the Add Task report and is filtered to that specific project record. The report shows only the related tasks to that project which is great, but when you click on the add button in corner, it opens up the Add Task form but does not carry over the Project ID for the Project lookup field. Is there a way to have
calculate working days number based on given criteria from master
Hi, I would like to calculate the number of the working days. FormA: "Submit" - will be storing the periods Fields: Beginning_on (date_field) Ending_on (date_field) Days_off (number_field) FormB: "Calendar_master" - storing the working day info on day level Fields: Date (date_field) -- the whole year uploaded Working_day (number_field) --- 0 if not working day and 1 if it is a working day Can you please advise, how it can be automatically add in the Days_off field (Submit form) the number of the
Associating SubForm Records with a Second Parent Form
I'm a bit lost on how to associate a subform with a second parent form. Im my use case I have three forms: Parent Form 1: New_Potential_Tract Parent Form 2: New_Working_Tract SubForm: Ownership_Details New_Potential_Tract has a bidirectional relationship with Ownership_Details via a field called "Tract_ID_Code". New_Working_Tract has a lookup field "Potential Tract" allowing the user to select the Potential Tract to convert to a Working Tract. A Deluge Script then pulls field values from New_Potential_Tract
Code error 4600 message : You are using unsupported lower version of TLS. Kindly upgrade to TLSv1.2 or above
PDF document emailed via an API is being generated with the following error message: {"response": {"uri": "/ recruit / private / json / Candidates / downloadFile", "error": {"code": 4600, "message": " to TLSv1.2 or above "}}} It has been verified that TLS is updated in version 1.3
Update Form Entry by a client
Greetings, I created a form that I share with clients. If CLIENT create an entry, he is able to update it. if I create an entry, client is not able to update it. How should I manage, for my client to be able to update the entry, whoever has created it ? Thanks, Claire
Best way to update 26,300 records at once
I've added a new multi-select field to an old form so that I can share one same report with different clients and each of them will only be able to see the records that are relevant to them. The multi-select field is called 'access' and basically it will have the zoho.login email of each user that can view that record, and then the report will have a filter using the zoho.login that will check who is accesing the form and show those records. Since this form has existed long before I needed to add
hiding and showing fields at a subform
Hi! I have a form "orders" and a subform "order details" at "order details", depending on the selected "product type", some fileds should be shown. the subform has all the fields possible for all the products types, wich are all hiden on load of the main form i was thinking to show the necessary fields on user input of the product type field, but it seems like it isn't possible as it gives me the following error: "invalidTaskInSubForm" Any ideas on doing this some other way?
Avoid duplicates
Hi, I've got a subform with basic details like Client name, Suburb, Address etc. It appears in two forms. I want there to be a single subform record for each Client name. So if no subform record exists with the entered client name, create it. But, if it does exist, update it without also creating a new subform record. I think this is simple, but i'm having trouble figuring out where to implement this. Thanks Levi
Cannot make scripts in sub form work
I created a simple sub form with some simple math between fields. When i test it in the Forms area it works perfectly. However, when I try it as a sub form of a master form, the script is ignored. Here is the script attached to the On User Input event of a field: input.HST = (input.Product_total * 0.13).round(2); input.Total = (input.HST + input.Product_total); Any help appreciated. Kerry
AutoSum a field in a subform on the main form
Hello, I have a form called “Projects” which contains a subform called “Invoices”. In the subform I have a field called “Amount”. On the main form I have a field called “Total Cost”. When adding, editing or deleting records in the subform I need the Total Cost to auto sum the “Amount” column in the subform. Could you tell me step by step how to do this? Your help is greatly appreciated :)
EMERGENCY: Customer Portal Reports are Missing Fields in the App's Report
Hi, I urgently need assistance with an Emergency issue concerning our Customer Portal reports. I got a call today from our CEO and he said he was unable to see a variety of fields in reports on the Customer Portal. I was surprised as I had not changed the reports and I am the only user with access to the reports. I checked the App’s report and found them to be configured correctly, the fields missing on the Customer Portal reports ARE in the App’s report. However, when I open the report in the Customer
Lookup a Lookup field
Hi, Is there any solution to make lookup another lookup field? Forms: FormA: Item_master (all the core details for the particular item) FormB: Price_list (lookup the item_number from form A and fetch the details + adding the cost on the form manually) FormC: PO_modul (key field is the Item_number optionA: from formA // optionB: from formB. optionA: if i fetch the field valus from formA with 1 workflow (done), i cannot fetch the cost detail from formB optionB: I cannot make a lookup field on another
I wish to parse the 'Address Composite' field. (Like the name field) in a Zoho Form / Subform
Hello, Similar to parsing the Full Name Composite field, I'd like to parse an address composite that I'm using in a subform in Zoho Creator (maybe this applies elsewhere too). I have managed to guess all of the component names of the address composite apart from 'post code'. Below is what I have guessed thus far, where <record> is just the name of an object I'm using. Can anyone share with me how to retrieve the post code value from the address composite? <record>.address_line_1 <record>.address_line_2
HTML page - for each record, add a row and populate
Hi, on my HTML page i've got a table. It's populated with enquiry number, name and address, unhiding a row for each record that exists with my criteria. I may need to have 50 rows in each of the 4 tables i'm creating, so i'm wondering what the most efficient way to do this is? I'd rather not have to define 50 hidden styles, 50 if statements and have 50 rows to manage Here's my current code: hidden1 = "class=\"hidden\""; hidden2 = "class=\"hidden\""; hidden3 = "class=\"hidden\""; hidden4 = "class=\"hidden\"";
Trying to store a reference to a record's ID in another table
Hi all, I'd like to get the ID of a record in one table and store it in another for cross referencing. Trouble is, the ID is a bigint and I can't seem to store this large number in a form field because of size limits. I've tried all sorts of tricks but have run out of ideas. Any suggestions? Steve
Zoho Creator PostURL responseText was cut
Hi everyone, I'm newbie here in zoho creator and deluge script. I'm trying out and testing how to call web API via SOAP. Below is the sample code. url = "http://www.holidaywebservice.com/HolidayService_v2/HolidayService2.asmx?wsdl"; Headers = Map(); response = Map(); Headers.put("Content-Type","text/xml"); body = "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:hs=\"http://www.holidaywebservice.com/HolidayService_v2/\"> <soapenv:Body> <hs:GetHolidaysAvailable>
Load Calendar and timeline on date of first record
Hi, We use Calendar and Timeline reports to represent milestones for event planning. We have a Page with param projectID that filters the records based on the project been filtered. Since we manage multiple event, we have set the reports to load on the current dates. But sometime the first record of the current project can be months ahead. Our users have to change the date for the report manually every time they visit the reports. It's even worst for the Timeline report where they also have to scroll
Hide Cancel button and add delete button in form
When editing records using div embed, iframe and edit in popup, with a code similar to this: <div elName='zc-component' formLinkName='...' params='recLinkID=...&viewLinkName=...'></div> 1. the cancel button is useless and misleading, there should be a way to hide it 2. we should be able to add a Delete button to allow the user to delete this record. I know about workarounds (hiding the Cancel button with CSS and adding a Decision field to trigger a delete script) for both those cases, but I am suggesting
Set Reply-to address available in send mail
Hi I want to set reply to address in send mail script is it possible to set? eg from:abc@g.com to:ss@gmail.com reply-to:kk@gmail.com subject:test message:sample Thanks Satya NHM
Portal template
Hi https://www.zoho.com/creator/help/application/customer-portal.html shows a portal template but only for users before March 27, 2018 and versions before Creator 5. I can't find anything similar for today? Thanks Don
Displaying a formula field result as either a currency or to 2 decimal places
I have the following expression in a Formula field which i would like outputting as a Currency or a number to 2 decimal places input.Pound + input.Fifty + input.Twenty + input.Ten + input.Five + 25 i have tried the following but it only outputs to 1 result is 57.0 (input.Pound + input.Fifty + input.Twenty + input.Ten + input.Five + 25).round(2) it is possible to do in the expression or does this have to be a deluge script?
Report Print/PDF Ignores Filters!!!
So I have successfully created my first application and all is running well. The records and their templates are created and also work great. Thanks to the "Filter"-Option under "Field Configurations", I am also able to successfully hide rows with a quantity of "zero" from showing inside the report. But, what is immensely upsetting is that these fields still show inside the PDF! Which makes absolutely no sense... The whole point of a print/pdf function is to get the report printed out the way I
Rename System Features Designations
Hello everyone, I would like to know if there is a way to rename things like the "Approval" Section. In my case it Should be renamed in 'Confirmation Requests' or something else for example. Thanks in Advance! Best regards Jan
Check if Item exceeds specified due date
Hey all, I need some help writing a script that checks if the task I've got exceeds the due date i've set. I've attached a photo of what i've got so far. I keep getting this error message when I try and save my function, i'm copying the intro to deluge manual and just changing out the variables and form names for my own.
Write script for form cancel button for both add and edit records
I want to load the edit record using edit url when i click the cancel button i want to redirect some other. is it possible to write code for form cancel action for add / edit record
Get API Response to the zoho creator form fields.
Guys i manage to get the response from another 3rd party apps. but the return value is as below {"result":1000,"wallet":[{"balance":1000,"currency_code":"MYR"},{"balance":0,"currency_code":"SGD"}],"error_remark":"","currency":"MYR","api_status":"Success","error_code":"0"} how do massage the details within and put it into zoho creator form? thanks in advance, Jeff
Filter in report by field in form
how can I filter a report or page to show only data that is equal to a field in a form? Example: I have a form that has the following fields. Form: FilterForm dates: name, emailfilter. Have a report Customers and I want you to show me all the clients that in the field filter = emailfilter. (from the FilterForm form) How can I do it in a filter? and on a page?
Fetching fields from a Form and placing them in a Subform
I Have a form called Employees where their Name, Role and Rate is specified. I have another form called Project Details with a Subform in it called Project Workers where we specify the workers working on the project. The Project Workers subform has a lookup (drop down) field called Employees, when you click on it and pick an employee from the drop down list, the Rate of this worker is pulled from the Employees form and displayed in a single line field called Rate. I have written a script to do this
How to compute net total from a total
Please give me the correct syntax. See attached snap shot. As you can see it does not give the correct Net Total.
Addresses not showing up in address or map search
I have a couple forms with the address field and try to use the search and map feature of the address field and type in addresses I have lived at before for testing and it is not able to find them. They only way they show up, is if I also enter the county or township that the address is in. I have NEVER had to do that on a map look up field before. The address field will be filled out with information that is quickly obtained such as street number, street name, city (state is always the state that
convert message content to plaintext before sending/forwarding via script
I have a custom function that forwards specific e-mails to my todo list application. Unfortunately, the e-mail message content (which shows up as the todo's note text) is forwarded as raw html, making it near impossible to read. I'd like to convert the message content as plaintext (stripping out / removing all the html) before sending. Here's my current function: messageDetails = zoho.mail.getMessage(mail_messageId); mailContent = messageDetails.get("CONTENT"); mailSubject = messageDetails.get("SUBJECT");
Go back to previous from link to view in Details Pane
Is there a setting, configuration or something that can be done to allow a user to open up the Details Pane of a record in a report and when they click on a field that has a "LInk to View" setting to it and it slides over to the related item and when done, be able to go back to the initial Details pane that they were at previously, like a Go Back? Thank you for any help with this.
SOAP XML API call
Hi to start off i am extremely green with regard to programming. In one of my views i need to create a custom action what will do a bank account validation based on information in that view specific to that entry (custom action, show action for each record). Below is the information i have received from the company providing the validation service. I have been looking though every possible knowledge base entry and I have no clue as to how to set this up. I do understand that this is a SOAP action
Next Page