System is Responding Slowly
Hi, Do you know why the system is responding so slowly today? Please let me know. Thanks! -V
Photo upload not working
Hello. Anyone else having issues uploading photos into zoho? I've been using same app for months and today I can't seem to get photos uploaded....didn't make any changes to app or form... Checked my usage/quota and no issues there. Thanks
Issue in Script Builder Updating a Long-List
I made a function to clear a long-list field type from my database, but it was reporting this error: The only way I could get it to work was build the code in free-flow script mode: void DELETE_MEMBERSHIP() { for each row in parent_database { row.Schools = List:Int(); } } Clearly a bug! Cheers, John Whitney
Can I import data to CRM field?
I have a form in my application into which I am wanting to import data from a CSV. The form contains a CRM field. I have tried importing using the Lead_ID from CRM as the value for this field, however this does not work. I have tried importing using the Lead_Name from CRM as the value for this field, however this does not work either. Can anybody tell me what value can I use on import to link to the correct record in CRM? Cheers, Bianca.
Date not changing, multiple submits required, eternal please wait
We are having an issue that is now ongoing for about a week. The date box requires you to select a date at least 2 or 3 times before it actually changes. When you hit submit, it will not register the first time. We have waited to see if there is simply a lag, but nothing happens. When hitting submit again a "Please Wait" message begins circling and never stops. We have left it alone for a while and it still just keeps circling. If you go to reports the data was not entered.
Dynamic view criteria with access to other forms
Hello everybody. I'm trying to implement a sort of function that allows every single user to choose on which data sets he can work on. I found no problem with the FORMs by creating a table on which I save a sort of cookie for the user. The problem is with the VIEWs: I cant' make the view access that table and select the proper criteria selector (ie: the company). Is there a way to make the dynamic view criteria work? Thanks, Matteo
Import new data plus associated sub-form data
For importing data there is a checkbox - "Do you want to import subform data". It appears that this option does not allow for sub-form records to be imported against a single parent record, instead the import routine imports the sub-form record data against new parents. Can someone confirm this?? If so it is not worth having this subform import checkbox unless there is only one sub-record associated with each parent which really defeats the purpose of having subforms..?
On Load, On Success: Add Record
How do I add multiple records to FormB in one fell swoop? Form A has fields for StartDate and EndDate, and Duration (a calculated field) Let's say July 1, July 6, and 6 I want to insert 6 rows into FormB (one for July 1, July 2, July 3, July 4, July 5 and July 6) thanks
sms automation
I have a mobile number field (number field) in the delivery form I constructed. I went into settings, then automation and created a rule such that if the field in my form status of delivery is equal to "second delivery unsuccessful" an sms is sent(task). The task is below. sms input.Mobile_Number We tried to deliver your items twice and unfortunately you were not at home so please could you collect the items or phone us if you want to reschedule a delivery I added clickatell as a connection and used
Published App can Add, but can't Edit records. Why?
Hello, I published the below app forms to the public so that a customer can see the forms I created for him. He can add records with the Add Invoice link below, but he can't edit records in the Edit records link below. How can i change the form so that he can edit records? Add Invoice https://creator.zohopublic.com/iramalvarez1/published-qcr/form-perma/Invoicing/A6UKh9uAMga1eg9YCguh3xVN0pgySddyXpkF34UaUzPSsE2dOADC525pKBwBUAODBBCpfrFK0Ka4vNFn6j0DyjnJqabSOMwtxnf1 Edit Records https://creator.zohopublic.com/iramalvarez1/published-qcr/view-perma/All_Invoices/dHH2skxRqbbN6eMjyZDyp7RhbO82h8d9pG22jVeEqA1NxK7aObumW3DSQVP9GyByTqy6Q5q1muEKECMnRvv52UKTHsfFOABMseS7
Customer Portal
If I build a customer portal app in my account, can it be later moved to another account? PS: How many customers can sign-up per the old and new enterprise plans? Cheers, John Whitney
Can I access a Pivot Table via a Custom Action?
I know how to write a function, so I can access a form or view via a custom action. What is the syntax for opening a pivot table?
Formula field Date Calculation shows time too
In a formula field, I am trying to subtract days from a date field. The formula field displays the correct date, but also includes the time. Is there a simple way to strip the Time and display only the date? I know it can be done in a tedious way, by creating more formula fields, convert to string, then getPrefix, then convert back into a date, etc, but i was hoping there was a way to accomplish this all within the one Formula field. (Registration_Expiry.subDay(150)) the Original date field contains
Getting an unknown error when trying to add a user to the portal.
I am trying to add a user to the portal. I get this error message "An error has occurred. Please contact support@zohocreator.com for assistance." I have sent an email to support, but I am curious if anybody else has seen this message and knows what it means. I have attached a screen shot. I am stuck until support gets back to me, so if anybody knows what it means let me know.
Lookup an email address in another form based on dropdown selection.
I have 2 forms. Form 1 is a Sales_Rep form with 3 fields: Name, Email, and a checkbox for current employee or not. Form 2 is a Job form with many fields. One of these fields is a dropdown lookup of Sales_Rep.Name. In the "Form Actions, On Success" deluge script of Form 2, id like to send an email to the Sales_Rep.Email of the selected Name. Im unsure of how to declare this variable.
how do i open a specific stateless form in edit
I have a form 'A' which when submitted saves the data in that forms 'A' report. Now i have a stateless form 'B' with some selected fields from form 'A' and when submitted saves the data in Form 'A' report. But when i click on edit in the report to the data of form 'B'. i am not able to open that stateless form 'B' in edit mode.instead it opens Form 'A'. So, i just want to open that stateless Form 'B' in Edit mode of Report A.
Coding help
I'm trying to learn the basics of writing this code. Can you recommend a book or website for a beginner? What's the name of the code? Where can I do some research? Thanks, Steve
Language of public forms
Hi! Is any way to control user language in Public form ? User of public form always the same, so is any way to set/change user language?
Creating a user submitted query
I have been looking for some time for a relational database solution for a simple membership app and I'm hoping this might work. I used to be a database admin years ago but was not a programmer. I did a lot of SQL and some simple scripting but don't have a lot of coding experience. I would like to create a relational database with I think 3 simple tables, a member table, a registration table, and a merits table. The master table would be the member table and contain all pertinent data about
Import form with lookup fields
Hi, I have 1 form which has customer data, and another which has employee data. Now I have created a third form which stores installation data, which (in addition to other fields) has 2 lookup fields: 1. One for the customer form (as company name - city - state) and 2. Second for the employee form (as First Name - Last name - Location) Now I am trying to import some data into the installation form, but what is happening, its creating new entries in the customer form and the employee form. I want
Dynamic picklist
Hi guys, I want to add a criteria that remove Staff that have more than 10 Service record from Staff lookup picklist field in FormA. At the moment I have script that filter Staff for Services offered. Is possible to add also this criteria? I try with IF and FOR EACH without success. Thanks for any help. Mike stafflist = (FormB[(Service == input.Service && Status == "Active")].ID).getall(); Staff:ui.add(stafflist);
Can I extract the link name from Url datatype?
So, is this possible? I have Url datafield; the url goes to a map. The Linkname has the mileage. But I would love to access the mileage for calculations; is there a way to extract that tidbit of info to another field?
Option to import for sharedusers
Option to import is not available for shared users. I saw a a topic tow years ago and it was advised to use zc_ShowAction=import at the end of url which only works for developers. Is this feature still not available? Thanks Reza
Free edition of Creator - can the public access fill in the creator forms embedded on my website
Hello, I am using Zoho CRM and recently created some registration forms using Zoho Creator. I have embedded these forms in my website. I have noticed, however that when I am not logged into Zoho - these forms are not accessible - asking for a username and password. I need people to subscribe via my website. They do not have usernames and passwords. How do I enable NON- Zoho users to fill in my Zoho Creator forms? thanks and regards, Michelle
Where do we report Creator "Reports" issues?
I am currently beta testing the "Reports" interface in Creator. It has a lot of potential and also a few bugs. Is there a system for bug reporting already set up for those testing this functionality. I have a number of small issues already and can't move forward until they get fixed.
Open Report filtering by multiselect field.
I want to open a report using the following link "<a href='https://creator.zoho.com/" + zoho.appuri + "/#View:Task_Report?Staff=" + input.Staff + "'target='_blank'> View Tasks</a> "; The report opens but shows no data available. I think the problem is that Task_Report.Staff is a multiselect field. The following code is almost identical but uses State which is a single select field. It works as expected. "<a href='https://creator.zoho.com/" + zoho.appuri + "/#View:Task_Report?State=" + input.State
Upgrade Entries on CSV import
Hi, I need to upgrade entries on my list once I import a CSV file. Normally I have to choose one key field. But I cannot do this in Zoho Creator. Right now the entries duplicate instead of update. If this is not possible. Then are there any other options? Can I maybe create a script that says something like: if new entry field xxx already exist => delete old row. ?? I don't know how to do it. Help, please.
Set values to null if fields are hidden and not relevant
Hi all, Let's take a radio button R1 with options Yes and No. If you click on Yes, another radio button R2 appears with options A and B. Then you click A. But then you realize that you made a mistake and you wanted to click No on R1. You click on No, R2 disappears because it is relevant only if R1 is Yes and you submit your form. The problem is that R2 still has the value A, which is wrong because A is only valid if R1 is Yes. How would you do to set it to null if this case happens ? I did resolve
Finish Date formula??
I have a date field that holds a Date and a number field that holds a number of days. How do I configure a second date field to show the original Date value plus the number of days thus calculating a Finish Date based on number of days duration? Thanks
Email link to file when file upload is used
Can you tell me how to get the file path to show up in the email notification based on the form on my site here: http://www.franklindocs.com/pages/quote Austen orders@franklindocs.com
Calculating Differences between Records - Limitations?
Hi, I'm trying to understand if ZOHO can handle this. Tanks have daily gauges - in Feet, Inches and Quarter Inches. I'm wanting to calculate the differences between records to report on daily production. I have created a formula field that takes (feet *12) + inches + quarter inches. I'm not seeing a way to use pivot charts (or any other report) to calculate and graph these changes. Am I am missing something simple? Thanks,
Dashboard Templates for Zoho Creator
Do you have to propose me or are there some ready dashboard templates for zoho creator applications? I know that there are some templates when I create a new page but my question is if there are somewhere more creative templates for zoho creator (paid or free).
Sendmail Limit approaching 500, do I get a warning email?
I have multiple forms which trigger sendmail actions and I am concerned that as my volume of subcribers increases, I will approach my limit of 500 emails per day. Will I get a warning email saying "You have reached your limit of 500 emails per day. Please log on to Zoho Creator to review your Usage Log Details and optionally add a $10 for +500 emails per day to your account."? I would rather not have to script this to count every sendmail action and then email zoho.adminuserid when limit is reached,
Hide values in chart
Hello, I am trying to hide the values in y-axis of my charts. I could hide the values that appear under the axis title setting the color to white, but there is still a balloon contatining the values that appear every time you pass the mouse pointer over the bars. Does someone know if i can hide these values? Thank you!
filtering lookup fields
Hi, I am having real trouble filtering a lookup field for patients according to the pharmacy branch/shop they go to. I used this code on load. However, there is some kind of error with the last line, because when I added it in, the form stopped loading when I wanted to access it and it said "error occurred on loading this application." User_Email=zoho.loginuserid; getShopAt = Users[Email == input.User_Email]; Shop=getShopAt.Branch_at; Patient_List = Patient_Details[Shop == input.Shop]; Patient_Details:ui.add(Patient_List.Patient.getall());
Add Record - Subform with with multiple entries
Can I have each row of my subform create a new record with add record? Currently if I have 3 rows only the top row gets added to the form using add record. I don't have 3 new records in that form.
Failed to submit form data
I am getting failed to submit form data error when I try to insert records in my form. I checked that the one entry per ip/user is clear. Even when I removed the validation, I get the same error. Please guide. My application is shared for support access
Currency in millions
What is the best way to show currency in millions like $2.6
Testing Environment
Does anyone have any suggestions regarding how to setup a Testing environment for Zoho Apps. I know you can copy an application, but the data is stripped out. How do others test and roll out changes?
UNABLE TO UPLOAD File from Mobile Application where Form is embded with iframe
Dear Sir, In Form, there was one filed with File Upload. The form is embed in website as well as in android mobile application with iframe. The form is open in mobile application, but at the time of upload file, we are not getting file file for upload. Please check it and do the needful at the earliest. Thanks Deepak
Next Page