Choosing Between Zoho Creator Student Account and Regular Business Account for Website Development
Hello, Could you please help me understand the difference between a student account at Zoho Creator and a regular account with a business email? I am currently a student that working on my graduate project, developing a website for a medical company.
Help with Creating a Task and assigning a Lead.
Thank you in advance for the help. I am fairly new to Creator and have hit a road block. I have been able to create a form, and submit appropriate Account & Contact info using: taskinfo = { "Owner":Task_Owner, "Subject":input.lnSubject, "Description":input.mtlnTaskDescription,
Zoho Creator 5 API documentation
I'm looking for documentation on building API connections w/ third party sites/apps in Creator 5 - I only see documentation for Creator 6 in the Knowledgebase. I'm probably getting in over my head really - I have no experience w/ API or development other
How To Remove Logo When Printing Individual Records
To ZC team; Is it possible to remove logo from page when printing individual records? Is there an option for it? Thanks, Damien.
Print shipping label on Zebra Label printer from ZOHO Creator deluge
Hi All, Allow me to guide you through the process of printing a shipping label from ZOHO Creator to a Zebra label printer (ZD421D). Step 1: To start, configure the SendFileToPrinter API, which enables the transmission of a file to a Zebra Link-OS printer.
How to make a field conditionally mandatory
I have two fields (Address and City) which are not considered mandatory unless another filed, Amount, is greater than 100. So if Amount is greater than 100, how can I assure that Address and City have values in them? jmc1846-zoho
Passing a value to an "+ add new entries" form
I want to pass a value to an "add new entries" form. Take for instance the forms in the Zoho help example app "Dynamically adding items to a picklist" Back when that example was created it wasn't possible but now we can configure a look-up field to allow the addition of new entries. Let's say I didn't find the state I wanted for the selected country and wanted to add it. Since the "State" form in the example has a "Country" field, I wouldn't want to have to select the Country in the State form when
Value in a dropdown should give automatic update in date_tim
Hi I would like zoho automatic to update a date_time field to current time, when a value in a dropdown is set to a certain value. How can this be done! BR Skouboe
iframe code: diff between view-embed and report-embed
Using Zoho Creator to enter local nonprofits and sort them, then displaying them on Zoho Sites. A while back a developer helped our sister site get up and running. I noticed that they were not publishing reports and using the iframe code to display them
I would like to develop an installment plan
Hello, I'm inexperienced in the field, but I'm trying to develop an expense app and I would like to add the option to pay in installments, so that the expense goes automatically to the following months, if anyone could help me?
focus on form field
when you click the edit button on a record the first field of the form needs to have the focus so i can type or tab to the right field without clicking again... tonythomas
Grouping or Summarizing Records
First, I accidentally came across ZOHO the other day. I must say the Creator is VERY impressive. I'm a programmer by trade but have no time use/learn .net or whatever to develop "quickie" type apps that I would use mostly for me. Zoho Creator seems to fit the bill for what I want. Congratulations. I have developed a little small time tracker type application (for me only) that allows me to enter data, hours worked and a category ( and a few other things). It works great. The only question I have
Open another form as a Pop-Up
Hello, How do i open another form as a Pop-up Dialogue on click of Button which is a custom button in report? Can anyone help me with a code? Thanks
Focus Field
How do you do to open in a form enter the first field to fill? The perfector would be to be able to focus on the field that we would like. Thank you.
setting field focus explicitly
Hi, Is there a way to explicitly set the focus to a specific field upon loading a page, or when doing form validation ? Thanks, Zainul.
How to Give App Access to All Zoho Users
Hello, Sorry for the silly question, but I am preparing to launch a Creator App for the first time, and I do not have the means to test it with someone else. I want to give access to all our Zoho users for one of my Creator app. When I click Creator Settings
Making a Copy of a Stateless Form
There should be a simple way to make a copy of a stateless form. The use case is to try-out some new code without disrupting any users currently on the app, for example. As of now, you have to go into the "form definition with action" and select all the code and paste it into a new empty stateless form. Even this does not fully work because you get an error Error modifying the page [Form_Button_WFlow] Column 'BUTTON_ID' cannot be null that only goes away by removing all the submit button code! Cheers,
how to update subform record on successful submission
I have 2 form 1st is Purchase Order form which subform is Order_list that containd Material_Code, Order_Qty, Received Qty, Balance_To_Receive_Qty 2nd is Receive form which subform is Receive_List that contained Material_Code, Balance_To_Receive_Qty, Receive_Qty
Remove Special Characters
Hi folks, I know that Number field type, does not allow the data to get submitted if there are any special characters eg:- entering 1-1-1- in a Number field type & submitting the form, will show as error / invalid entries. I have seen removealpha(), remove aphanumeric() in string funtions. But i was not able to locate any function that allows to remove special character tried giving alert = input.number1.abs() , but alert just did not pop up. Wonder why? Infact, i would like to use removeallspecialcharacters()
Image resizing/scaling maintains aspect ratio
Currently in the column properties of Reports, the image widget allows the user to specify either "Actual size" or a fixed W x H in pixels. However, using the latter forces any sized image, regardless of aspect ratio, into that exact size, deforming the image. Can this be made "smarter" so that it maintains the aspect ratio of the image, up to the maximum as specified? I.e. if I have an image of 800 x 600 and I have specified my pixels as 400 x 200, then the resulting image will be 267 x 200. Hope
How to trigger workflow on-(Twilio API)submit?
Hello, I have a workflow that fails to trigger when an incoming twilio text message is posted in Creator using Twilio API. The workflow was created in Creator using a form trigger, "on-submit". Does the workflow need to be built inside the Twilio package
Publish form as a public calendar?
Hi All! We have a creator app that's basically built to manage various events we're working on with associated tasks. Whilst the 'Calendar View/Report' in Creator is handy it'd be much more useful if it can be published as a calendar that our team can
Can I get file data from the file upload field upon submission?
From inside my Creator app, my users need to send images (.jpg files), documents (.pdf files) and spreadsheet tables (.csv files) to one or more external APIs. Is there any way to grab the file data (I need to include it in my API calls) from the file upload field upon clicking the submit button?
error occured please contact application owner
Hi Zoho, I am facing an error on my application on Zoho creator. The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. However, the data has been trapped in the database. The user doesn't know this and tries to re-enter the data, causing multiple entries. Can you please help? I can give you access to the application if required. Naveen
problem with dollar sign replacement
Hi, I am trying to avoid users from entering the dollar sign in a string field So I want to check if the dollar sign is in the string and if so replace it with nothing if (input.invoer.indexOf("%") >= 0){ input.invoer = (input.invoer).replaceAll("%","");} This works other characters. If I do this for # or & it works. But only not for the dollar sign Please let me know how to solve this? Rob
Zoho Creator Performance - Slow
Since 10:00am AEST, the response time in Zoho Creator is around 35 seconds. Has anyone else experienced this in the same time period?
Can you create confirmation messages in Zoho Creator?
Hello, I would like to create a confirmation message that asks the user to confirm that information they have added in a field is correct when they attempt to submit the form, and gives them a "Continue" or "Cancel" option. Is this possible, and if not, is there a workaround? Thanks!
Customer Portal
I have been successfully using customer portal to allow individual to have access to certain forms and data in my system. They all have their own unique username (email). Is there a way for me to know or capture each time the user access the system using
ZOHO Creator just hangs when i try and install a template.
Hi As the title suggest, when I try and install a template it just hangs on the below screen.
Can I Build a POS using ZOHO creator and integrate it with ZOHO Books?
Hello, I have a Zoho Books account and I was wondering if I can have a POS system that integrates with it. Primarily with Inventory, Customers and Payment and ofcourse Create invoices and credit notes. So, would Zoho creator provide me with this solution? Thank you,
Convert Unix Time Stamp to Date
I am getting external data with a Unix time stamp (number of seconds since 1/1/70... the Unix epoch). I have used a formula field to give us the right date serial number. This formula is: (createdTime/86400 + 25569 + (-5/24)) The explanation for doing this in Excel is here (http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/) Now, since the formula is a number, how do I then convert it to dd/mm/yy format?
Not Working Get Recode API V2 and V2.1
Hello Zoho Team, curl --location 'https://creator.zoho.com/api/v2.1/zoho_admin8544/powerbi-connector/report/PowerBi_CRM_Form' \ --header 'Authorization: Zoho-oauthtoken 1000.036ed6dbd843860314596bf7eca4fc13.20b068cbfb671318a625466d4b8d8712' \ --header
No duplicate entries in Lookup Field
I have two Forms: FormA and FormB. I have a Lookup in FormB called "LastName" wich imports data from "LastName" in FormA (dropdown single select). "LastName" in FormA is not able to have duplicate entries. Is there anyway to avoid having "LastName" in FormB with duplicate entries? In other words, once one LastName has been selected in FormB, it won�t appear in that dropdown list for the next records. Thank you very much for your software.
Can I display a currency symbol in a formula field?
Hi I am new to Zoho and have quick question - I am using a formula field and woudl like the result to display in AUD currency - is this possible or is there a work around? Thanks
Filtering for a specific date range....
Hello, Trying to set a filter for agenda items by Start Date. This report goes out every Sunday and the Start Date is the following Sunday (1 week ahead). The duration is 1 week, Sunday thru Saturday. Using the operator "next n weeks" where n=2 gets me
Merge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation
Sending a canvas report via email
Hi, I have created a report layout using canvas and now I would like to send it via email as it can be done using a template. My working method so far is: sendmail [ from :gw@gmail.com to :mw@gmail.com subject :"Sample invoicel: " + input.CzeUzyNum message
Formula Field + .sum() Function
Dear support, It would be life changing if you allowed us to use the .sum() function in Formula Fields, especially to sum row values in Subforms. I'm aware of how to do it via deluge/workflows, however, this would save a tremendous amount of development
can we add print feature in the button by page?
Hello, I'm trying to generate barcodes in Zoho Creator using an external API, and it's generating successfully. However, when I attempt to print it, the predefined process in Zoho Creator seems complex. Is it possible to integrate printing features into
Save image to device gallery on Creator Mobile app
Hi there, Is there a possibility of implementing functionality where an image taken on the mobile versions of Creator apps will give the option to be saved on the device itself, similar to the Zoho Forms mobile app? We have a use-case where we want the
Next Page