How to manipulate CSS from Forms inside Zoho Creator?
I want to embed a FORM inside a page, but I want to make the CSS prettier.
Zoho creator workflow Issue
Hi There, I am trying to create a workflow to one of my inspection forms. The flow should be as follows; The user creates a form and send it to the approver Approver checks it and signs the form (or reject it) From what I can see once the form is submitted to the approver, the approver can't sign on the actual form. Is this something you can incorporate to the form? Or once the form is approved, is there a log to show who signed the form and on what date? Regards, Lou
Lookup field auto populates single-line field. Then recurring lookup.
Hi. I have a series of eight forms that I need to be linked by a single entry in order for my app to work. Any clear and simple help would be much appreciated. I have a dropdown lookup field on my first form that pulls a vehicle registration from a ZC database. This is called Vehicle_Registration. Below this, on the same form, I have a single-line field called Vehicle_Type. In the database, every vehicle registration has a corresponding vehicle type. So, I would like the Vehicle_Type field
Disabling/Enabling SubForm Fields based on Login User
We have a Form with a Subform attached that is used to add comments. In the subform - there are 3 fields (date, email, comment) of which the first 2 are auto-populated (login user id and current date). We need to be able to disable fields where the email isn't the loginuserid - so that people can't edit other's comments. From what i've read on the forums - the only information is 8 years old and suggests that the disable option on Subforms isn't possible. Given it's 2020 - is there a solution to
[SESSION ENDED] Ask the Expert 6: 5-hour live discussion on launching multi-device applications and Customer Portals in Zoho Creator
Hi everyone, I'm happy to announce that the Zoho Creator #AsktheExpert initiative is back this year with a new session focussing on "Launching multi-device applications and Customer Portals in Zoho Creator". Every application built on Creator is automatically available for access on our native mobile apps for Android and iOS - no re-coding required. Creator also provides developers with tools to customize, extend, rebrand and distribute applications as they see fit in a device specific, and stakeholder
Fetching old value from subform field
Hi, I have a subform: Dispatch Details in the main form: Order and Dispatch. I need to fetch the value of a subform field: Quantity before updating it with another value. When I try to use the old.Subform.field name on the edit of the form submission it gives me the error: "Variable 'old' is not defined" . How can i fetch that value for a field and then once it is updated I need to do some further logic
Easiest Zoho Creator Sync Scripts and Methods
Hi, I would like to build a POS App using Zoho Creator. I would also like that all Customer, Product and Inventory Details be synched everytime the POS App is loaded or when a user presses a Synch / Refresh Button. From Zoho One it appears that the main target synch module is Zoho CRM as it already can sync with Zoho Books and Zoho Inventory seamlessly. q1. Why doesn't zoho have a simple sync wizard to synch Zoho CRM data to Zoho creator? q2. What is the simplest Diluge script i can use to sync
Unique ID
Hi, Is it possible to have Creator automatically generate a unique ID for each entry? I cannot find a way to auto-increment and in the expense tracker I am building I cannot think of any other way to guarantee that each entry is unique - for later finding. An alternative would be to use a Unix style datestamp, but I have had no luck scripting that either :) Any suggestions welcome Owen
Getting Data from Form for my login Page
Good Day, I created a form that contains all the email address, phone number and status of the supposed user of my application, I'm wondering if it is possible to use the data from that form for my login page? Also can I configure my login page wherein it will only ask the email address (from the form I created) so the user can login? I also would like to disable to registration and forgot your password page for my portal. Thanks
Zoho Creator API V2 JSON Payload
Hi, I am trying to create/update records to Z-Creator when an Item is updated/added in Z-Inventory. I am getting a response code of 3020 - API request's body is either missing or incomplete. I followed everything based on the API v2 Documentation of Creator when creating a record. I am wondering what am I missing. Here is the sample payload: { "data":{ "Inventory_Item_ID":"131711000000089005", "Name":"2111-F2 SAMPLE" }, "result":{ "fields":[ "Name",
Line Break in formula field
I am trying to put items on a new line in a formula field. I have found many solutions but none work for a formula field So far have tried Item1 + ''<br/>'' + Item2 + ''<br/>'' + Item3 Item1 + ''<br />'' + Item2 + ''<br />'' + Item3 Item1 + ''<br>'' + Item2 + ''<br>'' + Item3 Item1 + ''\n'' + Item2 + ''\n'' + Item3 <br>" "br/>" "<br />" all show up exactly as entered. Without Quotes, I cannot save the Expression.. Using "\n" doesn't show "\n", but also does not add a line break. Is it possible
Problem with multiple 'for each' statements in workflow
New to ZC and almost a novice at coding. I'm mostly getting along fine learning Deluge through the documentation and googling, but I'm completely stuck on this one. At line 22 I get the error 'Variable Actual_Work_Time does not exist in Activity_log'. I've tried every way I can think of to specify that 'Actual_Work_Time' is in the form Projects (not the subform Activity_log) but it won't accept any. Forms/fields (only for as far as the problematic line): Projects (fields Total_Project_Time_Actual)
Zoho support not responding
I've sent several email in the past month through the help functions in both creator and CRM yet have not received no replies, I have resolved each issue except for the most recent one myself. Could someone at Zoho look into why this may be happening? Thanks.
Deluge script - button click - can't hide or show field
Just wondering why custom buttons can not hide or show fields? Error on show or hide is "show" can only be used on load actions. But a decision field can show or hide a field, so why not a custom button?
Stuck on "Please wait, while we work our Magic!"
Hi I've just created an account but cant use the templates, it just says gets stuck on "please wait, while we work our magic" Can you help please Thanks G
Creating Database first in Zoho
Hi, I'm just wondering if it's possible to create a database first in zoho before creating any form? Or is zoho's database depends on the form you created or files you imported? Thanks in advance for the answers
App Problem
I have four shared apps in my portal, 3 are working but the fourth seems to be disconnected. I can open it but am unable to do any search or functions period.
Encrypt name, address, phone number
I see we can encrypt single line and number fields but I don't see how to encrypt name, address and phone number fields. This seems pretty important for an added layer of security. Any thoughts about how we can do this?
How to craete PDF and upload to workdrive?
Hi, We need to create pdf and upload to workdrive. 1. we have success create pdf by caretor url. 2. we have sucess upload file to workdrive. But the url that craete pdf didn't upload to workdrive it need actual file url. Any trick to make it.
Kanban Report by User Fields
It would be nice to be able to create a Kanban report by the system user fields. Those are finite, just like a lookup, dropdown, or radio button. My use case is that users (employees) scan codes for tasks completed, and that form uses the system 'added user' field to designate who did the work. I would like to be able to see this is a Kanban setup by user, which is not currently possible. I realize that I could add an additional dropdown field and have it set by a workflow based on the added user,
Version 5.24.1 iOS bugs
Creator version 5.24.1 is causing havoc. Please update us on progress. Users report date format issues on existing records and Address field no longer has tap to adjust location. Now there are no apps shown in workspace view. All issues reported are on iOS.
Is it possible to merge two Zoho Creator apps into one app
Is it possible to merge two Zoho Creator apps into one app It would be very useful if I could
form.submit
Hi, I'm using the Zoho Creator for an inventory management application and have found most things really awesome. I require to do an auto submit of the forms once all the fields are filled up correctly, something like a form.submit in Javascript. Is there a way to do this ? Is there a "force submit" counterpart of "cancel submit" ? Is there a way we can embed our own Javascript to do this ? Thanks, Zainul.
PDF from Page properties
Hello, I am generating few tables using page from different forms and reports using HTML snippet. But when i try to export the page as pdf i receive the the following view which the file i have attached. Here's the code: <%{ fet_UpperWear = Upper_Wear_Garment_Stock_Report[Stock_Location.contains(param_location)]; fet_BottomWear = Bottom_Wear_Garment_Stock_Report[Stock_Location.contains(param_location)]; fet_KidsWear = Kids_Garment_Stock_Report[Stock_Location.contains(param_location)]; fet_Accessories
Fteching Data from Lookup Field in Another Form
I have the following Forms: Form Name: Components Field: Comp_Description Field: Comp_Category (this is a LookUp field linked to another form named Category) Form Name: Category Field: Cat_Category Form Name: Pricing Within this form I am fetching data from the Components form using the following script: if(Components[ID == input.Pricing_Part_Number].count() > 0) { x = Components[ID == input.Pricing_Part_Number]; input.Pricing_Description = x.Comp_Description; input.Pricing_Category =
Filter a look up
We are looking at getting zoho creator. The first part of what we need to do is create a fliter on a lookup....I am told this is achiveable - but how?
Zoho Creator | Scheduled downtime for EU users on September 27th, 2020
Hello App Creators, We want to make you aware that we've scheduled a maintenance activity at our EU data centers on Sunday, September 27th, 2020, from 3:00 AM to 3:15 AM (UPDATED) from 1:30 AM to 1:45 AM CEST (Central European Summer Time). During this period, Zoho Creator will be completely unavailable for the accounts in our EU data centers . This means that the following will be temporarily inaccessible for these accounts: The Creator applications and their schedules, integrations, and APIs The
Problem with Mass creation of invoices
I have a script to generate an 'x' amount of invoices. Recently I'm facing the problem where in example, if I tell the script to create 120 invoices; the script stops working when it creates 70 invoices, and the rest don't get created. The script used to work fine and could create even up to 160 invoices. Below is the following error, and an example of the script that creates the invoices. Error details: Error in executing On Edit - On Success script. Value is empty and 'get' function cannot be applied
Conditional switching of mandatory field status
Hi I have a form that requires a number of fields to be hidden depending on the selection of a yes/No radio button field, ie if the radio button selection is "no", then about 6 other fields are not necessary and must be hidden. Obviously, if the fields which must be conditionally hidden are defined as mandatory, then on submit, errors are thrown for each of those hidden fields. Conversely, if the radio button selection is "yes", then all fields must be shown and they must be required fields. Is
Intigration with facebook
Hi, This is Surya, I am trying to integrate with Facebook and i want to post an image to Facebook from the creator using deluge [The image was already uploaded to creator using image field from local storage]. It is working when I use an image URL from external sites. But I can't post the images that are already uploaded to zoho creator.Please give me a solution for this. Regards, Surya.
Linking Customers to Customer Portal
Hello! I have a Form with 50+ Teachers. Each Teacher has multiple Students. Two Questions: 1) What is the best process for me to create portal access for all the Teachers? 2) If they log in to their customer portal and fill out a new form, how do I only show their students? Thanks!
Detecting a user closing a form without submitting it.
I probably know the answer to this but I though I'd just ask in case someone has found a way to do this. is there a some kind of on close or on quit event where deluge script can be run when a user cancels or closes a form or quits the window that a form is open without submitting or updating a form.? It would be useful for us to do some data clear up if this happened to one of our forms. Thanks
Upcoming updates - May-June, 2020
Hello App Creators, We'll be releasing the following features in the next 2-3 weeks: API v2 Mobile SDK Federated login support for customer portal Lookup creation UI revamp Enhanced offline capabilities Support for duplicating permission sets Satellite and street views in map reports The following features from our previous posts: Freezing subform headers Beta property that brings improvements for printing and exporting records as PDFs Upcoming online training: - - - - - - - - - - - - API v2 Availability
updateRelatedRecord does not overwrite CRM list
I am using the following command to replace the contents of a related list in the CRM with those of my own list. updateCRM = zoho.crm.updateRelatedRecord("Products",productID.toLong(),"Accounts",input.Account_ID.toLong(),Map:String({"Products":subList})); It adds the records of my list that are not in the CRM list just fine, but it does not remove the records not present in my list. In other words, It's adding the new records I want but not removing the old ones. Does anyone know if there is a way
Assigning value from field A to field B
Hi, I want to setup a function to assign the value of a formula field (DateTime output) in my layout form Licence Expiry Date to a DateTime field Custom Licence Expiry (we have an integrated system that reads values from the Custom Licence Expiry field). I wrote the following deluge function but it doesn't work, can anybody please help? CustomLicenceExpiry = getFieldValue("LicenceExpiryDate"); Thanks Wing
how to create a button in View and a timer
Hi! I am new to Zoho and I need a bit of help with something. I want to add a button in a View so that users can click and go to the next Form. How can I do that? Also, is there any way of inserting or creating a timer for my application? Thank you!
Deluge function/code for converting decimal to Base36?
Hi, I'm familiar with Excel converting Numbers upto base36 with the BASE function. BASE( number, radix, [min_length] ) Can we do this in deluge in Creator? What's the workaround if not. Use Case: I have an Auto-number field, based on the auto-number field which is in decimals, I want a formula field/function to generate a BASE36 number on another field. Appreciate the help, Thank you, Jayanta
Filter by date on panel in dashboard to show calendar months
In my dashboard page, I am creating a panel showing count of selected records based on date. I want to show each calendar month of the year. i'm not sure how to do this using the date filter options. i can do for each month in 2020, using calendar options 'before' and 'after' but I want the dashboard to roll over into next year and the next etc. So essentially, I need, "if month is January, if month is February" etc. Any ideas?
Payment Cancelled - Still Creates Record
I've written an event booking part of my new system. In this they book in and pay for the competition. I just had a guy press book now, but then close the payment window as he didn't realise he didn't have his card on him. This has still created a Competition Registration record, it's just not marked as paid. This isn't the expected behaviour though. The average user would assume that this cancelled the registration process. Wondering what the best way to handle this is?
Looking for a Scripted Telesales/Telemarketing Campaign Solution
Hello, I'm looking for a way to do scripted telesales/telemarketing campaigns in Zoho Creator or Zoho CRM. I have seen solutions like GrapeCity Telesales for Salesforce and CallPro CRM and they do exactly what I want to do, but they don't do it with Zoho which is the platform I would prefer to use due to the pricing structure and the month-to-month payment model. Particularly GrapeCity; they do a great job of this, include prospect scoring and their interface is easy to use. But they are only on
Next Page