Subtract the value of the field in the subform from field in the mainform, When user deletes the record in Subform
Hi, i have a field called subtotal in the subform and a field called GrandTotal in mainform, when user deletes the record from the subform i want to subtract that value from the GrandTotal . Please help me with the deluge script . Thanks in advance .
About zohot
How to get a number as User input ?? and How to process it ??
Toggle for Iframe or PopUp in Pages
So the default behavior for the edit button in embeded tables on a custom page is to load the edit form inside the iframe/table. If one has multiple tables on a page, some of these tables are only 100px hight. To load the form in an iframe makes for a horrible user experience when the iframe/form is only 100px height with a scroll bar. The only way to get around this is to create a custom button/action that would edit the form in a pop up. Now I have over 20 tables in my application so now i have
Zoho Creator filedownloader
Hi everyone, I need to download all file uploads from my Zoho Creator account because we lost our external backup with the pdfs. But the filedownloader does not let me log in to the account (incorrect passwort or username) which I double and triple checked is correct from my side. Is this a known problem? Any other ways do download all the files? Thanks in advance for your help
Zoho data storage in Canada
We are thinking of using Zoho Creator to create an app for patient information. For information loaded into the zoho creator app, can the data be stored on a Canadian server?
Creator 4 subform hide delete
I have not been approve to upgrade yet, so I'm still using the old creator. I have a subform that has a red "x" to the left of the each entry. When I hover over it, it says "remove." I cannot figure out how to hide this. I do not want users to be able to delete these entries. Is there a way to disable this delete? Thanks in advance!
Return the days between 2 date fields in a list
Hello, I have two date fields "From" and "To" I would like to return a list with the dates between these 2 fields. How can i do it? Example: From: "15/9/2019" To: "18/9/2019" List: {15/9/2019, 16/9/2019, 17/9/2019, 18/9/2019}
Upcoming updates - August 2019
Hello App Creators, Before the end of August, the Zoho Creator team will be rolling out the following features updates: Pin customization in map reports Criteria support for schedules Enhancements to rebranded mobile apps New UI for groups We'll comment below and update our changelog as these updates are made available. And here's the link to our previous post: Upcoming updates - July 2019 - - - - - - - - - Pin customization in map reports Applicable to: Zoho Creator 5 It's here! A feature that many
Update Date Field(AddDay)
Hay, I have three fields 1. Terms- is lookup field - number field from different form 2. Today's Date - is date field - which is zoho.currentdate 3. Due Date - is also a date field i need whenever any number put in Terms field, automatically that numbers of days add on Due Date field example if Terms - 10 Today's Date - 6 Sep 2019 Then Due Date - 16 Sep 2019 Is That Possible ? if Yes then How ? Any Help is Appreciated . Thanks in Advance .
Has ANYONE had a Bad experience migrating to C5 from earlier versions?
I have some large C4 apps and am looking at the upgrade as I am told the deluge framework in C5 is faster and will then allow me to use C5 features like the kanban report. BUT I don't want to dive into other bugs or issues with C5 at this stage... anyone had any experience they are willing to share???
Retrieving image file size and dimensions from an Image Field
When an image is uploaded into a form, I need to get its file size and dimensions for validation. Is there a way to access this information? Perhaps using Deluge?
Parsing json response in deluge Script
Hi, I am using a rest api call which returns the response in JSON format. How can I process it in deluge script to get access the values from that response? For example my response looks like this, {
"name": "mkyong",
"age": 30,
"address": {
"streetAddress": "88 8nd Street",
"city": "New York"
},
"phoneNumber": [
{
"type": "home",
"number": "111 111-1111"
},
{
"type": "fax",
"number": "222
zoho integration with salesforce
how can i integrate zoho with salesforce
Connecting to an Oracle Database
How can I connect to an Oracle database inside my company so that certain data and charts are refreshed periodically?
Dynamically Filter Street Address Lookup Field
Hi - Form A collects data for incident reporting. It includes a lookup to Form B that includes a single standard address field. Is there any way to dynamically filter the address field when completing Form A, either through a series of separate fields, i.e., Country>State>City that lookup the same address field in Form B, or within a single location field that drills down as the user inputs Country>State>City. Hoping to do this through the single address field in Form B without separately collecting
Send Email - <table>
hello, i have a form i which your fill ifnormation with products, quntity, price, etc, (you can select multiple products) and after you hit "Submitt" button an email is send with the detail in a table, but the problema y have its that all proctus, for example 4 products, are filled at the same row and i need to be filled in one row for each product. information is showing like the image below: next its my code if you could help me please: sendmail [ from :zoho.loginuserid to :Despacho_Realizado.Customer.Email,Despacho_Realizado.Customer.Email_2
Rename a Templat as PDF
Est-il possible de renommer un modèle lorsque nous avons envoyé un courrier en pièce jointe? Par exemple, j'ai un modèle nommé "" DevisJour "" et quand je l'envoie par courrier, j'aimerais le renommer "DevisJour & N°" où N° représente le numéro de dossier renseigné dans le formulaire. Merci de votre aide
How can we shared creator app to public ?
Hi ,I have a customer who wants to create app which will be shared with its customer. Customer should be able to book appointment via app and pay via app. Customer will also get various reminders and offers via push notifications. In this case, number of customer is not fixed so how can Zoho creator license will work ? If my client has 500 customer does he requires that many licenses ? Regards, Nishith Shukla
Let's talk about Zoho Creator 5 (2018), Online App.
Hi everybody, I'm a fan of this product. So much potential ! Why are you guys not communicating about this product ? Promised by the end of 2017, it's now expected in 2018... Any issues ? Beta testing ? Unsolved bugs ? I was analyzing and testing (virtually) the plans from my subscription page when I have been pleasantly redirected to what's looking like to be the new Zoho Creator homepage. But no one is talking about it ? This page also leads to a new subscription plans that won't make everyone
Scope a zoho creator app
I’m developing a checklist app with zoho creator, so that each checklist is scoped to a particular entity and year. What’s the best approach to select and “scope” all forms to a specific entity and year, so the user doesn’t need to provide those details in each form/report/page?
How to display specific data in a form ?
I am trying to create a form for entering data of received orders of a store . *The products vary according to the store My requirement is to populate products according to the store selected . I already created a form for adding products in that while adding i made a drop down label for mapping the items to the store .
Multiselect Lookup field not available in Form Builder?
I need to create a Lookup Field where the user can select a single item or multiple items. The User Guide says to use the Display Type in the Field's Property Sheet to select "Multi-select" to achieve this. Yet when I use the Lookup Field's Property Sheet, the Display Type is greyed out and disabled. My Lookup links to a table of items which I want to be able to ad to - so I don't want to use a Multiselect field type which only allows for a static list of items. Can anyone advise me? Thanks!
How to use a template and send information somewhere else
I used Creator to build a form. I successfully created an approval process. I also successfully created a contract template with fields mapped to the form. However I cannot figure out (and the Zoho developer I worked with couldn't figure out) how to send the approved form information into the template and output into the CRM and attach to the account. In other words, the approved form data is stuck in the Creator app and I don't know how to export it to CRM nor how to use the template. There should
Reduce image size uploaded by user
Hi guys, is there any workaround that can reduce or resize the image uploaded by user as in the storage size provided by zoho is limited. thanks Jeff
CRM API V2
How to create auth token using deluge script for v2 api for CRM ? as they share "https://www.zoho.com/crm/developer/docs/api/access-refresh.html" this document for createing auth token required lot of steps. and for this browse mode auth token does not support for api v2. deluge does not support for redirect url extracting data for get auth token form redirected url.
Wrong language of zoho creator's app
I have installed the zoho creator's app version 5.17.1 on my iphone 7 version 12.4. The OS language is set to (swiss) german. Unfortunately, since a couple of weeks, the zoho creator's app appears in dansk language! log in = Log ind, logout = Log ud, settings=Indstillinger, and so forth. I have deleted and reinstalled the app but the bug remains. I want to use the app in german as it used to be. Can you please check this bug? Kind regards, Daniel
Zoholics Developers 2019 - Get special discount!
Hello App Creators, Zoholics Developers is coming up on October 2-3, 2019 in Pleasanton, California. This is a great chance to meet our experts in person and learn about Zoho Creator's latest features and best practices. You can also get a sneak peek of what's coming in the world of Creator. Our product experts will show you how to: Get started on the Zoho Creator 5 platform Set up forms, reports, smart data import, pages, and more Create unique mobile and tablet experiences Integrate third-party
Filters and duplicates are not working.
Hi guys, today I got a problem when I tried to duplicate report not able to duplicate the reports and all filters that were worked yesterday crashed! and even when i try to create the new, they are not working too. Please fix it or let me know what went wrong. Best, https://prnt.sc/p1lh82 https://prnt.sc/p1lh82 - filter described https://prnt.sc/p1li2h - issue
Creator App details not saving in CRM
I have had a creator app made to create quotes for vehicles using an API to return vehicle data. It is NOT saving these quotes into Zoho CRM (Quotes). I have an error message appearing and need some advice on how to repair this and if I need to do anything over and above to have the quote put into CRM (do additional fields need to be added etc):
New Address Field - Have you tried it???
At the Zoholics conference in Pleasanton a few months ago it was announced that there would be a new Address field. Instead of using multiple fileds for address, city, etc. this would be an all encompassing field that would allow you to enter all of the info in one place. Has anyone used this yet? If so, how do you access it? I'd like to try testing it out with my app.
Fetch Last Record for Specific Form Entry ID
I am having an issue retrieving only the last record for a specific form entry. I have a form named Morning Report. Users select their project from a lookup in the form to populate a new entry specific to a particular project for updates. When they select the specific project, I need the form to auto populate the last entries of some of the form from that specific project. Right now, if another user enters in another project, the form pulls the last entries from the last entry no matter the project.
Can I change how the ID field within the Zoho Creator Add Record API response is created?
Hello, Upon performing a POST request to the Zoho Creator REST API (Add Records), a response object is sent back to me which contains an ID field. Can I change the way in which this ID field is created? I would like to use a specific format for my ID's. Is it also possible to add other field in the response object that is sent back to me? If so, I could a create a separate ID field and make it such that this new ID field is included in the response object.
Create Reoccurring Calendar Events in Calendar Reports
Hello, I was wondering if there is a way to create reoccurring events in a calendar report. For example, how do I create an event from a form that reoccurs every month? Has anyone had this issue and created a workaround? Does the Creator Team have plans to integrate a re-occurrence frequency when creating calendar reports? The feature is crucial to the integration of this application. Thanks in advance! Jake
Menu Top Bar instead of sidebar
In the CRM application (from Zoho Creator catalog) the forms/reports/pages list is shown as a top bar (navigation menu), instead of in a sidebar. How can I do the same in my custom app?
Creator API call via PHP not working.
I am trying to write a php application on our website that retrieves our list of members from the creator database we have. Unfortunately the info and descriptions I've found so far are rather poor or outdated, so I am working somewhat blind in making this work even in the most recent examples I've emulated. I do successfully retrieve a ticket, and my login, password, apikey are obscured for obvious reasons. My goal is to read records from a view "PHCP_Members_Know_Location" I've already created
Updating Added User & report visibility.
I have an application where different users login in and track their time allocated to a job. In the report view I used to be able to only show the logged in users records. The problem I have is that I have downloaded a CSV of all the records, updated a few things and then re uploaded to the system. It appears I have lost the "Added User" element. Previously I could use this formula to restrict records: Added_User== zoho.loginuser However, because I uploaded it it has loaded myself as the added user.
Email PDF Report on approval
HI, I would like to set up a workflow that sends a copy of completed form once it has been approved. Any idea how i might do this? Thanks in advance. Dan
Sending an email 4 weeks prior to a date field
Hi, I have a form that has date of a customers next service. I would like to have the app automatically send the customer an email when this data is 4 weeks away. I think i have set it up but it sends the email everyday?!? Any ideas on the best way of doing this? Many thanks
How to insert image (from the field in submition form ) into email notification
I want to send user data to another email and i can inser all fields excepts image field. Why? and how to use this field in email notification?
Sending an email notification when a quantity in a report reaches a specific quantity
I have set up a form PPE Disbursement for our inventory that has a subform to enter quantities used and quantities returned. The amounts entered in the subform update our quantity on hand in another form called Add PPE. This Add PPE holds the fields PPE Description, PPE category, Total on Hand, and Inventory Reorder Level. We will use Add PPE to update records when an inventory count is completed. I have been able to set up so that an email notification is sent when this form is edited and
Next Page