Zoho Creator Sandbox Access Revoke
Hi Team, Can we able to create a sandbox for a application for different-different developer.I am unable to access my sandbox Its says "Access Denied contact zoho support".Then i Revoke the Sandbox then i am able to view the application. Question:- If somebody has created the sandbox for me and other developer has made some changes so all the changes will removed or not ?? what happend when i revoke the access of the sandbox.
IP change in Zoho's EU DC - May, 2019
Hello App Creators, There's going to be a change in Zoho's EU DC IPs. The following ranges will apply to both incoming and outgoing traffic: 31.186.226.0/24 is going to be replaced by 31.186.243.0/24 84.207.209.0/24 is going to be replaced by 89.36.170.0/24 Please ensure to update your relevant whitelisting instances accordingly. In addition to our changelog, we'll update here once these changes are live. Best, Lakshman | Zoho Creator
China block zoho creator?
my client travel to china and he complaint that the zoho creator mobile apps is not responding, web browser able to login but with extremely slow speed and that will not be able to use. Both zoho creator and zoho creator portal. anyone facing the same issue? any solution? thanks in advance.
Filtering a lookup via a multi-select field
Hi there, I have a filtered lookup called Assets which only shows assets that are added to a development. (Development A has Asset A and B, Development B has Asset A, Asset B and Asset C. When you select Development A you can only see A and B) That works great and is a multi select tool so if you select Development A, you can then select from Assets A-Z as per their record. What I would then like to do is have a subform where you select testing requirements (e.g. Asset G needs Test 1 and Test
Delete child record (from entire database) from parent form without deleting parent record
Parent Form: Incident Child Form: Task If I delete a Task from the "All Tasks" report, it is removed from the Incident Form. I used deluge scripting to delete the Task record when I delete the Incident record. If I delete a Task record from the Incident record (but I do not delete the incident itself), the Task remains in the "All Tasks" report. I need the Task to be completely deleted from the database if it is deleted from the Incident. Ideas?
zoho creator does not show stateless form when adding subforn
When modifying an existing form to show a subform, you have to add the subform into it. But when adding the subform field, the selector does not show the stateless form !! Any help would be appreciated Peter
Can Zoho Creator use API to talk to other systems like Google Places?
I don't need to know how to do this just if this is possible. With our current custom CRM, we have records called Buildings which are basically addresses, and then we list all companies at that address. We have a button that when pressed, queries Google Places via their API and in a popup shows a list of all companies at that address. The user can then select "Add" beside any of them, and it will automatically create a company record in our CRM with that company info. If that company already
[Suggestion feature] Allow for multiple emails and phone one field
Hi there, It would be nice to be able to input multiple email in one Email field. Here's a use case: an app for wedding organizers with a Contact form to store the client's information. A single contact consist of 2 people (getting married) and communication must always reach both. The normal method would be to use theses fields: Name field: Bob and Ann Phone #1: 123-456-7890 Phone #2: 123-456-7891 Email #1: bob@contact.com Email #2: ann@contact.com This requires report to always display the 4 contact
ZC to add request to ServiceDesk Plus with attachment
Hello! I have a Zoho Creator form that adds a request to ServiceDesk Plus via API. I need it to also add an attachment to the request when creating it, however I cannot get it to work. Has anyone done something similar? When using postman I can get the request with an attachment to go through (the attachment info is added to the body) but I'm unsure how to add a file to the body in the deluge scripts. Any help is greatly appreciated!
Merging creator apps
Is it possible to merge 2 existing creator apps into one? Other than manually recreating the forms, I am wondering how best to approach this. Thanks Sowmya
How to resend user invitation Zoho People
With the new interface of Zoho people, I cannot find a way to resend my invitation for a user. How do I do that exactly?
Custom app sending webhook to creator
New to this but I am not finding exactly what I am looking for. I have an application in Creator that I want my custom app to send information to. What I am looking for is the steps or an example please. Custom App in cloud sends json field information for example cust_id, firstname, lastname to any url when custom app triggers an event. I want to see an example of the Creator application that has the fields in the form to receive the information and populate the three fields. I believe my issue
Select and Deselect in a sub-form field
I have a script that will update a field in a sub-form here: Contacts_subform.Event_Role = "Venue Contact"; //(this works) However this method will remove all other options and only add this option. I want to be able to add a selection with select() and remove just one option with 'deselect()'. by using this: Contacts_subform.Event_Role.select("Venue Contact"); //(this does not work) Unfortunately I get the following error: 'Event_Role' does not exist in this form.
how do you guys create a custom calendar?
Hi, just curious how do you guys create a custom calendar? Is it possible for me to create a hotel calendar looks like the one that I attached? If it yes, what should I learn? HTML? ZML? I need a sort of table that could accommodate my user to see all the room list, status and how long the room will be occupied. I wonder this table also appear based on user record. Do you guys have any Idea or reference for me to chase my dream? I'm pretty new to coding or web programer things, but I'm eager to be
Upcoming updates - April 2019
Hello App Creators, During April, 2019, the Zoho Creator team will be rolling out the following feature updates: Updates w.r.t. Address and Location Panel builder and Gauges in Pages Kanban Report customizations Ability to search and sort records using the subfields of Name and Address fields Currency field formatting In addition to our changelog , we'll leave a comment below as these items are rolled out. - - - - - - - Updates w.r.t. Address and Location Applicable to : Zoho Creator 5 Note : This
Lookup field renders incorrectly (ID instead of value) when used in record template
I have a custom record template I send using sendmail as an attachment on button click in a report's record. Most of the fields show up correctly but one field which in the corresponding form is a lookup to another table shows the IDs instead of values. Any idea how to fix this? See the last row "Products of Interest".
How the data may affect the one application by updating another application.
There are two different java based applications. Application1 and Application2 Suppose a user has registered in application1 and just after clicking on submit, the user must have checked in application2, whether the user is present over there or not, if not then the user should have registered in application2. And the process should be automated. like when one user is inserted in application1 then right after submission if the user is not present in application2 then the user must be inserted.
Deluge map question
I'm creating a custom function that will create a record in zoho creator using payment record information from zoho books. I've been able to successfully create a record in ZC but I'm unable to get the invoice_id from the customer_payment map. Below is the code: paymentMap = Map(); //set order to payment invoice id - this is not working paymentMap.put("Order",customer_payment.get("invoices[0].invoice_id")); paymentMap.put("Description",customer_payment.get("card_type")); paymentMap.put("Payment_ZB_ID",customer_payment.get("payment_id"));
Holiday Self-Scan
I am working on a HR application that needs the functionality to let employees book their on holidays for approval. I want this holiday to be tracked and to tie it to a certain number of days. For example, the maximum holidays per year is 30 days. How can I set up the holidays so that when a holiday is booked it takes that number of days away from the 30. I would also like a way of displaying hw many holiday days an employee has left. Thanks!
Adding a visible .PDF to a form
Good evening. I've created a form for my users to complete. Is there any way i can attache a .pdf to this form so that before users submit the from they are able to view/download this pdf and then agree that they've read the pdf. Thanks, Matt
What upgrade do I need to publish as an app
I have a zoho app built in app builder, but it says I have to upgrade to use it. I am a Zoho One account holder, so not sure what I am upgrading too. Can anyone here help me.
Help with function
Hello, I was wondering if someone could tell me why my function is not working. Here is my function that I have: String Bar_Code(String X) { //remove serial if(X.contains("--")) { sku4 = X.getPrefix("--"); } else { sku4 = X; } //Find Book if(sku4.contains("97816804") == true) { Book3 = Books[Barcode == sku4]; } else if(sku4.contains("9781942") == true) { Book3 = Books[Barcode == sku4]; } else if(sku4.contains("9780934") == true) { Book3 = Books[Barcode == sku4]; } else { Book3 = Books[Book == sku4];
Creator Evaluation Questions
Dear Zoho Community: We are evaluating Zoho Creator for a potential ERP solution for our social enterprise. We need a combination of POS, Inventory Management, People / Customer Management, and a few other custom modules. While reviewing, I had a couple of questions, the most important around the integration of various Zoho apps. First, a small (and hopefully simple) question - who exactly is the user that Creator's pricing is based on? Any and all staff who will interact with Creator? For examplme,
Append value to field without replacing
Hi, We are attempting to set up a field ('Source') so that when updated a value is added to it rather than merely replacing it. In some other CRM systems it is possible to do this by beginning the value to be appended in the file with a semicolon ; or comma , - is there an equivalent functionality in Zoho? For example, a contact has 'Subscription Centre' in this field. Is there a way to format an upload where the field is 'Event Form' such that after the upload/merge the field reads 'Subscription
Adding SubForm rows via script
I am having a hard time figuring out if this is possible or not to add rows to a subform through script. What I want to be able to do is have a stateless form where I indicate the record to be updated and the record to be updated from. It works fine for all of the info I want to duplicate expect for the subform data. The subform are bidirectionally linked to the main forms, but I can't figure out a way to add them to the record getting the duped data. I would love some help. -- Gabe
Error on subtracting variables '1.50' and '0.00' due to mismatch of types
I have a subform where users can add rows and in the rows articles for sale But for example if a row is not filled and the user wants to delete the row again by the delete button I get the error notification: Error on subtracting variables '1.50' and '0.00' due to mismatch of types Hope somebody can help me. With kind regards
Navigation between divs always loads the whole html page
I would like to create an html page in ZC5 in which I will have 2 buttons and 2 divs. When I click the first button it will navigate to the 1st div and when I click the 2nd button then to the 2nd div (in the same page). In the future I will add more buttons and divs. As a very example <a href='#restaurants'><button >Button 1</button></a> <a href='#cafes'><button >Button 2</button></a> <div id="restaurants"> <p>Text 1..........</p> </div> <div id="cafes"> <p>Text 2.............</p>
New Form not in list on Looup field creation
Hi All, I am doing some mods to an app called Call Logs and I have created two new forms for data entry. I am trying to do a lookup from one to the other but when I drag the Lookup field onto the form and it pops up the available form options, my new form is not there. Searched all the settings but can't find anything like make visible or similar Can anyone help? Cheers, Greg.
subform popup
In my app I have a form that contains a subform. The subform contains a lookup field that selects inventory items that are stored in a separate form. Everything is working correctly so far, but what I'm wanting to do is thus: If the subform has a line item entered and I edit a field (could be a decision box), I need a popup window that opens the record of the inventory item which then can be edited and updated. I've gotten everything to work except for having the specific record open. Instead it
Send Email to Group of Users Selected in Multi-Select User Lookup Field
Hi- Users in Form A select employees in Form B to send emails to. The email addresses of employees in Form B is set through a user lookup field called Email_Address. On successful submit of Form A, I'd like to send an email to all employees selected..I have the following script, which is not triggering an error but also is not triggering any emails....does this have something to do with the source of the email address coming from a user lookup field? for each r in Employee_Database[ID = input.Assigned_to]
Calendar Actions - On Click of Available Time/Date
Is there a way to have a stateless form open when clicking an available Date/Time on a calendar view instaed of having the default Add New Record Form?
Customers to see entries from other customers in a report AND Approval query!!
Hi there, I an app which a sort fo banking app for my company. I need to know how to do two things: 1. Allow 2 customer to log in and see exactly the same information as each other. For example if one customer enters a form and this then shows on a report i want the other customer to be able to see this report and the information the other added. 2. This is an approval system i need in place. I need one customer to log in and fill out form. Then another customer to log in and be able to approve said
Coloured relationship diagram arrows
I suggest to distinguish single-select and multiple-select lookup fields in the relationship diagram by using different arrow colours when hovering over them. Currently all arrows are shown in blue.
Trouble Setting Multi-Select Field on User Input
Hi - Having trouble getting a multi-select lookup field to pre-populate based on user input. Form A contains list of all Employees and the Location where they work. Form B creates new projects and includes a lookup field to Form C containing a list of project team groups and a multi-select lookup to Form A allowing the user to assign employees to the project. I'd like it so that if the user makes a certain selection for the team group (say, "New York Employees"), the multi-select field will pre-populate
Doubt about iteration limit
Hi, I'm building a couple Apps and as of now I'm not having any iteration limits problems, however the lines are piling up steadily and fast... Hence the concern My question would be if a "for each" script counts iterations from the raw amount of lines of the table or if it counts the iterations per result in which it has to act. Ex: I have a form with 6000 lines and it contains a field "Color" and 100 lines have "Green" color, if i do a "for each (Green)" script, it will count a hundred iterations
HTML Pages Background - No Control
Am I able to create HTML pages with full screen HTML? The way that Creator has the panels, it always looks like an iFrame and unprofessional. As of now, I can only create a floating panel look. This may be Okay for some internal needs but if I am going to consider building apps to go to market with, I need to be able to have the app look like any other basic app. Anyone have any ideas regarding this? Creating a custom site and then connecting to Zoho Creator seems a little overboard and lots of
JSON list/array not able to parse
I am not able to parse json list in Zoho Creator. JSON starts with square bracket [ ] . I am not able to convert it to list for looping through it. [{"device_id":"297e79be208d1db191a7e2c0cdc3eb4413c939d9","device_type":"computer","device_url":"https://dashboard.panorama9.com/portal#assets/hardware/computers/297e79be208d1db191a7e2c0cdc3eb4413c939d9","manually_added":false,"name":"JOEPC","alias":"","manufacturer":"Lenovo","model":"20DH002TUS","serial_number":"PF0BEC36","cpu":{"manufacturer":"AMD","model":"AMD
Two way reports on Meetings and People
I have what I thought was a very simple requirement for a small application: In Contacts Form, I have a list of people In the Meeting Form, I have a list of Meetings Contacts attend multiple Meetings, and Meetings have Multiple people I need to generate two reports: 1- For each contact, the list of meetings attended 2- For each meeting the list of people attending And be able to enter quickly the contacts in each meeting or the meetings attended by each contact. Thanks
How can I get a date in date format only without hours
Hello, I need for flow to close a deal a current date in the format "dd-MMM-yyyy" I did this function: string today() { return zoho.currentdate; } But it return : "today_7": "08/08/2019 00:00:00" with hours. ==> Do you know how I can write the script to get the date format only Thanks for your help Have a nice day
Formula to show the amount of months and days between 2 date fields
Hi Please would someone help me and provide me with a formula to show the number of months and days between 2 date fields. I can only work out how to show the number of total days, but was hoping it could read as: 4 - Months and 29 days Many Thanks Peter
Next Page