Send mail (on success) if new row added (subform)
Hi guys, Can someone help me out with the script for: On created or edited > on success Send mail if new row in subform added. I don't know if I'm just having a complete brain block today!! Thanks
how to restrict a lookup field
Hi, I have a lookup field in order form for customers. I'd like to publish the form, but I do not want customers to see the list of customers behind the lookup field. Is it possible to do it? Thanks a lot! George
Zoho Creator Report - Including Multiselection type fields.
Hi, I have created a table which captures information about client companies. One of the field, "FieldA", offers a selection of 5 options. Now when I try to create a report, this field does not show up on the left hand side of the screen which list the other fields. I also notice that a checkbox field also is missing from this list. Is this a limitation with the report module? If not how do I include these fields in my report. Thank you. Prabha
Any existing integration with Zoho Calendar?
Hi there! Is it possible to send data from Zoho Calendar to Zoho Creator? I mean, directly via an integration made by Zoho, or if the only possible ways at this time are through third-parties, such as Zapier, Make, etc. I tried to find the answer to my
Any way to force delete items without having to delete first every referred occurrences?
Is there a way to force delete items (forms/fields/other) without having to delete first every referred occurrences? If not, is there any existing features in Creator that could help with locating those occurrences faster and more easily? I mean, besides
How to check for an empty field
I want to set a custom filter to search for records where a certain field is not empty. Effectively, "Field does not contain [blank]" Can someone tell me the syntax for empty or blank please?
Conditionally mandatory field??
Hi, Ive seen similar threads on this but none of the examples shown have worked for me. Say I have text fields “Name” and “Description”; and a drop down called “Status” that has 2 choices: “Save” and “Ready”. My Name field is always Mandatory, that’s
Option to protect application
Day before yesterday I was working on my client account in which I had published my application. Since it had some mistake i decided to delete it and accidentally I deleted the original app I had in my account. Before deleting I was prompted to confirm but I didnt realise that I am in my own account There should be an option to password protect the application where in application can be deleted only after the admin enters a password for that particular app. I think this is an important issue and
Inserting a report into a from in creator
I've have a form I am building for service calls. I want to have a look up field in the service form filter the report from the service forms by the job name. Is it possible to have the filtered report shown in the service form so techs have the history?
Zoho Creator: How can i use my widgets in my react app ?.
Dears, I'm developing my front-end application using React Js, and I use Zoho Creator to create forms, tables and data dictionary, So how can i use these forms in my react app except using it as an iframe Regards
Rearrange how Apps appear on the Dashboard in Zoho Creator?
We would like to rearrange how our Apps appear on the Dashboard in Zoho Creator. Is this possible? They only seem to be listed in order of date added. Is there any other way to sort? Such as "most used" or "most recently used" or "starred"... Or by manually dragging them into a static order. Anything would help...
Sending a concentrated email of all the order details from the subform
טקסט מקור I am building an application that sends orders of goods to the email of several suppliers simultaneously. For instance- in a restaurant that has a supplier of drinks and a supplier of meat and a supplier of vegetables, the restaurant owner will
Using Roles and Profiles in Deluge
I have a form with a section called "Billing_Details" for use by our billing department. I would like to hide the section when the user is not a member of the Billing Department. I have a user profile called Billing Department. My question is this: is
How can I use add record to create multiple records from one?
I can use add record to create one additional record, but not for the multiple that I want. I am using forms to submit orders for advertising, so I need the same form to apply to various dates in order for a report for a given date to be accurate. The solution, I though, was to have a field assign a number of "runs" or "insertions" of a given advertisement, then the function could create copies of that same record, with .addWeek(2) for the date field, according to the number of times in that field.
Document Editor does not show correct Field Content from Lookup Fields
Dear all, I do have a strange content showing in the Document Editor. I do have multiple Lookup Fields in a creator form like shown in following screenshot When I import this field into the document editor it does not show the content of the field, but
Unable to create a pie chart
Hi, I have a form with multiple fields (field A, field B and field C) and a field which is the sum of Field A, B and C. I am trying to create a pie chart for this. When i try to create a report, the option for pie chart is not enabled. Can you guide me with the right steps so the pie chart option is enabled. Thanks!
date time and currente date time
hello im creating a grapg or a page snippet on where user can view on real time the expected date time of a ticket minus the actual current sisteme date time so i can create a graph or a report that is green if expected date time has not expired related
How to fetch Multiple values when Lookup field type is "Multi-Select" ??
Hi.. I have Project Live Form Window, where my Lookup Field - Employee_ID (Multi - Select Value). when I choose Employee_ID ( Multi Select value) field ---> from Project Live Form Window, I want to Fetch Employee data automatically from Employee_Info form. Suppose If I choose , 2 Employee ID from Project Live Window, It should display that 2 relavant records, say Email ID. I tried using Script Builder, but getting Error. How to do this task?, Kindly assist me, doing this task. Thanking you Regards
would be nice if zoho creator had a spell checker option for text fields
would be nice if zoho creator had a spell checker option for text fields
Unable to COPY / Duplicate Application
Dear All, I am desparately in need of help. I had worked day and night on a CREATOR application recently and now wondering to COPY the application to another user ID and give it off to a friend. The application works absolutely fine in my account and I have currently made it public so that I could copy the same application from my friend's account. When I login in his account and do a search for applications, I am able to pull up my application but then the system doesn't copy the application to
Formula to calculate age
Can anyone help me create a formula that will calculate a persons age. I have the date of birth and the zoho.currentdate variable, but I am note sure where to go from there. Thanks, Dave
add border to a list view
Hi, Is there a way to separate fields with borders in a list view in order to have a more printer-friendly version. Thank you!
Since Tuesday our users have not been able to access most of the reports one of our core applications.
On Tuesday morning one of our our core applications suddenly denied access to all user reports except me. I am a developer not and end user and have administrator access. There are 3 other users with the same access although they also have been denied
Creator JS SDK - How to use any "array" field??
Hi team, I've tried every single way to addRecord where I want to parse an array, just ANY array. I don't know why there is no single field that would allow me to use this dynamically. I tried multi select, which when I fetch the record, it returns an
Deluge script to create new record in custom module not working
The below results in an error message when using the API name of a custom module voidCreate_building_from_name(string Address1,int lead_id) building_map = map(); building_map.put("Buildings_Name", input.Address1); building_map.put("Address_1", input.Address1); create_building = zoho.crm.create("Buildings", building_map); info create_building; info building_map; Results in: {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"Name"},"message":"required field not found","status":"error"}{"Buildings_Name":"test","Address_1":"test"}
Zoho Creator
Hello, I have app in zoho creator, and have invited my employers .. but when my employers open invitation link .. it redirects to blank page! Screenshot is attached.
Trying to pull a owner name (and other data) from CRM in Creator
Hello guys ! With the help of this great community I was able to pull some data from CRM "Contacts" into my Creator Form. As you can see below, it's working like a charm but I now need help to be able to fetch only the name of the owner (my "commercial"
Is it possible to add 2 sums from 2 apps?
I am converting from an old app to a new app. I have a report which currently pulls information from the new app and the old app and then I just have a "+" sign in the middle. Is there a way to make Zoho do the math from 2 separate apps? The code is listed
Display selected subform records on HTML view
Hello, I'm having trouble on importing data from a subform to a HTML view. I want to display each row of the current subform into an HTML view. On sucess I pass the ID of the current subform this way ReciboID = input.ID.toString(); openUrl("https://creator.zoho.com/29david.montero29/gestion-escuela/#View:Prueba_3?IDactual=" + ReciboID + "", "Same window"); Then I fetch the record.... <%{ IDnum = input.IDactual.toLong(); Recibo = Escuela [ID == IDnum];%> Inside Escuela is the subform LINEAS_ESCUELA.
How to add image to the forms to have better visual design?
Hello, I need it is very important to add some icons or photo in the forms when we add fields. I couldn't find that option. the image field is only for uploading to database not for visual design. thanks TRANSLATE with x English Arabic Hebrew Polish
Subform : Recall existing data into subform - not create new data
My use case is that I have a multi-select field where I want users to be able to choose locations that already exist and bring them into a subform to edit. The subform is linked - not an inline one. The multi-select field and the subform are the "locations"
Run Creator Custom Function in Flow?
Is it possible to run a custom creator function from Zoho Flow?
Basic Budget Application
I am trying to determine if Creator will work for a basic budgeting application that I am wanting to put together. I would like to have a form that I can use simular to a check registry, a form where I can create a monthly budget with categories, and some views that show actual versus budgeted totals. I can not figure out two things: 1. How to have a running balance for the form that I want to use like a check registry. For example: Date Payee Amount Balance Category 11/21/06 Wal-Mart 25.00 100.00
Zoho Creator Lookup field wrong data type
Hi I'm trying to get to grips with fetching records in creator and have created 2 forms: Visitors (Name, Email) Appointments (Date, Visitor, Email) The Visitior field in Appointments is a lookup field related to the visitors form. I've tried to define an action in script builder to take the name displayed from the lookup and fetch the email address of that visitor. The problem is that the name field in Visitors is a single-line text field whereas the Visitor lookup field is being shown as numeric.
How to push image URL in Image field of Zoho Creator using custom function/deluge script or creator API?
Hi, I want to add an image to Image field in Zoho Creator by giving URL of image into Image field using custom function or deluge script. I tried to give URL of an image in Image field in Zoho Creator's record using the following code: insert into Testing [ Added_User = zoho.loginuser Name = "Test Record" Email = "MyEmailAddress" Image = "http://cdn.wonderfulengineering.com/wp-content/uploads/2016/01/nature-wallpapers-38-798x350.jpg" ] But it is not adding image to Image field.
Custom Button in Quick View of Report should be Available for Mobile View
Hi @Zoho Team, I believe having a button available on quick view of report for Mobile app is very important. I understand that having it inside Detailed view or adding into action buttons does solve the problem but from the user journey point of view
Zoho Creator Should have Folder Management Capability
Hi @Zoho Team I think once of the major things that Zoho creator lacks is the Folder management capability as all major ERPs and CRMs do come with resource management section but there is no specific resource management section in creator which I believe
"Convert" a blank subform into a regular (sub) form
Other than manually exporting, importing, and linking, is there a faster and easier way to "convert" a blank subform to a regular form (to be used as a subform)?
Unconditional transition is not working
Hi, I have a new transition called Merchant cancelled In my dev environment I have 3 records in Merchant terminated stage 2 of them were moved to this stage before that new transition was configured, one after and only for that one record it is possible
Please Fix Error Message Locators for 'IF' statements
As you can see from my screenshot attached, the error message says there is an "Error at line number: 1". This is incorrect. The error ACTUALLY exists on line 82. I've noticed this miscommunication often occurs when there are 'IF' statements involved. Whenever
Next Page