Stripe payment gateway
Hi Zoho, Any update on when can expect creator/checkout integration with Stripe payments? 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
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
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
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
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
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"
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
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
Sendemail depending on subform row
We have a tracking subform with date/status of shipment. Every day we have to update the status twice, adding in every update rows depending of the status. We have created a some sendmail actions when editing wich depends on the status. We need send the email depending on the most recent status updated. We use on success, for each record, if but the email sent always is the first status on the subform, not the last row status as we need to be. could you help us with the script?
I need to pass record IDs of selected records via formobject
Hi, I need help in passing recIDs of selected records via form object through custom actions function to display them in html page as a tabular set of records. when passed to htmlpage it only displays the last record currently from the selected list
Import Addresses from Excel
How do I go about importing a list of clients and their addresses from Excel to a Creator form? I have a few fields in Excel with street 1, street 2, city, state and zip. How do i import to the address field in Creator?
DELETE http Method Deluge Script
I need to use a DELETE http Method to interact with my offline front-end form application. I use the other methods like get, post and open. Is there a deleteUrl script that I can use? If not is it in the future upgrades? If not is there a work-around? What about other http methods, like PUT? Any help would be great!
AYUDA EN ESPAÑOL SUMAR COSTOS EN SUBFORMULARIOS
Hola, espero que me puedan ayudar, tengo un subformulario en el que puedo agregar varios items con un nombre y precio, quiero que ese precio me lo sume el sistema y me muestre el total en el Formulario principal para así sacar un costo total del registro, muchas gracias
Book seat Template
Hi I am trying to adapt the book seat template and I cannot find where to change the number of "seats" to change it to 2 rows and only 22 "seats" I also need to change the seats to another picture - a truck or even a square. Thank you for any assistance you can give Thank you Amanda
Dynamic Picklist, Lookup, Dropdown
Hi, I wonder if anyone can help. I am trying to create a dynamic lookup dropdown with a filter/criteria as per the documentation and example dynamic picklist application below: https://creator.zoho.com/sampleapps/dynamic-picklist/#Form:Registration_Form https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html I have tried replicating this functionality in my own app, and have also created a copy of the sample app in my account. Unfortunately, both methods produce the following
HTML Snippet - Image Size Issue
I have placed a .png image in an HTML snippet on a page. Sometimes the image shows in it's full size when the page is loaded, however, it sometimes shows on only half the image and a scroll option appears on the right side of the panel. Once the page is refreshed, it usually shows full size again without the scroll option. Any way to force the image to show full size consistently when the page is loaded?
Failed to submit data"
Please be informed that when i connect the internet and synchronize im getting a "Failed to submit data" . Kindly check my account and advise accordingly. Jaeman
Different users are unable to search records
The following call is made: crmAcct = zoho.crm.v1.searchRecords("Accounts","(Account Name|=|" + acct + ")"); This call works successfully when the call is invoked by the Admin. However when a non admin user invokes this call I get the following: Invalid collection string Line:(10) Any help would be greatly appreciated.
Sum total displayed both metric and US
On my application I have batch reports. On Each batch the Kg of each item added to the batch is recorded. I wrote a report that sums all the batch records by the LOT number of each item. What I would like to do is to display both in Kg and in Pounds. The batch reports are entered in in Kg, the receiving is recorded in LBS. I would like to display both on my report so when it sums up the number of Kg used in a specific lot # I would like the report to also display that value as Pounds. I know
Pre-added text or value inside rich text or multiline?
Hi, I am looking to add a mass of text and information that is editable by a user once they are using a form - this is so the user later on can produce a custom made document (after a certain format). So it will be an example text that they can either leave be (and accept) or alter. But, I haven't found any way to pre-add text into any of the utilities in the form-builder other than as a tool-tip or help text. Any way or idea on how I can execute this? In some other, much more simple and web-based,
How the frak do we OAUTH2 w/refresh_token out of creator?
I'm using EVE Online's OAUTH as a testbed (mainly because I know what all the responses will mean from my time working at CCP). Fair note: I'm not a programmer/coder, and this was my FIRST EVER attempt at generating a script. Took about an hour to get it to validate and save, but I DID get that far! Here is what I've got so far: Published a public creator page with a button that triggers the login and initial authorization Redirects to a published creator form that catches the return values authorization_code
How do I add Search Parameters when creating a HTML Page for a Search Interface.
Hi there, I am trying to create a search interface. I understand that a stateless form has to be created and on clicking the button, it will be automatically redirected to a html page based on the input's given in stateless form. I know that 'open url' deluge task will be used for redirection but how do I filter the records to match the input given in the stateless form, I again understand that search parameters are to be provided but How do I provide these? Where do I provide these? How are these
Link to form entries
Hi, I'm new to Zoho, and I have a hopefully simple request. I have form called Clients that holds client information, and that has a 1-to-many relationship with an Events form - multiple Events can be linked to one Client. In the Client report, I can see the names of the Events linked to the Client record, but I want to be able to click those Event names to go to the Event record and make changes to it. Here's an example from the Client report: The lookup field in the Client report is listing the
Combine data from lookup fields to text field
Hi. I trying to merge data from a couple of lookup fields with other fields and place them in a multi field. Here's the script: input.Map_header = input.Property_Owner_Agent + " " + input.Property_Name + " " + input.Address; Property_Owner_Agent and Property_Name are lookup fields. This is for the Map Report popup box. The below photo shows numbers instead of the names. The address seems to work although I'd like to get rid of the county and country. Please help.
Next Page