How to send push notification to Customer Portal mobile app?
Hello, I am trial user and trying to send push notification to Customer Portal mobile app but notification not coming. I did it according to this: https://www.zoho.com/deluge/help/pushnotify-using-deluge.html zoho.pushNotification({"overlapsro@gmail.com"},"New
old vs input
Hi, Can anyone direct me to more info about old.<fieldname> v.s. input.<fieldname>? It seems useful on evaluate if any change has been made to the field. Thank you in advance.
Tthe value of the fields are displayed but i want to add plain text to make the values meaningful..
I need help please.. in this screenshot, the value of the fields are displayed but i want to add plain text to make the values meaningful.. So like 14 is the age of the device but,i wan to add before the field the text "Device Age 14" Thank you
Can reload drop-down box by Deluge code?
Hi When click on the "add new" in the drop-down box to add a new value, how to use code to reload the drop-down box imm again, for example, has three values before did not add, add a new value to update the display immediately after four values, I know ZC has reload form function, could you use code to reload the field of drop-down box? Thanks Stanley Guo 2013-5-21
sort by date automatically the records displayed in the associated blocks
Hello, how to sort by date automatically the records displayed in the associated blocks on a detail view. I can sort them by date in their respective report or from the application interface but do not make it appear sorted automatically. Thank you
Page parameter not passing to form field
Hi, I'm trying to pass a simple text value to a form field in a page using a parameter. I'm sure I've achieved this easily before so need to double check. I've checked the parameter is being passed by adding a panel to display the parameter value which
My fix for "This report is not accessible" in published pages
Hi Community, after having the same issue as many others here and going through the community's posts, i found a solution on my own. Again, the quality of support from Zoho is pretty awful: if you cannot help yourself, you're lost. I really like Zoho,
Integration with ZOOM
Hello, Has anyone done ZOOM integration? I want to schedule /modify ZOOM meetings from within ZOHO creator by using API calls. Need help if anyone has already done it. Thanks in advance for helping me out. Thanks, Milind Manohar
point of sale
Hi, Can Zoho creator make POS (point of sale) system ? if yes from where I should start ? Thanks
Creator Filter user non admin/write
Hello, How is it possible to filter reports in Creator to our need? Normal users (such as Mathias19) have non admin permission. They should only see the reports that made on their name (like logged in user I guess ?). "Write" users only can create reports
Filter page logged in user
Hello, How is it possible to filter a shared page info on the logged in user ? My filter on the page in attachment gives the total count of all reports created by all users in the application. But I actually want that this page shows only the number
Can't add developpers to our zoho creator app
Hello, I've been using creator individually for a little while now, Recently, I wanted to add one of my co-workers as a developer on our app so that they could also help with troubleshooting, development and scripting. However, whenever I try to add
How to integrate Creator with ZOHO Projects
Hi All, I get no help about how Creator integrate with Projects from https://help.creator.zoho.com/Integration-with-other-Zoho-Products.html. Is there any way for Creator to list projects from ZOHO Projects and then list project users for the selected one? Thanks, Roger
COMING SOON Robotic Process Creator ?
https://www.zoho.com/creator/whatsnew/creator6.html#feature-five From the ZC6 one page site. Any idea what this will be? @Support, can you tell us more? B.
Invite Customer portal users
We have a payment e-mail field in our app. Is there any way to send an automatic portal invite to that address if the customer doesn't already have a portal account? Additionally, how can we tell if that e-mail is already associated with a portal ac
For Each records with a Not Contains filter/parameter
Is there anyway to write a for each statement with a filter that "Not Contains" for each varRecord in customer [customer_name = "" && customer_type!="test"] { } Instead of customer_type!="testing" is there any wayt to right it so it would also exclude
Get Info from selected rows
Hello, Is there any way to get info from selected rows without deselecting them? We created a button to get the rows selected, but whenever the button is clicked the selected rows go unselected. We just only want to get one column from the selected rows,
Adding emojis to message in Zoho Cliq integrations fails
Hello, We have a form when is sent, it automatically sends a cliq message to a channel as a bot. We are having a problem adding emojis to the message. If we add any kind of emoji, the deluge editor deletes all the code from the place the emoji is placed.
Create Dynamic Drop Down List from joining 2 field from a row
Hi, i would like to know how can I create a list to be used as a dropdown list? for a single field, I can do the following: getList = Form[ID != 0].ID.getAll().toList(); input.dropdown:ui.add(getList); I tried the following method but it doesn't work:
Lookup ID shows up instead of actual value
I have a script that executes on a subform on input of a value. However, when the script executes it is only showing the lookup ID (i.e. 3865374000000736031) and not the actual value (i.e. CTSI). Can you assist me with getting the actual value to show?
Basic Deluge script to copy 1 field to another
I have a set of address boxes for street city state & zip to identify a job location. I have a duplicate set of boxes to identify the bill to address. I have a radio button to select to copy the job location address information to the bill to address.
How to update a custom field in zoho inventory?
I have a custom field in inventory that I'm trying to update through deluge in creator but I keep getting a strange error. Here's my attempt at updating the custom field. The name of my custom field is "cf_substatus" and I noticed that it was contained
How to hide fields in same form but in different report on edit
Hi, i have one form, and depends on that form we have 2 reports with different condition on the report.. So, i want to show fields on 2nd report, if that 2nd report edited only then those fields will be shown not for first report when edited. Hope you
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?
Next Page