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
How does the admin share the app with another user in order to enable the native mobile app on phones?
How does the admin share the app with another user for them to be able to use the Zoho Creator on Android? When the other user signs on, there is no apps available under Shared Apps.
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 Copy code Copy code stafflist = (FormB[(Service == input.Service && Status == "Active")].ID).getall(); Staff:ui.add(stafflist);
Email Orders
I presently have a view to show me Orders. I would like to know if there is an easy way to add an Email function to the left drop-down lists (Edit, Print,View). If not is there a custom email app all ready that I can you on selected orders? Sample to mail; WO Number 7134 Status After Service Call Complete Customer Name wtfcu Date Jun 16,2014 Terminal ID Model 5890E CPM/BNA Reported Problem Other Error Details they are having problems with the bottom part of ATM that is opened using a key - they cannot
Can't open page editor
I have an html page, and when I try to open the editor, the page hangs and never loads. The html pages still load, but I can't make changes to them. Anybody have any ideas? I have submitted to support already...
Problems - Learning how to Fetch Data between Applications
I've searched the forums up and down, and have not been able to find any RECENT solutions for what I need to happen. I bought into zoho creator because it is a database solution without having to need to know how to program and write code, however what seems like a fairly simple solution is requiring that I do just that. Here is my situation: I would like to fetch a record from a seperate application. To keep it simple here is the example Application1: "Form1" includes fields: Name1, Type1 (Name1
How do I add multiple keys fields to a single form?
Sorry for such a basic question, but how do I specify multiple key fields for a single form? E.g., an apartment is uniquely identified by the combination of (1) the building number, and (2) the unit number.
Linking Records / Fetching Data / Custom Buttons - How do i do this?!?!?
I am trialling Zoho as an easier option to learning how to code a database, but I am struggling with certain linking fields from different forms and to display that information automatically. My scenario is: We received enquiries from various customers that we have an Enquiries form for, we then work on these enquiries and quote them back to the customers and then when we receive a purchase order for an enquiry that we have quoted we will have an Order. The fields in the Enquiry form include: Our
auto-filling form field from url
hi, guys! how can i make creator's form so that 1) there will be a number of hidden fields and a number of seen fields? as seen - phone field, for example 2) hidden fields auto-filled from url string url example - Google Adwords URL http://www.okdekor.ru/?url={lpurl}&adwnetwork={network}&adwplacement={placement}&adwadposition={adposition}&adwcreative={creative}&adwmatchtype={matchtype}&adwkeyword={keyword}&adwdevice={device} hidden field with name "adwnetwork" - auto-filled with content of "{network}"
upload file
Hi I've been testing the form creator and database for a job I'm working on. It's absolutely perfect for what I want. However, for some reason I can't get the file upload to work. I created the form put the code in a web pages and entered some test data. The jpegs I uploaded via the form don't appear in the database nor to they appear in the email alert. Please help I would really like to use your application. Cheers Nomes nomes
Can a Form in Application A be referenced in a Zoho Page in Application B
I have a set of forms (tables) that are common and needed in a number of applications within a Zoho account. I would like to avoid duplicating the forms and its data in every application. These tables reside in Application A. Now when I am creating forms in Application B, I can reference these tables of Application A in Look ups without any issue. However, if I try to write Deluge code in HTML pages in Application B, it does now seem to work. Here is how I am referencing form of Application A in
Form Data > CRM Data
Is it possible to create a Zoho Creator Form/App that can be emailed to my Clients with their "current" CRM Contact data (such as phone, address, email, etc...) and asking them to input new data for fields that might have changed, (such as new phone number, new address, etc...) then have that new data auto-populate their respective CRM Contact page?
Formula Field went blank and did not update
We changed the Formula inside one of our Formula fields and after about 25 minutes, the field went blank. We have 18,000 records, but this Formula field remains blank. Please advise?
how do i enable native mobile app from my online account?
how do i enable native mobile app from my online account in order to set up the Mobile App on my Android?
How to set default values of multi-check field?
so, a form has a multi-check field, with n items. What code do I put in the on load, so that some of the items are checked by default when the form loads?
Variable Schedule Period
I'm currently struggling on one rather key element of the creator and that is to find a way of selecting on the form whether an automated schedule should be 6 or 12 months. I'm aware that there is an option to have a recurring action on an annual, but not a 6 monthly basis - an also I need for there to be an option on the form itself to determine this and feed into the automation to create a new entry. Could anyone spare a few minutes to help me out on this? Thanks in advance, Seb
For Each Builder is Broken
Cheers, John Whitney
Incorrect username or password in Migration tool
I keep on getting the error in the Access migration tool that says that I am typing in an incorrect username or password. As far as I can tell though, they are correct. I usually use my google account to sign in though, so there is a possibility the username I am using is incorrect. Is there a way to find the username that I am supposed to use in the tool? Any help would be greatly appreciated.
send email with attachment spreadsheet
Hello, can I send an email attaching a spreadsheet file containing records? It can not be a solution to send a link to view the records through the zoho. Bye David
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 Copy code stafflist = (FormB[(Service == input.Service && Status == "Active")].ID).getall(); Staff:ui.add(stafflist);
Next Page