Create local variable that persist until form is submited
Hi, is possible to create a variable that persist until the form is submited ? I know is possible to create helper variables in the form, but sometimes this lead to having a lot of useless variables that persist with the form. So Im looking for a way
I don't understand why I get this error?
I don't understand why I get this error? In my mind both fields are TEXT.
Zoho Docs Integration with Zoho Creator
Hello All Happy New Year! I have purchased Zoho Docs and Zoho Creator. I have made an application in Zoho Creator. I want to integrate Zoho Creator fields in Zoho Docs/Writer. Any idea? Thanks in advance! Best, Farzana
How to get current day of the week?
I want to have a field that automatic show the current day of the week. I already have working a field to show the currente date; i used "Data=zoho.currentdate", but don´t figure how to use the day of the week (? .getDayOfWeek() ? ). Where I put it? What is the right code? For the working field I choosed: Form actions > On Add > On Load Field actions > On User InpuAnd for the day of the week? Tks
Delete Blank Records
Hello, I'm very very new to database and Zoho. I imported a spreedsheet from Excel and when I do, it brings tons of blank records. Now that those bland records are on my report, how can I I do a mass delete to delete all blanks. When responds...please don't get too technical. I'm very new to all this. Donna Z
Auto regenerate Pivot Chart
Hi, I'm trying to find a way to have a Pivot Chart automatically regenerate itself, rather than having to do it manually for each pivot chart. I have embedded it within an internal corporate management website page and was hoping to be able to eventually add a couple of charts for other projects to the page. The goal was to track status of a project without having to individually go to different Creator applications to look at the charts. However, the charts seem to only update if I hit the
Fields don't appear to update on bulk edit
I'm trying to make a bulk edit but only few columns appear in options. Is it a problem or zoho creator has a limitation? Thanks
Changing the favicon on a Zoho creator app
Hi, How can I change the favicon on my Zoho Creator app? At the moment the red Zoho favicon is showing. I searched for Favicon in the help and didn't find anything. Thanks,
Can't Add Developpers (Users) to Zoho Creator App
Hello, I've been using creator individually for a little while now, Recently, I wanted to add one of my co-workers as a developer on our app so that they could also help with troubleshooting, development and scripting. However, whenever I try to add
Add DateTime and location upon successful form submission
I am doing a check-in and check-out form. How can I automatically add the current datetime to the record, upon submission of a form? And is it possible to also add the location of the person submitting the form?
Report Customization
Hello, I am a complete newby with Zoho Creator but have managed to start a relational database. Now I have a problem with the 'Report Customisation'. The first view is as it should be with 'Quick View' and 'Detail View' available. But in some Reports
List all portal users
Hello ! Is it any possibilitie to list all portal user by application in Deluge task ? Thanks Aurélien
FORM in edit mode not visible?!
Any idea what can cause the FORM for which I have a VIEW not to be visible in the edit mode but can be seen in the Data Entry mode? Thank you.
Zoho creator + zoho books integration
So been given this recent task, create a form for new customers and integrate it with zoho books. I know almost nothing about Deluge or zoho platform. anyway this is what i have achieved so far: 1-Create the form ✅ 2-On form submission->create new contact
Zoho Inventory Integration - Zoho Creator app
HI , We have started on a custom app from Zoho Creator and made some customizations into it and now want to integrate it with our Zoho Inventory . Please let me know if this is posssible?
Create Product, Quantity
How we achieve this? Task 1: Create form to store the products Task 2: Whenever the product is purchased, the stock should be increased Task 3: Whenever the product is sold, the stock should reduce
Create Multi Entities Portal over (or above) Portals
Hi all, Case: Solution is build in Creator to be used by clients of multiple offices. Each office is an independent company with its own unique customers. Is Creator able to create a 'Super' Portal te manage many offfices and give them the admin right
rebranding more than one logo
Hi, I have developed two applications for use with two sections of my company, with two different logos. I have found that the logo currently is universal, i.e., appears on all apps under my user account. Could you work out a way so that we can rebrand app specific logos? Thanks!
Concat more than two values
I want to concat more than 2 elements. For example --------------------- variable = 5; Message = concat("you have", variable, "days left"); --------------------- The above code doesn't work. Any advice? Sorry for this noob question.
Map Dependency Fields in Creator
Hello, has anyone been able to map field dependencies in creator like you can in CRM? i have an app i have built for inventory and i would like that when i click on a manufacturer in the model field it will only show the certain ones for that manufacturer.
Fetch data from form to form but different apps
Hello I have a question and I am beginner in Zoho Creator. My question is it possible to fetch data from form to form but the apps will be different for example I want to make two form and the first one will has as input 'Admission ID' and same for the
What happens to Zoho Creator if Zoho goes bust?
Hi, I am doing a risk assessment for my business at the moment and one of the most obvious risks is 'Zoho goes bankrupt and stops supporting Zoho Creator'. What is Zoho's policy here? A similar question was asked about Zoho Mail. The answer there was 'you can export your data'. That's fine for data but how about code? What use will Deluge script be if Zoho ever folds? Would Zoho release the code for the platform if they do go bust? I notice there used to be an option to run Zoho Creator apps on Google
how to change creator's GUI language?
Greetings It seems that zoho creator detects your region and sets the GUI language to that automatically..first of all this is just a bad idea, let users choose their preferred language or just import GUI language from user's account settings. my GUI
Multiple openurl statements "On Success"
How can I open multiple windows on success to print various record summaries? Right now if I have multiple openurl statements it just opens the last one. Any ideas?
Hierarchy of Menus
Right now the menu options are a limited to two levels (the parent and child), and can get crowded if you have a lot of forms and views in your database. Are you planning to add a feature with Menus and Sub-menus (e.g., grand children, great grand children) in a hierarchy, so that space can be better utilized?
How to include css/html on all pages in a Customer Portal?
Hi all, Im currently building a customer portal in Creator. What the best process of adding external css styles and html so all the pages in the customer portal have the same style? If this were a website I would create a header/footer php pages and include
How to Test for Null Value
Hi I have 4 snumber boxes in a form. I dont like the default value being 0 as in mobile form i have to delete it each time as i type in correct number. However I have the following forula in code where i have a x b + c + d. Works great as long as i
Value is empty and 'get' function cannot be applied
I'm having a problem with a creator app and hoping someone can help me understand what's occurring. Our business creates lumber products for wholesale and we sell scraps as retail for firewood. We have a creator app that is meant to be our office Point of Sale for the firewood. The problem is that when we attempt to finish an "order" for a customer we get the following error - "Error in executing On Add - On Success script. Value is empty and 'get' function cannot be applied Line: (79)" The
In "Configure add record action" how do I set the value to whatever was entered in the form?
I am attempting to use data entered in Form1 to create a record in Form2. I simply need to set the value of Form2.Field1 to the value that was entered in Form1.Field1. Unfortunately the "Configure add record action" only seems to allow me to specify a
"form does not exist" error when embedding iframe code on site
I successfully created my form and clicked on the embed code on website, iframe, but when I put it into my blog (blogger) it says the zoho creator form/app does not exist. I clicked on the make public button and tried a variety of ways. I am able to get the form spreadsheet embed code to work, so not sure what to do next. Any thought appreciated Carol
Zoho Creator Custom domain Error 400 and SSL issue
Trying to setup a custom domain for a Zoho Creator App Added sub-domians Verification was successful But we see Error 400 and https is not working properly. Our Zoho account is a premium so this feature should be available to us (we already did it
Where to find decent video tutorials on Creator customer portals
Hi Does anyone know any basic tutorials on how to create a customer portal and how to create a form that updates a module record in CRM? The few videos Ive found are tortuous to watch with mistakes happening during the video! I need professionally produced
API call of avarage
Hi how can i obtain via api call the avarage of a field (Sales) of records from one specific day_? i know i can get this info in a snippet on a page but i want to know this value avarage of all via API also i can get this value on a pivot table but pivot
What is the fee structure?
Hi, I need a portal that allows about 300 customers access to edit their details in our Zoho CRM. CRM's portal is very limited, so Im thinking about using Creator. How much is it for Creator's Customer portal for about 300 customers? Thanks
Your current plan allows only demo of the SubForm.
Hi,my self satya,i am new in zoho creator.When i tried to save my form information it will show "Your current plan allows only demo of the SubForm." so anyone can tell me how to solve this issue.
Creator 6 - What's your experience so far ?
My company are looking to make the switch frm C5 to C6 but I am curious to know what everyone's thoughts are in general and if there are any bugs or hesitations that people have experienced.
Update to Form Fields Error
I am making changes to zoho form, while viewing application, it shows. but other account roles do not see the new input box that has been added. I need help, please.
How to setup default page in Creator when user lanuch APP?
How to setup default page in Creator when user lanuch APP?
Can custom functions return an entire fetch?
It seems, and I've been told by Support, that custom functions cannot return the entirety of a fetch: only the record IDs are returned. I've tested various ideas and I've confirmed this to be true. I can use the record IDs returned by the function to
Field with reamaining time to deadline or overdue by
hi im trying to achieve a field or a widget that lets me see at a galce remaing time to due date or overdue by ... y have tried the following on a formula field but doesnt update
Next Page