Urgent - .toStartOfWeek not working correctly
Hi Why are these formulas showing as some am and some pm? It means when I do a report I have two different values for the one date. I would ideally prefer to have no time value if this is possible? But if not I would like all that fall under the same
Query on Collection variable
Hi, I have a table "Sales" with 3 field: Date Name Quantity I execute a fetch on Sales filtering on date and the matching records are contained in the collection variable "data1". Later I want to execute several queries on data1 using criteria on Name and Quantity. How can I do this? Tks
can't update field in sub form from another form
Fetch Data from a subform to other form in a multiselect dropdown lookup
Hey there, How can I pull data from a subform to other form in a multiselect dropdown lookup so that I can create reports. Any help would be appreciated! Thanks in advance!
Multi-Select lookup and Multi-Line field
Hello, I would like to know whether data selected in Multi-Select Lookup Field can be copied in Multi-line Field or not? For eg: Following is the data selected in Multi-Select Field And i would like to copy that selected data in Multi-Line field as: Multi-Line Field - 46.00,46.00 Is this possible with Zoho Creator?
can't update field in sub form from another form
I try to update a field in subform after submitting another form.
Which workflow executed when uploading a file through the "FILE API' to an existing record?
Cannot find this information on the documentation. I've already tested few like "created/edited - on successful form submission" and it doesn't seem to work.
How to Fetch Subform fields in Multi Select Lookup?
Hello. How can I lookup a field of subform into another form with multi select ? I have a form where I'm adding skills and subset of skills along with the value of every skill. In the main form, I want to get a calculated the value on the basis of skills
Decision Box Alignment
Is there a way to align the decision box vertically to the rest of the fields on the line? it's driving me nuts that they don't align.
How do I deal with multiple currencies?
Hello, I have a form that uses a dropdown field to determine currency, then number fields to store the 'raw' decimal amount. So, for example, a user might choose "Dollar" from the dropdown, then add values of 0.06 and 50 to a couple of other fields, which means $0.06 and $50. Alternatively, a user might choose "Pounds Sterling" from the dropdown, in which case the 0.06 and 50 would mean £0.06 and £50. I ultimately want to produce a report with totals in US$. So, I assume there will need to be an
Getting information from a forms fields when using lookup
Hello, I am new to Zoho creator and not very experienced in its use, so what I am asking might seem quite simple. I have 2 forms, "Add Student" and "Add Letter" the "Add student" form has student details, e.g. year group and class. In my second form (Add
Sorting HTML tables in HTML snippets (node.js?)
Has anyone figured out a way to sort HTML tables in HTML snippets? Perhaps using node.js? @Damien?
How to create a new package in Zoho inventory using deluge?
I'm attempting to create a new package in Zoho Creator through deluge by calling the Zoho inventory API. Here's what my code looks like. packageMap = Map(); packageMap.put("package_number","PA-00004"); packageMap.put("date","02/25/2022"); lineItemList
How to fetch data from a subform to populate a lookup dropdown in other form?
Greetings, I hope find you well and safe! I have a form 1 where user register locations of a property: Field property in the form (ex. Headquarter) and its locations in the subform (ex. Office, Warehouse, Park, Gas station, etc). I have a form 2 where
Select a subform lookup value
I'm new to Delgue coding and I'm attempting to select a value in a lookup dropdown list in a subform and haven't been able to get it to work at all. I'm able to create a row and enter data into the two date fields correctly, but the dropdown menu remains blank. My code is as follows so far: // declaring the row row1 = Training_Curriculum.Training_Requirements(); // assigning values for various subform fields in the row row1.Requirement_name = "1"; row1.Start_Date=zoho.currentdate; row1.Completion_Date=zoho.currentdate;
[Solved] Get value of lookup field within a subform
Hi, I am using sendmail to receive a copy of submitted form values, and i've run into output such as this: 2511901000000056650 I found success with support's help by utilizing this syntax: get_customer = Customers_Form[ID == input.Customer_Name].Customers_Database;But now I need that to work for 3 fields in a SubForm, 2 of which are lookup fields. This is what i have, but it's not quite right. I also don't want it to pull ALL the records, but ONLY the ones submitted in the subform. subformContent="";
for each row in sub form problem
i'm looking for some calculations to run on each row in a sub form. I have it working on the first row but subsequent rows do not work. I have a way of translating words into number values, calculating the numbers and then translating the sum back into words. That bit all works, I just need to apply it to each row. I tried for each row in Risk_Sub_Form { add in my code } i get the error "row is system keyword and cannot be used" Any ideas?
How to download a file from deluge?
I have a function in deluge that downloads a packing slip from Zoho Inventory where the return value is a pdf file. parameterMap = Map(); parameterMap.put("package_ids",/*id*/); PackingSlip = invokeurl [ url :"https://inventory.zoho.com/api/v1/packages/print?organization_id=473837261"
In the Map view of reports, can the color of the pins be adjusted based on a variable/dropdown?
In the Map view of reports, can the color of the pins be adjusted based on a variable/dropdown? As an example, if a record has a status of x the pin would be blue or y could equal yellow..etc... or is this something that needs to be tied to Zoho An
How to access inventory API from javascript?
I'm trying to create a button on a page in creator which when pressed does an API call to packages in Zoho inventory. Here's my code in deluge. print = invokeurl [ url :"https://inventory.zoho.com/api/v1/packages/print?organization_id=849303927" type
Automatically create email accounts from Zoho Creator
We have an esablished Zoho Creator site and create email accounts for our clients to sign in with. Is there any way of automating the process to automatically create a new email account when details are added to a form in Creator ? example : We have a
Automatically number subform lines, starting from 1 evertyime one is made
So i am currently working on a subform in an app. Like shown below the numbers in #Run should automatically populate. So when i add my first row the number should be 1. Adding a new row would mean that #Run would be 2. This should continue to whatever
Creator JS SDK SubForm items manipulation (ADD/GET/DELETE/UPDATE)
I want to ask for help from anyone who's worked with JS SDK on Creator widgets, as I am not clear and I can't get it work the following manipulation of SubForm items. So in my widget I want to be able to Get,Update,Delete,Add Subform items, so far I am
Zoho Creator - Deluge Script - Non Distinct Count in Lists/Collections
I have an issue I am hoping to find a solution or reason to or for. To make it very simple, or to attempt to, I will use the metaphor of a Book Recommendation App. It includes two main forms: ReadersForm (perspective readers) and BooksForm (book collection).
Calculated Field on CRM Entity
function setupGridRefresh() {
var targetgrid = document.getElementById("NAME OF SUBGRID");
// If already loaded
if (targetgrid.readyState == 'complete') {
targetgrid.attachEvent("onrefresh", subGridOnload);
}
else {
targetgrid.onreadystatechange
Deluge Script Version control system
G'day, can you recommend an online source code control system (over the web) for the retention of older copies of Deluge script???? Liam.
How to auto populate fields based on CRM Integration lookup
Hello, I have scoured the forms and tried multiple solutions but I can't seem to figure this very simple task. I am a beginner and am just learning Deluge so any help would be much appreciated. I have a form (Add_Warehouse) with an Integration field set to the Deals module in my Zoho CRM account. I would like to auto populate the following fields, from the Deals module, based on the users response to the field 'Import Details from CRM field' (Creator field link name: CRM_import). The module is
searchable field
I need to create a searchable field in my project. Here when I insert data in this field it'll provide options to display the data in separate tab. Here I've attached the file How can I create like this I was so confused. Plz help me Thanks in advan
Subform JS SDK - Creator
Q1 I have a need to use an array data type in my widget, and most suitable seems to use a Subform. As multi select requires predefined fields. What other field could I consider when I need an array in my record? Also I have trouble working with SubForm
Nested IF function
Is it possible to do a nested if function in ZOHO creator? I want to be able to perform an action based on two criteria. Does ZOHO have an if and/ if or function?
Grammarly no longer works.
Grammarly chrome extension or firefox extension is not working and I am sure that there were changes made to the text box. Both Windows and Mac same issue. The third point in this support article is the issue https://support.grammarly.com/hc/en-us/articles/115000090392-I-do-not-see-the-G-icon-on-a-certain-web-page-or-in-a-certain-text-field-but-see-it-on-other-web-pages- And it worked before, major issue. Any views?
Zoho Creator and Zoho Doc Scanner App - Integration
I think it would be amazing, if when I added an image field in my Zoho Creator App, that I could choose from Zoho Doc Scanner. https://take.ms/qLVnO Then, instead of taking pictures, we can use the app and scan and attach as a pdf.
IF statement on a field
I have to give a value to a field (let say FIELD1) according the following criteria where FIELDXs are type float if (FIELD2 != 0) { FIELD1 = FIELD2; } else if (FIELD3 != 0) { FIELD1 = FIELD3; } else if (FIELD4 != 0) { FiELD1 = FIELD4; } else { FIELD1 = FIELD5; } where I should put it. I tried on Form edit/validate ! form edit/Load but seems not working. the same on the Field /input ! field/validate find in the attachment the right if statement applied. Thx
Publish Zoho Creator Application to Clients
I made a zoho creator application in zoho creator itself and I want to now change the ownership of the application. However when I search for how to do so I find this answer: https://help.zoho.com/portal/en/community/topic/changing-application-owner.
With forms for Intagrated Zoho CRM Account, how add functionalities?
Hi, We would like to change the text field for the parent account to search and select an existing account. At some point, when we use the Accounts Report to edit, we would also like to be able to navigate to parent child accounts. Maybe add kinda cards
Where are the email templates?
I have created a form and there is an option to send an email upon completion of the form. I see a dropdown where I can select a template to use. There is an option for Template 1 and Template 2; where are these templates stored so I can see what they
New field limits on a form (No. fields vs No. characters)
Hi guys, Wondered if anyone could help me clarify something around field limits in a form. Zoho circulated an update in November saying that if we reduce the character limit of our fields, we can squeeze more fields onto a form. See here: https://help.zoho.com/portal/en/community/topic/upcoming-updates-november-2021
What is NOT and OR logical operators?
Hi all, new to deluge. What is this logical example means? Two Conditions with NOT and OR logical operators? ! (a>1) II (b<10) How does this differ from OR logical operator (a>1) II (b<10) The examples in Zoho Help doc text explanation are the same "implying
Storing passwords and api secrets on zoho creator
Hi, I'm fetching information from an external API .the user name and password for the API authentication different for each Zoho user. What is the right way to store user/password information so i can use this for the logged in user? Where should i store
How to call an API with oauth2 in script
Hello everyone, I've a problem and can't figure it out and can't find it here or somewhere else on the internet. I would like to call an external API that requires oauth2 authentication within a custom function in Zoho Creator. How can I achieve this?
Next Page