User 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.
Fetch Records
Hello, i'm having an issue and struggling to resolve it. I have a form with a subform inside that has static data with an increment number. I also have another form with a date field and a number field that allows the user to input a number in a field which is embedded in a page. I am trying to pull values from the static subform and display some of the values on the page based on the date and increment number <= the value entered in the second form i am struggling to display the results on the same
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. What
Error when I want use a WebServices with metod PostURL [URGENT]
Hello Zoho community! I have a problem with Zoho Creator when I want use my Webservices.... I'm use a WebService with method PostURL in Zoho Creator but when call this WebServices in my Application show me this Error: The code that I have in my Load page is: I try with other URL but show me the same Error, I need Help please! I can't finish a project for this!
Push Update from Parent to Subform (Child)
Hi, I have a field in a parent form called date sampled and numeric field in the subform. The fields work perfectly and generate a future date based on the date + number value, however, if the value in the parent form is changed it does not filter down to the subform, unless, I click a field in the subform. Then it re-calculates the field(s). Any suggestions on how I can get it to push the changes down to the subform? Many thanks TOG
Recurring events showing as expired
Hi, when someone sends me a callendar invite from Outlook to a recurring event (e.g. weekly calls) that started in the past, but still has occurencies in the future (e.g calls started on Jan 02 and last until Dec 20 2019), Zoho nevertheless shows te invite as expired and I cannot put it in my calendar. Can you please look into it? Many thanks David
Google Address Autocomplete on a form
How could I use the Google Address Autocomplete API for a standard Form? I guess I can trigger a function by writing an On User Input script for a plain text field. But I'm not sure how to execute Java from a script. This would be a cool feature if I can make it work.
iframe adding blank lines to bottom
For illustration puposes I created a web page with these workds, one on each line every good boy does fine When I insert the iframe between "boy" and "does", about 8 extra blank lines are added on the bottom. https://themezz.com/zoho/ shows the issue. (I want to use the frame code on a wordpress self-hosted web site and I do not want the added blabk spaces at the end) Any ideas?
Count days between two dates - How to automatically refresh the day count?
I want to count the days between the current date and a date field. I have tried the following formula which works: days360(zoho.currentdate,input.Last_Swipe) However, the day count remains the same on future days until I manually change the date in the Last_Swipe date field. How do I automate the above formula so that I do not have to manually update the Last_Swipe date field to make the day count update? Thanks in advance for your help. Regards, David.
How do you get one form to populate another form?
I am very new to Zoho and deluge, but I have worked quite a bit with Access. I cannot seem to figure out how to do something that was very easy for me to do in Access. I am trying to create a Campus Leave log for students in a dormitory. I have a form that lists the names all the residents and another form for them to fill out when they leave. That part works well. I also have a View that shows all the students who are currently checked out. The problem is I want the student to be able to select
Clearing a Date Field
Hi I am trying to clear a date field if the value is anytime in future. I have written the below code, which gives me error. Please suggest any alternatives. if(Date_of_Birth >= zoho.currentdate) { alert "Date of Birth cannot be Future Date"; input.Date_of_Birth = ""; }
Conditional formula in a formula field
I had the following very simple formula in a formula field: 12 / input.Interval_months (where input.Interval_months is a decimal) This works absolutely fine. However, I want to make this a conditional formula, so I amended it to the following: if(Charging_Method == "NO FORMAL AGREEMENT", 0, 12 / input.Interval_months) Very strangely, this formula now only works if the result is a whole number. If 'Interval_months' is 6, the formula correctly shows the value '2'. However, if the 'Interval_months'
Entering defautl values on a subform.
Hi! I'm trying to add as default values for a new row at a subform the values of the preceding row. Is that possible? Thanks!
Set Created by or Owner
The application I have developed seems to always put created by and owner (in the crm record) as myself, no matter which of my account users are submitting the form. I have pasted my code below that submits to CRM, and have set the settings to have created by as the person submitted but it still defaults to myself. Any ideas? //create the CRM vs Creator fields map to push data to the CRM module. myFieldMap = Map(); //add values to the map. CRM fields first and then Creator fields ( without the
Safari issues - embedded form won't load
Hi there I have forms embedded within iFrames. When we have users updating forms within these iFrames, they can successfully load the form while using Chrome, but not while using Safari. It won't load and just spins and spins. The form won't load. Searching the forums, it seems this has been issue from time to time in the past. Thanks Aaron
Nueva versión zoho creator
Hi all, I have seen some videos from YouTube and I notice that my version does not correspond to the one used in the videos. It seems earlier. Do you know how I can access that version? Or should you wait even for the new version? Thank you jose marquez
Format the Report List View Header
Is there a way to format the background color and text color for the Headers in the Report - List View? The conditional formatting only works for the fields - we would like to format the header tabs - see below.
For Each Loop - Multiple Criteria Problems
Hi, I am struggling to complete a for each loop with multiple criteria. I'm pretty sure I'm getting confused or going about it the wrong way. I have a contact form with email communication options. You have the choice of the following: Receive reports = Yes or No. Site Options = All or Selected. (if Selected, a box below with multiple sites to select from and All is void.) Age Options = All or Selected. (if Selected, a box below with multiple ages to select from and all is void.) Below is my criteria:
Is it possible to add/embed a Creator form into Zoho Desk?
Hi, I´m working with a client who wants to access and fill a form from their Zoho Creator app using Zoho Desk. Is there a way to do this? Thanks
Add a record based on a subform answer
Hi all, Wonder if you can help. I'm trying to add a record into a form based on a subform answer in a separate form I've trying a workflow with the below if(Asset_Register.Asset_Name == "Access Equipment") { input.Asset_Register = insert into Testing_PPM [ Development_Name=input.Development_Name Maintenance_or_Plan_Requirement=39703000000167523 (ID Number) Testing_Category1="Quarterly" Added_User=zoho.loginuser ]; } But it doesn't add the record into the form. Any ideas? Thanks!
how can i create a QR CODE o BAR CODE
Como puedo crear un codig QR en una aplicacion.
Mobile Sdk API's
Hi Support team, We have been really finding it though in getting the right API's to have our native app built on Zoho creator. Mobile SDK is the alternative? please suggest
is 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 dp
Adding role via Deluge in Creator
Hi Support, I have been looking for many months to think of a solution to solve the current problem that we have. We have a production application with 1000 or more users and we can't give everybody developer access because if we do so, anybody can make changes to the forms or workflow etc, so we only want a few people to do system users administration. In order to do so, we created a custom form which allows them to add users. So in sequence this is what happens : 1. System admin add users and
Hide the Minutes for Formula Date Output Field
We are using a formula to input a future date filed and then show that in a Report List View - the issue that the date input is including the time - how do we remove/hide the time (see below). I assume we would need to add the remove/hide function to the formula or a deluge script.
Searching for partners to share costs of ZC Ultimate Plan
hey people! i'm an enthusiast of ZohoCreator, and I'm looking for partners to share costs of ZC Ultimate Plan how it could work? >> ZC Ultimate Plan is the highest ´plan of ZC, with access to REBRANDED Mobile Apps - YES, you create your app in ZC and publish in google/app store with YOUR logo >> this plan costs 35 US$/user/month, but we only can buy this plan to a minimum of 10 users (users != clients, ok?) >> if we become partners, you pay only as much users you need, and have SEPARATED access to
Formula / Deluge Script Help
We are coming from another database program and need help with Creator Scripting. On our form we have several YES/NO questions. If all questions are answered YES then the applicant is considered APPROVED. Therefore we would have a field populated as APPROVED or NOT APPROVED based on how the YES/NO questions are answered. We would also create a % APPROVED NUMBER field so if the APPLICANT only has 4 of 8 questions answered YES then they would be 50% APPROVED. (1) I assume we need to use a FORMULA field
Custom Schedules
I cannot seem to add or edit any custom schedules anymore? You can start creating, but cannot actually enter or edit any code! Have tried various browsers and the problem still persists. Any help greatly appreciated.
Calendar Navigation
We have an issue using the Calendar Report. If someone navigates to a different week/month/day from the what the current date is, and then edits an item on the calendar, after Submitting the updated record, the calendar returns to the "Current" view - NOT the view the user was at prior to the edit. Is there anyway to ensure that the user will be returned to the view they were at, and not have the view reset? Is there a way to know what view the user was in, and then use the openUrl task to go back
Error adding a developer
I'm trying to add a developer to my app and I get the following message: "Failed to add user. Adding user, with secondary email address is not allowed. Contact the user for their primary email address." Does this mean he has already registered to Zoho Creator with a different email and set the one that I'm using as secondary? Also, do developers count toward the number of users in my subscription?
Are there additional formulas for Zoho Forms? If not, how would you create a formula to find a date that is X amount of weeks from a set date?
I'm building a form where I need to get an output date of 52 weeks from the input date. I'm finding that Zoho Forms is limited in the date formulas allowed (unless I'm missing something). Seems like I may be able to use Zoho Creator for this (also not sure on the integration between Creator and Forms or if there is any). My questions are if there is a formula that I could use for this in Zoho Forms and if not, what would the formula be for Zoho Creator?
Filtering Lookup Field in Subform based on Lookup Field in Main Form not working
Hello Everybody, I am new to Creator. I have searched and searched and tried everything I find but nothing is working. I am trying to alter the Quote Management Program available from the App Deck to filter a lookup field in the subform of create quote. I have The Main Form: Create_Quotation I have created another form called Vendors On the Main form is a Sub Form: Products _On_Quote The Sub Form is referencing the form: Product_Service_Subform ON the form Product_Service_Subform I have added a
Implement payment methods in Zoho Creator (other than PayPal)
Hello, I would like to know if it's possible to implement other payment methods besides PayPal in a Zoho Creator application as long as it offers an API? My customers sell wireless service and do activations though us as a wholesaler, I need them to be able to add money into their accounts, and then when they make a sale and activate service for a customer their cost would be deducted from said balance. I believe this is possible with PayPal because there is native integration but I want to know
Data 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? bradwilks
Get latest data from account from report load (not form)
Hi, I have a report which has test reports waiting to be sent to clients, however, I have a problem. I have a condition on a custom send button which checks their account status. It's either Operational or On Hold. If it's operational the send button works, as expected. The pulling of this data requires the form to be opened to trigger the "On Load" event which checks the account status. How can I go about this without going into each record, like from the report list? Is there a way to get the latest
Clear the search criteria of a report through code or URL?
I have a stateless form that uses a workflow to display a link to a report with criteria using URL. example: app.zohocreator.com/owner/app/#Report:Name_List?Customer_Name=[Kim] However, doing this only adds the criteria Customer_Name=[Kim], it does not clear any criteria that was made before the user clicks this link. For example, if someone had searched for a range of dates on the report Name_List and did not clear the search criteria, then going to the example link shows the Name_List report
Displaying two linked values from forms in a new form
Hi, Just signed up for Zoho creator as it seems like the perfect fit for me. However the learning curve is quite steep. I'm trying to make a reporting system for our business. I have a form with staff details. One of the fields is 'Level' which is a lookup to a level form (i.e level 1 to 5) Then I have a third form which is a team setup form. I have a lookup field here for their name (and the possibility to add if missing). I get the name field to work, but also need the assigned 'Level' to show
Form Object in custom variable comes up as Form Name + ID, does not fill my multi select lookup
I have build a stateless form to be used to change fields on selected records from a report view. I have created a custom function with form object (ID) as the argument. I have built an action in the report quick view for multiple records, selected collection of records, created an workflow with action to run the custom function. When I run the action on a number of checked records in the report view, it pops up the window for the stateless form correct, but the lookup fields with multiselect shows
Get 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?
Help with Deluge Script for Checkbox
Hello, I am where I want to display certain sections depending on someone's entry in a checkbox. I have entered this script: if (input.Checkbox.contains("Gas")) {show Gas_1 } and I get an Improper Statement error. Can you please assist? Thanks!
Next Page