create subform records from another suform
hi, My app has this forms: Orders Order details Shippments Invoices Invoice details Order details is a subform of Orders Order details is also used as a maiform, wich has shippments as a subform. Invoice details is a subform of Invoices. Now I want to have a lookup field at shippments where i would chose an invoice (or create one if it doesn't exist). When i would chose the invoice, the shippment record data should be copied and create a new record at invoice details. This records should be invoice
How do you show / hide fields based on a group
Hi Could you please help I have some control fields that are used by admin staff to control a users permissions. Such as setting the type of user in the portal, business user, general user, etc. I cannot let the portal user see this information or edit it. I do need the admin logged in users to be able to change it. As field permissions only all "Everyone" or "Admin" (I would have loved this to be a user group - but I cannot find it) I am using a method of show and hide. I can turn on access for
URGENT - Export is including control characters - two requests and still not fixed.
Since about 14 December the report export to CSV has been showing up control characters such as "&" instead of "&". This si a major problem for us as we use export extensively, including every single day to export invoice data out of Creator and into Xero. Importing client names which suddenly have extra control characters, has the effect of creating a new Xero account, which is obviously very hazardous. I reported it in a live chat on 14th December and was told that it would be fixed immediately.I
Email Migration
I have verified that I am the valid GoDaddy user, but I can't get the emails I've created on zoho to migrate
Android Creator app login
I am having trouble signing in on my mobile phone – I am new here and this is the first time I am trying this. I am set up on Creator on my desktop and built the first demo. I am trying to sign in with my phone# which is on file, and the correct password. I can sign ok to my computer but not to the phone. This phone number is on my profile – I am entering just the 11 digits phone# exactly as it shows in the profile, tried all combinations with and without the (+1) that is on front of it.
HTML link to record summary
I am attempting to create an html link in an html page to open a record summary in a pop up. I am certain that this is fairly simple but I cannot get it to work. I have tried many versions of the following example: https://creator.zoho.com/<username>/<appname>/record-summary/<viewname>/583654000005625549/ Is the <viewname> the deluge name of the record summary, or is is the name of the report the record summary is contained within, or? I have tried many variations, clearly not enough, but end up
Trial Version Creator
Hi I just accessed Zoho Creator and I wanted to take advantage of the Trial (which will be far too short; I know that alreay). To start with, I added the Project Tracker app and I wanted to edit it, obviously. But it tells me that I am not allowed to do so (access denied or something). What gives? Are these pre-made apps not available for editing? Thanks.
Google Sheet to App in 5 Clicks
Hello everyone, We are pleased to inform that, you can now add Zoho Creator to your Google Drive account. The main benefit of this is that you can now migrate from a sheet to an app in a matter of clicks. All you have to do is to add the Zoho Creator extension to your Google Drive account. The steps to do this are as in this video here. Now for the wow factor. Build an app from a Google sheet in just 5 clicks! Here's how it is done, click here. Anup Zoho Creator
SMS integration with Zoho Ceator - suggestions?
I have multiple employees I need to send reminders, notices to en masse. Sometimes I will want to group these employees into categories and only send to those select categories. I thought ZC would be a nice way to add their info or allow them even to edit their own info. My employees tend to have mobile companies like Simple Mobile, Boost, MetroPCS... ideally I would prefer a service that doesn't require knowing the mobile provider. I know several SMS services work with ZC - do you have any suggestion?
Trigger CRM>contacts>macro from Creator
Hi, Is it possible to trigger a macro in the contact module of Zoho CRM using a Zoho Creator application? Kind regards, Bo Thygesen
old. values of subforms fields
Hello, Does any one knows how to access the .old field values of subforms fields in the validate event ? Thank ! Pierre
Enable or disable subform fields based on another subform field
Hi there I have a form with subform setup. On the subform I have dropdown field - i want to enable or disable another field on the subform based on what value is chosen on the dropdown field - is this possible? I have seen in the forums from about 5 years ago you could only enable/disable subform fields from the on add/on edit of the main form, but am hoping that this has now changed. Thanks Aaron
An internal error occurred
Olá, Eu adicionei meu domínio e-mail, mas a criação de um nome de organização faz com que um erro interno.
Seeking developer
I am part of a team of roughly 20 people. We have three tasks that must be completed 7 days/365. I would like a task reminder that notifies the team when the task has not been completed as well as a team email that informs us that the task has been completed. For each of the three tasks, there are three people that are responsible for completing them. The three people for each task will often change on a daily basis. I need it so that if the first person (primary person for that day) misses
Does Show Field To Admin Only setting on forms apply to reports or views?
If a form field is configured to "Show Field To Admin Only" and that field is used in a report is it supposed to show to everyone? I have a URL field that will be populated through Deluge as records are created and updated. In this case the field should not be visible. For reports I do want the URL field to be visible. Thanks
Custom icon for Zoho Creator app when accessed from iOS
I have an application that I'd like users to be able to access on the iPhone (via the Creator app). That works find if they load the Zoho Creator app and then select the application, but what I really want is a simple way to install my app so that it has its own icon/shortcut. I'm sure it will have to access the Zoho Creator app behind the scenes, but I don't want the user to have to remember that "Zoho Creator" is how they get to my app. It's a confusing extra step. Is there a way to do this?
Setting the height of a multi select list
Is it possible to set the height of a multi-select, lookup field on a form? I tried the instructions here (https://www.zoho.com/creator/help/fields/setting-field-width-and-height.html) to no avail. The height setting is missing. Here's a screenshot of the form field in question: Here's a screenshot of the field properties. Note that I have tried changing "field size" to be other values, including custom. It just change the width. Any help is greatly appreciated.
How do I add a specific field response to a "Page", Thanks
I don't think this should be to tough but I seem to be missing something. Would like to add an intelligent specific single response within a page. Similar to the count function on badge. But with other single line info. But to take it a step further. Lets say I want to show how many days since something was done last. What would be the most straightforward way to do that. Imagine it looks like this 3 column table Button | (Intelligent response) | Button
Updating Value of Checkbox On Edit -> On Success
Hello, I have a list of checkboxes, like Notifications: First Email Second Email Third Email i want to update(check/tick) the 1st option "First Email" when "if" condition gets true. What i have done so far (On Edit -> On Success) if(input.Email == "xyz@email.com"){ Notifications.select('First Eamil'); } This doesn't work. I am getting the alert like this "'Notification' can be used only in on load actions". This works in "On Edit -> OnLoad". But i want to do it in "On Edit -> On Success". Kindly
"Approve / Decline" notification when data is edited? // field and form name as a variable?!
Hi Zoho, I need to create some verification system when certain users change data in a form. So when the user tried to edit data in a form, I will get a notification on the mail with an option to either approve or decline the change (decline = no change is made, approve = the field gets the suggested data). I thought about creating a "Change data form" that will be auto-filled and sent via email when an edit is suggested. in order for this to work properly, I need to have variables used for the
"Allow HTML tags" is missing
I want to experiment with adding conditional scripted cell colors on some views. I understand I need to check "allow HTML tags" in the app settings. However, this checkbox is MISSING in the app I am working on as well as one other app but it present in 5 other apps I have created. I cannot understand the reason why it would be missing, however, when I try and apply HTML tags to cell text, the HTML tag is shown in text, which is, of course, not what I want. Any ideas here? DJ
Trying to use insertRecord from Creator to create record in Custom Module in CRM
Hello, I am trying to insert a record in a CRM custom module from Creator using the insertRecord method but not having any success. Sample code below - Any help appreciated myCoursemap = map(); myCoursemap.put("authtoken", "....."); myCoursemap.put("scope", "crmapi"); myCoursemap.put("xmlData", "<CustomModule1><row no=\"1\"><FL val=\"CustomModule1 Name\">View</FL><FL val=\"Opportunity_ID\">1292716000000095025</FL></row></CustomModule1>"); url="https://crm.zoho.com/crm/private/xml/CustomModule1/insertRecords?";
converting a text box
Need to convert a text (single line) box to a date box without losing any of the old data. Old inputs are like 06/12/1943.
Quickly create insert, collect, update DS code for your forms
Link to Code snippet Ok, so I just got so tired of writing lengthy Zoho form field scripts full of the same code over and over! ZC doesn't have any feature to dump field names onto the text editor for easy script writing. Nor do they offer anyway to dynamically reference input names through meta programming methods (code that makes code, DSL's). So if you want to generate insert, collect, and update code really quickly you might be interested in this javascript snippet. Read the comments in the
Error: The remote server returned an error: (400) Bad Request. -Zoho Creator XML RPC API
I am trying to use Zoho Creator XML RPC API. and I always get back an error which is above. I send to this url: https://creator.zoho.com/api/xml/write/woodcliff-rewards/Rewards With this postcontent: <form method="POST" action="https://creator.zoho.com/api/xml/write"> <input type="hidden" name ="authtoken" value="xxxxxxxxxxxxxxx"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <textarea name="XMLString" > <ZohoCreator> <applicationlist> <application name="woodcliff-rewards">
Alert won't pop up on "On Validate"
Hi Zoho, I have an alert that needs to pop up when a form is sent. This only to inform the user, I don't want to cancel the submit. The alert does not pop up. Why? Thanks!
changing rich text to multiline
Hi i have two questions on that topic. 1) is any data going to be lost in that transition from rich text to multiline ? 2) how do i convert the rich text to simple text ...i.e. how do i get rid of the <br> without losing the return paragraph function...
Auto Fill Field in Subform Of all the lines
Hi, I fill in a subform, but fill all the data from it after that and add new rows. With my code I can only fill in the first line and I do not want it to be "on add row". if(input.Tipo_de_orden1 != null) { input.Registro_Mercancia.Tipo_de_orden1= input.Tipo_de_orden1; } Thanks
Change Text Field Type
Hi, Is it Possible? I have change the text filed type from "Single Line" to "Multi Line". Thats OK. But is there a way to change it form "Multi Line" to "Single Line"? because after changing the multi-line type, "Single Line" option is no more inside the "Field Type" Dropdown. Searched on Forum, over the internet, Get nothing.
Hide Grand Total but keep totals in Report
Hi there, I have a report which contains prices comparisons, which are grouped by suppliers/contract terms/... and I set up price totals for each group, which is what I want. However, in the report, I keep on getting a Grand Total on the bottom line, which I don't want as the purpose of my report is to give my client the opportunity to compare prices between different suppliers, so the Grand Total does not mean anything and need to be removed. Any advice on how to do that? Thanks Maud
Zoho Creator Emergency Maintenance - Dec 10, 2016 (07:00 PM - 08:00 PM PST)
We have scheduled an emergency server maintenance in one of our database clusters on Dec 10, 2016, between 07:00 PM and 08:00 PM PST. During this period of time, some of our users will experience service disruption. You could follow this post for updates on the maintenance. Meanwhile, we'll do everything we can to ensure the maximum up-time. We are extremely sorry for the inconvenience this may cause. Regards, Karuppuchamy
Can a custom action in a view/report be replaced with a button?
I'm embedding a Creator view/report in a website. The user selects records, and then user should select the custom action in the report header to update CRM with preferences they made. However, the custom action is not "easy to find" for a user and my client prefers a button. Has anyone come across such scenario and has solution? Any help would be much appreciated.
Disable entire subform
Under certain conditions I want to disable an entire subform. To hide the subform I can use hide name_of subform; But disable does not work disable name_of subform; Do I need to disable each field in the subform?
Name server zoho
Ho attivato il dominio, con il file sul mio server. Devo aggiungere il record MX, ma nel mio ospite mi chiede anche il nome host di Zoho, come faccio a trovarli?
Zoho Form - Retrieve Checkbox values
So I created a form online with 3 check box fields (A, B, C). Now I want to retrieve & display that data in the emailer using the field labels. If I just chose the checkbox label '${zf:Checkbox}', it returns all values and displays 'A, B' if the user chooses A & B. How can I retrieve & display the value A separately, B separately, and C separately? I want to be able to say, the user chose A on one line and B on another line.
Multiple "for each line" statements
Hi, I'm still learning syntax so i'm hoping this is as simple as rephrasing / combing, but i basically have a couple instances where i want to use an expression to apply in two different ways, but it seems i can't use "for each line" twice like this. (On load) for each line in Prod_subform { line.Previous = true; } for each line in Misc_Subform { line.Previous2 = true; } (On Success) subformContent = ""; subformContent2 = ""; for each line in Prod_subform { if (!line.Previous) {
crm mystery
Strange problem. We have a creator form with a basic lookup to zohocrm. It looks up a product and then displays the name in the creator form. Lately when we do this it shows the product look up but then shows the product code in the field. I am at a loss to figure thsi out. It has worked lovely for a couple of years. Do not think we made any changes.
Overview in the building zone
Good morning... When developing applications it would nice to have a table or database type overview of all the forms in the applications. Maybe even with links that indicate the lookup fields between forms. This has been asked for before but i can't seem to find an answer. It would really be helpful. Regards, stefan
change the display name of a field via script
Hello Zoho creator developpers, I want to know if there is a possibility to change the display name of a field depending on a condition. Something like: If (expression) { // set the display name of input.fieldDelugeName to "company adress" } else { // set the display name of input.fieldDelugeName to "contact adress" } That will save me having a lot of field that do the same and use theme everywhere other script with conditions. Thank you
Openscreen in Creator
hii, I am just new to appcreator. Can anyone explain how openscreen in appcreator is different from openUrl in creator? And please tell me about how to use the openscreen in custom screen and how the parameters should be sent to open a form or report?
Next Page