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);
How to refer form fields in other application to current application. Both the applications are in the same account.
I need to refer a set of fields in a form in other application in my account. I have written code like this. But it is not accomplishing my requirement. row.Part_Number = FormA.Part[ID == PartID].Part_Number; FormA is the other application. Part is the name of the Form in other application. I need to refer all the fields in Part to my current application. Please suggest a solution for this.
Null Check in FX
Hi, Just created an overtime form for staff, but my Zoho is somewhat rusty after several years. Hours are calculated between a start date:time and end date:time: "Minutes" <((End_Time - Start_Time) / (1000 * 60)).round(2)> "Hours" <(((End_Time1 - Start_Time) / (1000 * 60)).round(2) / 60).round(2)> From these Minutes, I calculate how many hours were worked and if the person is eligible for 1.5xpayment or 2xpayment. "Overtime 1.5" <((Minutes - 450) / 60).round(2)> "Overtime 2" <((Minutes
Shared Users import via Migration Tool
I have shared an application with a user who I need to be able to import records using the Migration tool. The user is unable to select the Application from the list after selecting "Shared Apps". What applications should be included under "Shared Apps" for non Admin users?
Image note displaying when creating PDF from url
I created an HTML view with our Logo Image in the header. It appears when viewing the report, but not when directly creating a PDF from a zoho creator url. The source of the image is from a Zoho creator view <td width="60%"><img src="https://creator.zoho.com/ghsagjv/projects/Genre_LogoView/Image/image-download/1400541422986_GHSAGLogo.png" alt="" /></td> Screen shots are attached, that shows the same HTML page being opened in print view, and coverted directly to pdf. The pdf is created with a small
Deluge Field name moved
I love it! Thanks for moving the deluge field name closer to the display field name!
From Free-Flow Scripting, see: View names and Functions
When I'm in Free Flow scripting, I can use the Refer Fields link to reference forms and fields. That's great but I'd also like to reference: Functions with their parameters View/report names (which I need to reference using share/unshare)
Invalid entries found. Please correct and submit again.
Beginning today, I have begun to get the error message "Invalid entries found. Please correct and submit again." as I am making very minor changes to records in the database. Not all the time, but maybe 1 out of every 10-12 records this will happen. It was a valid record before, and all I am doing is copying one field and putting it into another field. It works most of the time. I have closed and re-opened with no change. When it happens I cannot save the record.
Permalink (Publish) form - unable to customize
First off it's been about four months since I setup a permalink to any form for public access so I realise the interface for this specific instruction set has changed in that time. OK so from my form I select Permalink and in the dialogue I select Publish, to make it public then hit Customize. I'm dropped back to the editor window and am shown a preview which updates as I change fonts, fields sizes, etc within the customization pane on the right side of the browser. The problem is the Publish URL
Functional-based URL strings with lists
In regard to functional-based URL strings at https://help.creator.zoho.com/Functionality-based-URLs.html I have a question about calling a view based on a list, generated from check-boxes on a form. Let's say the criteria is PET and the user can select any of Cat, Dog, Bird, Cow, Snake. How do we call a view based on PET={Cat, Snake} for example? Something like http://creator.zoho.com/admin/users/#View:User_View?PET={Cat, Snake} ?? John M. Whitney
Function Script Disappearing
I have a script to create a concatenated string (thanks Cyril). It works great in workflow under On Add/On Success and On Edit/On Success. What I would like to do is to put this script into a function and just call it in the workflow that way. I tried creating a new function and added the script. I saved it and called it in the workflow. No go when run. Blank. I go back to the script editor and the script is gone except for the bit on top for the string. Tried it a few more times, same result. Also
Questions | Zoho Creator
Hi Team, I have a few questions for you: 1. Similar to Zoho CRM Mail Add-on: How can we have a similar solution for Zoho Creator App so that all inbound and outbound emails can be tracked from inside the Zoho Creator App against the relevant Contacts (Note: "Contacts" will be a custom module inside Z Creator)? 2. We have created a Quote Template inside Zoho Creator. Now through a "Send Email" custom function we want to send that Quote as a PDF attachment to a contact. Is that something we can achieve
Fetch with two form criteria
Hi guys, a fetch question are drive me crazy. I need fetch data in FormA with some criteria from both form (A and B). I try with list or variable without success. Anyone have a idea how develop it? Thanks for any help. Mike Stafflist = (FormA[((Day = input.Day && Staff = input.Staff) && Availability(FormA) <= input.Availibility(FormB)].ID).getall(); Staff:ui.add(Stafflist);
Can't find my database at Zoho Creator after changing Administrator's email and password
Hello! The thing is, I can access the same workspace as I had before, with my new email address and password, but now there's nothing there, can't find my database, the workspace is empty. Any clues? Thanks a lot in advance (I'm so worried now...)!!!
iPhone App won't display reports in calendar view
I cannot get the Creator iPhone App to display a report that is calendar view. It closes the App when you try to open it. I have tried several reports. Works on Android App. Is this an issue?
lookup data showing up as a number
I know I have had this before, but I am having a major brain fart. data from a lookup field is showing up as a number when I try to use that field with the send mail function.
On insert access
Hi, I have created a custom action on the form A, that execute a custom function that insert a new record in a form B: void richiestaApi(string dominio, int registrarID, int operazioneID) { insert into B [ Added_User = zoho.loginuser Dominio = input.dominio Operazioni_disponibili = input.operazioneID Registrar = input.registrarID ] } I have also created a script On insert On access on form B, but it is not executed, even if the new record has been correctly created. If i
View an uploaded file without downloading?
So, once a user uploads a pdf, is it possible for a user to click and view the pdf in a new window, rather than downloading it and then opening?
is it possible to insert a data field into an alert?
I would like to reference a field in an alert box, how do i do that, is it possible?
Subform Fetch/Lookup
I am having a problem setting up a fetch lookup to a form that uses a subform. I have attached some screenshots to help me explain. Here is my main form. The BOM subform section is added as I create the MMR(master mfg record) Once my MMR is setup I will need to create a BPR(batch production record) for each production run that will include everything from the MMR. Here's what I have so far on the BPR form I have the lookup MMR set up & it works to bring in the Product_Name But I get an error when
Color Code Items in Calendar??
Hi Support, Is there a way to color-code items in the Calendar view? We have a client who would like to have this feature. Please advise. Thanks, egressmedia
Function definition
The zc help shows this example for a function. What should the code look like if I'm adding in a 2nd argument? openUrl(“#Form:Add_Meeting_Attendance?meetingid=” + input.id + “”, “popup window”, “height=400,width=550″);
Next Page