Color Background
hi , i didnt find an option to change the font size or the background color of the form . IS there any way i can change my background color of my form because my website background is blackground and when i add this , its full transparent . mraviprakash06User Licence vs Customer Portal User vs Mobile App User
This is a pre-sales question so sorry if I have posted to the wrong forum. If I create a rebranded mobile app for IOS or Android with Zoho Creator, I am confused as to the number of users who can download the app and use it from an app store. For example, if I have a 10 user Zoho Creator Ultimate subscription which comes with 1000 customer portal users, how many users can download and run my rebranded app from the Apple Store? Is it 10? A 1000? Or some other restriction? Thanks in advance.Stuck on deluge script for if one dropdown field in a subform is a certain value and a numeric field is above a certain amount.
Hello, I have been trying to figure out how to get the correct code to make a suggested retail price based on some user input in a sub form. I have the sub form with product rate and product category. The product rate is a lookup field and is called up by row.Product_Rate.rate The product category is a drop down field that has the values bulk, pre packed, individual, group, etc.. and is called up by row.Product_Category_Ref I have another field in the subform called Suggested Retail Price. Whatis there a way I can add an image in the notes field?
Hi, I am looking at adding an image in the notes field so when a user opens it, they are presented this with text ? I have tried to copy and paste images in, and they save, but when open are lost. Please can someone advise urgently? Thanks dpData recovery
Hi, Last night I made a tab for testing purposes (certain applications) in Applications. When I went to delete it The application deleted the Machines tab and seems to have corrupted the Applications tab. Can I get my data back? bradwilksGet total sum by date in Zoho Creator - Page ZML (Panel)
Hi all, I found that the Panel with Sum using this value in ZML value='thisapp.sale_form.sale_profit.sum' Could I only get this sum by date like April or Day like 25?Get min/max/avg values into a form/report from records in a different form?
I have two forms: Form A & Form B. Both forms have a field called Item Number. Form A also has a field called Price. I would like to see min/max/avg values from Form A/Price show up in my Form B. For example, if I have 3 records in Form A w/ the Item Number 1001 at Prices of $5, $10 & $20, I would like to see the min/max/avg of those prices in Form B records w/ Item Number 1001. How can I code that? Thanks!This week and Last week set criteria when week starts on Monday?
I live in a country when weeks starts on Monday. For Last week I applied this set criteria (Added_Time >= zoho.currentdate.subDay((zoho.currentdate.getDayOfWeek() + 6)) && Added_Time <= zoho.currentdate.subDay(zoho.currentdate.getDayOfWeek())) For This week I applied this set criteria (Added_Time >= zoho.currentdate.subDay((zoho.currentdate.getDayOfWeek() - 1)) && Added_Time <= zoho.currentdate.addDay((7 - zoho.currentdate.getDayOfWeek()))) This scripts work when weeks starts on Sunday. HowSubform Row with Previous Rows Data
Hi, I have been getting good results by searching the forums but I couldn't find a solution for this one. We will typically add rows and only change one or two of the subform fields from the previous row. is there a way to copy the last rows date to the new row as we add them? Regards,Use zoho creator page to fill PDF.
Hi team I have created a HTML page in zoho creator. I want to fill that page and on submit that page it will generate the pdf file which containing this information. How can I generate the pdf file with this information or please tell me alternative for this.How can the data in the multi-selection (Lookup) field be sorted uppon the original sequence I selected?
Hi, In a form I create a lookup field with multi-selection from another form. It works. But when I picked up my choices and saved and reopened it, the sequence of my choices is changed and by random. I contaced support, he says it's order by the ID(created sequence) of the form which is referred. But I checked and it's not true. Any idea about this? Random order is really a mess to user.Auto Fill Field In Custom Module Based on Lookup Field
I have built a Custom Module called Products Leased that is related to Accounts. It also contains a lookup field to Products Module. I am wanting to store all of the Products each account leases from us. When I lookup a Product I also want to bring over the Unit Price of the product into the new Module Products Leased. Is there a way to auto-fill a field based on the lookup value?Subform not updating when changing selection in lookup field
Hi I can select my lookup field selection:'quoted service' from one app, which is looking at all records in another app, that match this client and are accepted. The problem is if there is more than 1 accepted quoted service. I can see it in the lookup field selection:'quoted service', but no matter which selection i choose , it is only retrieving the data from one of the accepted quotes to populate my subform data. Any ideas?images in Notes Field
I am having Form A which contain 5 note field to display 5 different images. That displays Correctly. I am having another one note field that is 6th note field which should display the all the 5 images in a table format fetch from previous 5 notes field. How can be it is Possible?Archiving data into an off line copy of a creator application
We have a large database which keeps data relating to our customer's use of our services it consists of a main contact record (parent) and then a series of other records that relate to what services they use from us. We operate on a yearly cycle but for practical and customer services reasons we want to keep these records live and generally active for our call centre staff for 2 years. So far so good. However, as soon as a record exceeds 2 years from it's creation we want to move all the recordsCan I define a precise page size other than A4,A5 in record template ?
I need to print a label with precise page size ie. 60mmX40mm in record template. But the custom setting only show Width, padding and Margin. I can convert mm to pixel, but where is the length?Importing Dates
I am trying to upload my XLS spreadsheet. Dates are as follows: "2-Apr-19". When importing, I set the format as "DMY". When doing so, each one of these records fails. Zoho seems really buggy.Insert data into fields based on a condition in another form in Zoho Creator
Hi All I am having problems/issues with the following so hope someone can assist. Here is my scenario: I have 2 forms. Form 1 is called All _Airstrips. Form 2 is called Airstrip_Profile. Both forms have 7 fields which are common or with same structure. The common fields are called Airstrip_Name, Lat_Deg, Lat_Min, Lat_Sec, Long_Deg, Long_Min, Long_Sec. On the form All_Airstrips, there is a dropdown field with 2 options. The 2 options are 'Verified' and 'Unverified'. When a user edits or adds dataI deleted the default Zoho Signature by mistake
Hello, I deleted the default Zoho Signature by mistake and wanted to know how to restore it? Many thanks.number auto generate
There is a basic need for a function to auto generate numbers. Presently the help pages layout several confusing and non-working ideas. You will not get my subscription without a simple auto number function.Variable row not defined
For my orders form I am trying to auto populate price field (sourced from product form) in an order details subform based on the selected subform product choice. A very common requirement. I have tried using the code below (found on a zoho blog) but it isn't working for me. I keep getting the error message on the second line of code Variable 'row' is not defined //Fetches the information from the "Products" table selected_Product = Products [Code = row.Order_Items]; //Updates the value of UnitTransfer of Parameters from a non-zoho URL to a Page or form
Hello, I am trying to find out how to transfer URL parameters from a URL based on mydomain to a Zoho Form embeded on an HTML page Example: URL based on Mydomain.com with parameters (mostly just a clientID) This would point to a HTML page with an embedded ZOHO form (iframe1) and embedded ZOHO Page (iframe2) STEP1 The objective is to have the ClientID parameter, transferred to iframe1 and prepopulate the clientID field in the form in iframe 1 - So that the user can fill in other fields includingZoho & AX integration
My managers wants to know how well zoho integrates with Microsoft AX. We have a lot of data in AX but the UI is not friendly. Does anyone have success with integrating AX & Zoho? How does Zoho perform as a UI tool?Zoho Creator Walkthrough Crashes at the same step
Hi.. I am trying to follow the Zoho Creator walkthrough steps for the "Create a Pizza Ordering App" but it always crashes at the same step and I am forced to start all over again. I have not managed to get past that step. It always crashes at step 6 of 16 "Click Create a Workflow" step of the "Setup a Workflow" stage. This is the message that comes up: The walkthrough has closed unexpectedly Please navigate back to the home page and start the walkthrough again OkayAuto Filter does not reflect Set Criteria
Hi, I have a dropdown field "Shopping Centre". This field is linked to another form which contains names of all shopping centres, as well as the owner of the centre. The "Shopping Centre" field has a criterion set "Owner == 'Owner1'", since I only want the dropdown to show names of reviewers who belong to Owner 1. Now when I add this "Shopping Centre" field to the auto filter in a View, when I try to filter while accessing the View, I can see all Shopping Centres, not just those owned by Owner1.Duplicate a lookup field
Hi, I am trying to duplicate a lookup field. The original lookup field is a string. For duplicating into another field, I have tried the following. But none of it seems to work (I am getting the number instead of the string0. Let me know if there are any other options. 1. Use a simple formula, duplicate = original 2. Add a single line field 'duplicate' and use the deluge script on user input of 'original' A = Form_Name [ID = input.original]; input. duplicate = A.original;Function Bug: Solved
Is this a bug? I cannot get this function to work. int TEST(int counter) { if(counter == 0) { return counter; } else { counter=counter - 1; thisapp.TEST(counter); } } The error is missing return statementCreator API limit
Hi, recently we are hitting our API limit regularly and we have paid to increase this a few times now.... i have a script (see below) that is in every form (and also in each page in order to access a view) - we need this as we have many different clients who access the same system and we pre-populate the form with information from CRM and we use this information to also filter data depending on what system and site they belong to when they access a view (fyi - i use the customer portal to controlFunction field treated as text in Pivot Chart
Hope someone can help with this issue, as cannot find anything on this in the support field. I am creating a new Pivot Chart where are need to use a function field to do averages, however, for some reason the given function field is being read as a multiline text? The function reads as below where the two first referred fields are nubmer fields and the two last referred fields are time and date fields. ((input.SEM_SCH01_16_TD_ID16 + input.SEM_SCH01_19_TL_ID19) / (((input.SEM_SCH01_33_ATD_ID33 -Bidirectional Relation on subform not available
Hello, I've created a blank subform and added a lookup field to it. For some reason the Bidirectional Relation option on that lookup field within the subform cannot be turned on (the checkbox before Bidirectional Relation is there but nothing happens when I click on it). The subform is designed to add Contact names to an Account form, and I'd like the Account itself to be shown when looking at the Contact data. Any help would be greatly appreciated. AlFilter entries in view by date - how?
Hi i need make view in which there is entries that are today/yesterday old so that entires before yesterday are not showing in how can i make filter in view on current date?Creator emails dropped by domains with DMARC p=reject or p=quarantine
Is there a way to send DMARC aligned emails from zohocreator? The organizations I work with have strict DMARC policies and I don't believe the emails coming from Creator are aligned. There's not a way to "whitelist" as other articles have suggested. Is there a way to enable DKIM signing for my organizations? For reference, I'm seeing emails coming from 135.84.80.180 sendera180.zohocreator.com 135.84.80.182 sendera182.zohoRECRUIT.com 135.84.80.183 sendera183.zohoRECRUIT.com If there's not a wayZoho Creator On Premise
Hello. Some questions about Zoho Creator On Premise. 1.How i can download .zar file ? I don't see in options Options > Try On-Premise in my account. 2. Zoho Creator On-Premise comes with an "Evaluation licence" that lasts for 30 days from the date of installation. Do you have test mode for On-Premise version to test my application offline (test connection between On-Premise and another sql db's or ManageAngine Analytics Plus offline vers. etc) 3. I want to connect https://www.zoho.com/appcreator/Searching for records by date
Is it possible to set a search or filter for records with a date that is NOT in the last N months? I am trying to set it up so that our admin can easily see which records have NOT had an assessment done in the last 6 months. I see that there is an option in the drop-down that says "is not" - but I get the impression that is only for a specific date and not for a date range. Note: assessments are in a sub-form. I am viewing a report for records of the main form with a column for the assessmentCan a new "customer" be added via a workflow?
I am setting up a database for our volunteers, and I'm wondering if it's possible to create new users in the customer portal via a workflow? What I'm hoping for is that once people submit a volunteer application by filling out an online (published) form on our site, our admin staff can simply click a button in the report to accept this volunteer and have a workflow create a new user profile based on the email they submitted (which would send the new volunteer an invitation email to set up their password).The add record on the new form is not working
Good day, I´m having some issues when applying the add record to a new form to add record from two different forms to create a table summarized. I have a form that has information that comes from the CRM. I have the client, the address and the project number. Let´s say that that client has two different project numbers but for sales management they only use 1. So in creator I made a form to let me enter manually as many projects as I want. Now Im trying to have a single report with the informationHit the 5000 record update limit, need help restructuring code
I have a list of addresses that have been given an Area field (San Diego, DFW, Chicago, etc.). These areas include all the cities around the metro of those areas. We want to be able to update which cities belong in the areas, so I have a dynamic form that pulls the information and allows us to add or remove cities for the area. It works perfect for smaller areas, but I hit the 5000 record update limit on larger ones due to nested for loops. As much as I have tried, I cannot think of another way toFetch Records Troubleshooting
I'm at a loss right now. I have Table 1 that lists fields ID, Length, Amount. I am trying to Fetch records into Table 2 when the ID entered into table to is equal to the ID in Table 1 and insert Length and Amount. Here is my code but it doesn't return anything x =Table1[ID == input.ID2]; input.Length2= x.Length; input.Amount2 = x.Amount;Upload field in stateless form
Hi -- From this thread, I understand it's not possible to add an upload field in a stateless form. Is that still true? I don't really understand why, but is there a workaround to this?Upload File to Zoho Docs via Zoho Creator
Hi Is it possible to upload File of Zoho Creator form upload field into the Zoho Docs.Next Page
Access your files securely from anywhere
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
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 operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from aroundUsers Add-on at $1/user for Enterprise Edition
Up until now, subscribers of Enterprise Edition had to contact our sales team to add more users to their account at $3.5/user. We have now slashed the price and made it a much more simpler process. Using our newly introduced User Add-on , Enterprise Edition users can now purchase more users at $1/user directly. To add more users, go to your Subscription tab . If you are in Enterprise Edition, click on "Manage" under that edition and if you are in other editions, click on "Upgrade" correspondingFile download url
Dear Users, Creator support uploading of files through the file upload field in the form. Once a file is uploaded, you can download that file through the view. And each file download link in the view will look like the one below http://creator.zoho.com/DownloadFile.do?filepath=/1248931841640_dsc00007.txt&sharedBy=user1&appLinkName=SampleApp&viewLinkName=Sample_View The url contains file id (filepath), user name, application link name (appLinkName) and view link name (viewLinkName). We had certainEnabling public access disabled for Trial and Free Edition users
Dear Users, Due to security reasons, we have disabled enabling public access of form and application for the Trial and Free Edition users. Regards, Karuppuchamy
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. CharlesMerge 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 operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around
Top Contributors
Karunakaran G
【CSL】三井 翔
ishwariya.gurunathan
Valeria
pandapotan.s