My function to insert records based on record in another table is inserting a record ID instead of a field value
Hi, I need to populate a table with new records based on another table. I have written this function to do this: void createOrder() { insert into New_Order_Header [ Added_User=zoho.loginuser Supplier_ID=Suppliers[Supplier_ID = 3].ID Supplier=Suppliers[Supplier_ID = 3].Supplier_Name Order_Entry_Date=zoho.currentdate ] When I view the result in the New_Order_Header table I see the correct value for Supplier_ID (which is a lookup field in that table), but instead of Supplier_Name I see a rather large
Multiple connected subforms in one form or a suggested workaround
I have several objects that are 1-many related objects in a kind of vertical hierarchy so for example Courses have several Units and Units have several Objectives and Objectives have several Criterias etc. I would like to make it easy for the user to add this structure in one form since a lot of the information is common so no need to repeat the whole hierarchy again every time they want to add a Criteria for example. I created a Add Course form which allows adding Units (as a subform): I was also
Thousands separator ","
The thounsands separator "," is not being recognized by Zoho Creator when in mass uploads. Also the Zoho Books accounting application does not recognize the separator either. This is not very convenient to say the least. Thanks guys
Number of Business days between two date values - minus public holidays :-)
hi i know there is a possible way to calculate business days (mo-fr) between two date values... but has anyone tried to deduct also public holidays ..... best would be to use a public available service somewhere. second best solution would be to import a table with the holidays to a creator record..... thank you Lambert
Need a way to build public application on creator
Hi There, We need to be able to publish app without login, basically publicly accessible. No sign in or registration required.
zoho.crm.getRecords("Users");
I want to get records of CRM but this not response when try to get information of Users table, this issue is provoke for permissions or not is possible to access at this information for security reasons or why? varUsersList = zoho.crm.getRecords("Users"); This return "null" when try to access at this information in applications in Zoho Creator. Thanks for your time to help to explain why not access this data.
Limit searchable fields in published report
Hi, I've created a database with 1000s of records and published a report (un-editable by agents) that only shows 6 fields (of 26). I want agents to be able to search ONLY within those 6 fields. The report only shows 6 fields. I've created a print template to only show those 6 fields. The problem arises when the agent clicks the search button. It shows all 26 fields. How can I limit the search options to only those 6 fields? Thanks!
Not able to get Query Parameter to work to show related tasks to a project
I have an app that have Projects and Tasks. I created a page that shows related project information that you get to by a function that goes to the page with the RecID as projectRecId. I created a panel that shows the number of tasks and for the action, I want it to go to a report for Tasks that are related to the project. In the Add Task form, there is a Project lookup field and it pulls the Project Name. I created a Query Parameter for the pane action as Project=${projectRecId}. It pulls up all
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
Next Page