Any Key to triggering Add New in subform
Is it possible to triggering Add New in subform by clicking any Key.
How to populate the html clicked radio button value into a form using Deluge
Dear all, I've a page with some radio buttons that I use as a toggle, I'd need to obtain the value of the clicked radio and insert it into a form together with loginusetid. The purpose is to remember what "tab" /radio button last clicked the user. Thanks in advance Eduard Martínez
Update Image Field Via Custom Action Button
Is there a way to create a custom action button in a report view that would allow a user to access an image upload option to add to the respective record? Scenario is, I would like for a user to have the ability to access a record in a report on their phone, select the custom action button and be asked to upload an image or take a pic on their phone. Once complete, it adds to the record. I know there would be an option to create a button that would take the user to the form and can access the image
My profile api reference not showing
What may be the cause of not showing anything when i visit the link https://creator.zoho.com/api/reference In tutorial says when i visit this link i will get my full info about my app/reports/fields etc.
Zoho Creator - Redirect Form to Page
Hi, I've done a little research and this seems to be a similar problem - albeit without a meaning resolution. https://help.zoho.com/portal/community/topic/want-form-redirect-to-pass-via-parameter In essence, I wish to take the ID generated from a created form and pass that into a new page. This page serves as to display a variety of information (as a result of a deluge script being run on create and generating other items - which works fine). The problems I am hitting are: 1. The direct to page
Subform as pop-up box - getting the data back into the main form?
Hi All, I've got a huge subform in my main form, so I've made it a pop-up form. The issue is, On Submit of the pop-up form, I need to push at least one of the field values back to the corresponding row of a subform within the main form. Each row contains a decision box that, when ticked, will pop-up the record for them to edit if needed. Passing a unique field to the pop-up subform: The use case is for adding rooms to a home. The subform pops up On User Input of Room_Type field. If Room_Type is
Fields can't be updated on button click in stateless forms
There was a recent change in stateless form behavior and it requires an urgent fix. When a stateless form button is clicked it no more executes the script which updates other fields from the form. It previously worked, now the same script no more works - I guess that this is a problem related to the new UI. Please fix this as soon as possible. it currently breaks existing functionality in some of my applications (and I suppose that I am not the only one affected). I hope that this is not an intended
Proper way to map First and Last Name from CRM Webhook to "Name" field in Zoho Creator Form
I am trying to create a webhook action by mapping particular data in a CRM deal over to details in a form in my Zoho Creator App (Fulfillment Tracker). I am able to successfully map data to my form/table that is a standard field (i.e. single line input text). However, I am running into an issue when linking up to the name field (which has sub-fields of first name and last name). I included screenshots below up my setup on the Zoho CRM, the form on my Fulfillment Tracker App, and then the table which
Stripe payment gateway
Hi Zoho, Any update on when can expect creator/checkout integration with Stripe payments? Thanks.
Display uploaded image in a form while editing/creating that same record in the form
Hi there! I have a form with an image field and i need that image to be displaied in the form while the user complets the rest of that same form or edits the record... Any idea how to acomplish it? Thanks!
How to add images from one form to another?
Please can someone help me with how to add images from one form to a new form? To explain, I am trying to create a workflow where a ‘Field Survey’ form Can create a ‘Report’ form. I’ve succeeded in getting all the relevant text etc to transfer, however, there are different images specific to each ‘Field Survey’ form (eg. Geological maps and field survey photographs) that I would like to be added automatically to the new ‘Report’ form I create but I can’t work out how? Is this even possible? Or is
Import data from REST API
Hi! I want to import data from a third party app, I can retrieve the data using a rest api. So I can figure out how to make it with Zoho Creator (make the forms, schedule a job to retrieve the data ... and in Zoho Reports import data from this Zoho Creator App). My question is: is there another way to import data from API? is it better/worst? Thanks. Regards
USing RF ID Reader
Hello Does Zoho creator allow the use of RFID? I would like to use some to identify employees logging in to the application Thank you Amanda
Custom icons, colours and typography.
Hi, we are developing a custom app in Zoho Creator for a client that also has its own clients. The app must look different depending on who logs in. Is there a way to use custom icons, colours and typography in the app? Can some of this change depending on the permissions? We know that we can change what page, reports, etc can be seen depending on the permissions, but we are looking for a more deeply customization of the visual style.
SubForm items not displaying
I have three tables: Student, Class and Booking. Student:Booking is a 1:n relationship. Class:Booking is also a 1:n relationship. Both the Student and Class forms have a Bookings subform. I have a script in the Student > On Create or Edit > On Success event: for each item in Class_Bookings { item.Student = ID; } Similarly I have a script in the Class > On Create or Edit > On Success event: for each item in Student_Bookings { item.Class = ID; } The behaviour I'm trying to achieve is
Page Landscape orientation for Print/PDF
Hi, for Pages, when I print or save to PDF, the page orientation is always in portrait. Is there a way to set page orientation to LANDSCAPE? We need to print out a lot of columns. So the portrait mode is very cramped and hard to read.
There should have codes in cancel button
there should have codes in cancel button in form.
Can pic be used from the img type Field in the htmlpage?
i want to use the pics from the forms fields of img type, how to do?
Workflow not working when I edit field using edit in report
Hello I have created a workflow to update an email field with the email address of a person if they are looked up. This works if I am within the form however if i do a mass edit from the report view of the field it does not update the email address. Can anyone help me with this Thanks Amanda
notContains in Deluge
Hello, I need some help with Deluge scripting using notContains function. My form has a checkbox_field with 3 options and a record_status field. I am trying to test for all 3 options being checked before allowing the status field to be updated using On edit>On validate workflow. The design is for script to: if (all 3 Checkbox_field options are NOT checked) { alert "You cannot update record Status until all three checkboxes are marked."; cancel submit; } I have tried a few different script versions
Sub Forms within a Sub Form
Hello, I need to store two levels of master details in my form. For example I need to store with a Purchase Order, PO Header and PO Details such as item wise quantity ordered. However I need a further sub-form to capture the break-up of quantity ordered into customer wise requirements. Is it possible to store sub-forms within a sub-form. Is this functionality supported in C5 version. Another issue is to add the required number of rows in sub-form at the time of data entry based on the requirement.
How to find key for a custom lookup field in Zoho Crm
Hello everyone, I'm facing a problem in lookup field. For Example: On "Potentials" module ,there is a standard lookup field named "Account Name" and it has a standard deluge name "ACCOUNTID" through which we access record values for particular selected record. e.g. potential_info = zoho.crm.getRecordById("Potentials",input.CS_Opportunity_End_User_ID); if(potential_info.size() > 0) { if(potential_info.get("ACCOUNTID") != null) { input.CS_End_User_ID = potential_info.get("ACCOUNTID").toLong(); input.CS_End_User
Is it possible to create a record in a Creator app from Zoho Desk?
We are analyzing Creator to find out if it's possible to integrate a Creator application into our service workflow on Zoho Desk. We want to create a mobile FSM (Field Service Management) application which will be used by our field technicians and they will be filling out the service forms which will be linked to service tickets on Zoho Desk. The process will be started by the service manager from a ticket record on Zoho Desk and the planned service details will be transferred to the service form
Auto populate form field from user login profile and recruit clientcontact field
Hi, I have created a form for our client to submit a job to our Zoho Recruit instance. When my client user login to the apps and launch this form, I would like to have the "Client Company Name" field in the form pre-populated based on the record in my Zoho Recruit client contact list. Is this possible? If so, how do I do this?
Form custom button to call dashboard
Hi Everyone, I have a form that I call from a dashboard page. I would like to add a button to the form called "Exit Form" to call the dashboard page making it appear to the user the form is being exited. Can you tell me how to set this up? If this can't be done, I can rename the text on the reset button to "Exit Form" but I don't know how to trap when the user clicks on that button and what deluge command I need to execute to call the dashboard page. Thanks in advance. Truly, Emad
Auto - Populate Fields from lookup on user input
Hi All Im fairly new to zoho creator. I currently have 3 forms which i have lookups on each form. I am wanting to Auto-Populate the "Owners field" when a Horse is chosen from the dropdown lookup on the form "Background Info". A few questions. 1) What type of Field Does Owners need to be on "Background Info Form" 2) Do i need to add or modify and of the relationship data as screen shot below? I have tried adding a workflow: (But it appears to be doing nothing) while a record is being created or
Can't update fields in subform rows
Hi, I am trying to work out a solution in a simple test application. I have three forms, Student, Class and Booking. There are M:M bidirectional relationships between Student:Booking and Class:Booking. In each of the Student and Class forms I have a Booking subform. i.e. In the Student form I have a subform that is supposed to list the classes the Student is registered for, and in the Class form there is a subform showing the Students that are registered. This seems like it should work. However,
Pending Purchase Order from client report
Hi, Is there a way to store and track client Purchase order's along with reporting so that follow-up with the client can be achieved seamlessly through the application? Renji
How do I import data from multiple fields into one with checkboxes?
I already have 1 existing simple application with just 1 table where I've entered data for a year or so. Now, I want to import data from a survey where one of the fields ("Products") can have multiple values which I currently have done in ZoHo with checkboxes. In Excel, the Products field is cell A1, and starting with B1 to about B10 are the possible values. Then B11 to about B15 has the other "regular" column headers like Name, Company, Email, etc. I've read a little about creating relationships
Cannot change Display Type of a subform
Currently using Creator 5. In this article, it explains how to change the Display Type of a subform to either "Grid Subform" or "Popup Subform." The article gives this picture as an example: However, in my existing subform and any new subform I create (either blank or based on an already created form), it only ever shows up like this in Field Properties: Is there a way to change it that I'm not aware of? Or is there a chance I misclicked some sort of setting to make it not show up? Thank you
Centering Text in Report List
I'd like to format the cell's in the list view of a Report. Some of the fields are right justified, however others are left justified. How can I format the cells so that I can right justify or center the text in the corresponding fields? Thanks!
Reusable Template
Is there a way to make a reusable template in Zoho Creator? I see that it's possible in Zoho Project. I need to create a list of tasks that I can use over and over again. Thanks.
Zoho creator 5 api
Hi, I'm trying to add records using my web page contact form to zoho creator form. using rest api: <form method="POST" action="https://creator.zoho.com/api/sineplusakademi/xml/sineplus/form/OGRENCI_ADAYI_EKLE/record/add"> <input type="hidden" name ="authtoken" value="*392c493bb37f3a82812c590ca4da2c98"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="text" name="Name" value="Gary"> <input type="text" name="DOB" value="12-Jun-1980"> <input type="text" name="Address"
Problem to add new values to a bigintList field
Hi. I have a problem adding new records to a multiple search field "Bigint list". I use the method list.add (value) but then it does not work, for this I have to convert to string, add "," + new value and then revert to list before assigning it to the corresponding "bigint list" field .. I do not think it works properly, but that's how it works. My question is .. can the new value be added simply by using the "add (value)" method? Since I think part of that when I create a new record in a form, I
Approval Workflow - create new record not working
I'm working on a referral workflow for our family database, and I've run into a snag... The referral form is for professionals (doctors, teachers, social workers, etc) to refer families to our program. Once a referral form is submitted and then approved, it should trigger a deluge script to create a new Deaf Child Profile record and populate some of the fields based on what was submitted in the referral form. I did have this process working without any issues at one point, but then a couple of
Edit report by record ID in zoho creator form
Hi, i have a published registration form and I want my user able to edit this form report. I've tried edit record with record ID and that's work fine. On my zoho site i create input form for user to input his/her record ID and after submit it, the form redirect to my form edit report page and that's work too. The weakness with this method is, i can't validate the record ID. it's my goal: user input his/her record ID on input form, if record id true redirect to edit report page, if record ID false
Zoho Creator Record Template
Hi guys, is it possible that we add a new column to total up one of the table field in the record template? currently it will list out all the value into few rows, i will need to get the sum of it, anyone can help? thanks Jeff
Performing a sum operation of values of dropdown
There is need to perform sum operation on all the values of dropdown field irrespective of number of value which is a look up field? is it possible and can someone please explain it?
HTML table
Hi All I have a very simple HTML code that I would like to use but when I enter it in the Notes it converts to an ordinary table. What I am trying to achieve is a table and when a cell is touched it changes colour. If anyone has any ideas of how I can achieve this I would be very grateful <table> <tr> <td onclick="this.style.backgroundColor = 'Blue';">Top 1</td> <td onclick="this.style.backgroundColor = 'Blue';">Top 2</td> <td onclick="this.style.backgroundColor = 'Blue';">Top
Formatting a phone number
Hi Everyone, I have a "Phone" field on a form that looks like 5161231234. I would like to format it so it looks like (516) 123-1234 Can you tell me how to get the number formatted? Thanks in advance. Truly, Emad
Next Page