How to fetch a record from a different application?
Hello, I would like to fetch records from a separate application. Here is an example: ApplicationA: "Form1" has fields: Name1, Email1, Department1 ApplicationB: "Form2" has fields: Name2 and Email2 --> Name2 is my lookup field. --> When I lookup a name, I want Email2 to automatically populate from Application A field Email1. How do I do this? Please give me an example. I have gone through the forums and do not understand the explanations. Thank you.
Select Field for Cursor
It would be nice for data entry to be able to set where the cursor is (what field) when the form box opens.
How to list Forms in Application in a private application as a shared user through API?
Hi guys , I have a zoho account shared a application , i read [Zoho Creator REST API- List Forms in Application] and follow it ,but get error response below <?xml version="1.0" encoding="UTF-8" ?> <response><errorlist><error><code>2892</code><message>Specified application name is not valid.Provide a correct one.</message></error></errorlist></response> I use shared application name is link name,no display name. need your help!
input masks to fields
Is it possible to define input masks to fields ? For example, I have a field in my app that receives data like this: 99/999.999-8. Can I have the characters "/", "." and "-" shown on the field at the moment data will be typed ? Thanks.
Back up restore failed
I attempted to restore my assets application(https://creator.zoho.com/essistmgmt/assets/#) as dev_assets_test but The restore failed and I currently see this error message com.adventnet.appcreator.parser.schedulecustom.ParseException: Encountered " "}" "} "" at line 3, column 13. Was expecting one of: "to" ... "every" ... Can you please investigate?
Autoview created not by myself
Hi, When I view the ASSETS form at https://creator.zoho.com/essistmgmt/form/1650/edit/ and hover the mouse over the related views, I see Autoview_1373401184830_ASSET which I did not create. When I click on the view, I see the following message There is no such view in Zoho Creator How did the autoview get created in the first place and why is the link broken? Can you please investigate?
Convert number to alphanumeric
Hi, I have written my own custom function to convert a number to an alphanumeric code but am having some difficulty since my brackets keep moving and when I call my function, it does not always produce the intended result but the first time I ran it, it was fine. Does anyone know the best way to convert an number to base 36? eg 1=> 1 11 =>A 2000 => 1JK
Error occurred while saving the view
I am trying to save my viewhttps://creator.zoho.com/essistmgmt/assets/#View:CONTRACTED_ASSET_View and am getting the following error I got the error when I tried to set the INITIAL SERVICE AGREEMENT to not empty and then clicked on Save Changes. Can you please investigate?
Simulate "Convert" option
Greetings, zoho experts, I had automated the "convert to account, contact" option in zoho crm, because i am copying the information in two additional custom modules. The thing is i want to simulate all the actions in the convert button. I am talking about the "convert" button in the Leads module. When you click it it convert it to account and contact but also the lead module is disabled. How can i disabled the Lead module after I had copied the information? It's Urgent please help me! Best Regards,
user to only access to their own entries?
hello, I'm creating a database of leads from reps in different territories. I would like the database to contain leads for all reps but only allow each rep to see the leads they've entered (own). Do I do this with filters of some sort based on the user? many thanks!
Data Re-populate on another Form
I am new to deluge script and conditional statements as a whole. I am getting there but seem to be hung up a bit. (I have been working on this for 4+ hours) I want to populate the "client" data from Form_A into Form_B. I have set the "look up field as Client First Name, Client Last Name, Client Middle Initial." (as it relates to Form_A) Once selected I want address, services, and other data from Form_A to be pulled into Form_B. So I am attempting to build this with the scripting portion of Creator.
Max file size upload
What is the máximum file upload size for a paid account?? I can't upload a 6 MB file, and I need to upload some others 20 MB files. I thought that the restriction was only for free plans!!! I have a standard account. Regards, Luis
Returning BIGINTLIST from a function
I have a field in table A that is a multi-select lookup to table Y I want to convert the values in that field to a multi-select lookup to table Z and put them into a field in table B. Because this need happens several times, I'm trying to write a function to do this. I've written the function to return the result of the conversion. The function returns a value of type list. But when I try to assign the value returned by the function to the field in table B, the compiler says I need to have a value
Schedule in the database
Hello, Is it possible to add scheduling or aka email notification in Zoho Creator. Example if I wanted to create a database with action dates. When a date in the database is today send out an email automatically without having to log into zoho creator. Basically I need reminder emails when certain records with certain dates come up. Thanks. Iram
Unable to download files - pls help!!
Since yesterday customers are unable to download files that they have not uploaded even if the views are public/shared I am a paid customer and your support phones do not work - that s crazy! I have submitted tickets but no one answers - you are damaging my business Same link, same views but in some cases customers can download files and in others, they cant. What is happening? This was working til yesterday!!
Strange performance of one field in a form...
The application referred to consist several forms and several fields in them. All forms/ fields are all working normally, except this one - List of Schools (LS) This LS is linked (look-up) by a List View named "View Updates" with several linked other data source forms. The LS hold listing of school names, ex: Yesterday School Future Academy When I added data to the View Updates from the LS, it is automatically added with ...dash.. before the school name. Example: - Yesterday School . Other data are
Not displaying properly
The single text areas are not sizing as set in the form editor and the radio buttons are being displayed as dropdown lists. Both are being displayed properly in the editor but when the for is viewed normally in a web page or when the application is accessed from the editor it is all wrong.
Replace MS Word Automation with Zoho
Hi, I am trying to import my ms access app in Zoho. So far so good. My MS Access app is using MS Word automation, running VBA code from MS access, to produce specialized MS Word docs on users demand. Users download them from my FTP area, where my access app is storing them. I am wondering if such a Word Automation scenario can be applied to Zoho, and better if such a "word processing server" exist. Best Regards, Theodore
Function not returning correct value
I have a test function not returning the correct value. int temp.temp8(int digits) { powernum = 36.power(input.digits); return powernum; } When I input 4, I get 1679616. When I input 5, I get 6 but am expecting 60466176 When I input 6, I get 4 but am expecting 2176782336 What are the number size limits or is there a problem with the power function?
Shared Apps listing in Home page is not up-to-date.
Even after an application is not shared anymore with a user, the Shared Apps tab on the Home page continues to list it. -Varun Yagain.
Change font color when a field has a value
Hello. I am using Creator to maintain an editorial calendar. We'd like to be able to see at a glance when a report has been published by making the text color change if the "published" field has a value in it. How would I script that? Would I use "on user input" or "on update", and what variables would I include? I am not a programmer so I greatly appreciate your help.
The Count Function / Deluge
I am migrating a database from Filemaker Pro to Zoho Creator. The database contains responses from online surveys submitted by customers of our software product. I am brand new to Zoho Creator and Deluge and I'm stuck on something I assumed would be easy. It probably IS easy but I could use some help. The records in my file contain three fields that I would like to count. Field 1 - "Edition". This field might contain 7 different values and it might be blank. Field 2 = "NPS_Score". This field might
Help with field please
Within my database I am using a drop-down field to sort the days of the month using the grouping feature. it works very well apart from one thing. In the drop-down choices I have (for Sept) 01 Sunday 02 Monday 03 Tuesday 04 Wednesday al the way down to 30 Monday Next Month (Oct) the 1st is a Tuesday So I have to edit the field and change the choices to 01 Tuesday 02 Wednesday 03 Thursday 04 Friday al the way down to 31 Thursday Is there a way to automate the field please Thanks
Import form and subform setup from ms access
Hi, being new to Zoho creator, I am trying to import an existing accdb. Is there a way to import the forms-subforms setup from my access app? I have a form with 8 sub-forms in my app that are used as data entry. Best Regards, Theodore
Use subforms for multiple entry
I want to add the production tools of our customers to a database. So a database with machines linked to an account in Zoho CRM. I have one form (MachineEntry) where you can describe all the specifics of a machine (name/type/year). From another form (MultipleEntry) I want to add multiple machines at once by using MachineEntry as a subform. Both MachineEntry and MultipleEntry contain a ZohoCRM lookup. When you add a line from MultipleEntry in the MachineEntry subform, it automatically fills the
Marketplace issues
I can't get the demo to run without pre-loading it with records that I don't want to transfer in the install. When shared or made public the app works fine. As a demo it won't work. What exactly is the demo? Is it a copy of the app? Could my problems relate to certain code that doesn't copy well? I can't delete Screenshot images...only upload additional images. Removing the app from Marketplace doesn't clear anything. Any insights are welcome...please help.
Street address
Is there a way to set up a form to accept the following? Address: Apt/suite: City: State: Zip code: I would like to be able to validate that the address is a real address. Currently I'm using a text field but I occasionally get something other than addresses when users input to this field.
Set variable not working in the custom button of stateless form
User Name: kumar.n Application URL: https://creator.zoho.com/appbuilder/kumar.n/reportissue Access To Support: Granted -Neeraj
Change the Order of Dropdown Items
Is there a way to change the order of items in a dropdown menu without affecting prior reports? I don't want to delete and re-add the items in another order because won't that mess up old reports? Thanks, Juliana
Why does Zoho hate me?
I've been trying to get in contact with support for a week and no response, then I started a topic and it vanished. Can someone please get in touch with me to review my issues? Thanks!
Configuring customer portal, but stuck on error 500
I tried configuring my customer portal, but stuck on error 500. Please see attachment... What next to do?
Email Data and field deluge name
I am trying to add a record by sending an email to the forms's email address. I am using a specific format to populate the fields. However, not all fields are populating. I have a field in the email called CallNo#. When i enter that into the field deluge Name field the system automatically replace the # with an underscore. I assume that i cannot use a # because on its use in URLs. Can somehow fields be mapped? I cannot change in the email field because they generated by a Commercial Computer Aided
Configure field actions - Zoho quick start guide error
Hi All, I'm new to Zoho and am following the quick start guide to build some sample apps and forms. I'm having trouble with an exercise in the Configure Field actions part (https://www.zoho.com/creator/help/getting-started/quick-start-guide.html#field_actions): While I'm trying to use the fetch deluge task to assign rec variable the value of the record to be fetched from the Product form, I use the expression: rec = Product[Product_Name == Input.Product]; Following all the instructions in the page,
Update records in Zoho forms - bug or error?
Hi, I'm trying to build a simple app that just adds points to students based on the type of networking events they attend. The following are the forms/reports used: 1. Students - list of student records with id, name and e-mail (and points accumulated) 2. Events - list of events with event_id, name and points 3. Event attendance - Form where I will select an event and enter student ID so that student gets the required points In the event attendance form, once I submit the form, I want the students
Published app, report function not working, why?
I just published an application to marketplace, why is it that the report function is not working? see here
Subform: On Delete successful
I have a subform and it is very important to know when rows have been deleted from the subform. As a result, I have actions on the On Delete Row in my script There is a bug when user click the "X" to delete a row from the subform but do not click update on the main form because they change their minds. The actions on the "On Delete Row" still get performed even though the row was not successfully deleted. As a result, I am getting unnecessary notifications. If the row does not successfully get
Deleted subform data persists in database
When I add data to the subform embedded in my main form (A), I can see the data reflected in the view associated with that subform. I just noticed that when I delete a row of my subform in form A, the data still appears in the view. Because I am using the subform data to populate another form (B), this results in erroneous data being propagated to another form. This is troubling to me - when I delete data from a main form, it is gone. Why then does subform data persist after deletion?
Can This be done?
Hello all, I run a Heating firm in the north and need a database system to suit my needs but struggle to find any software or online databases. The only software i can find that suits my needs is from a company call commusoft. The software looks great but the costs are really to high to merit using it. So the question is can i make a zoho creator database with such fictions as customer details, postcode look up facilitys, Service reminders, appliance database and fault history? The website for
How to create a list of missing submissions
I have a app that i made to capture time for our employees. I have an employee list that I am working with, so there is an established base list of employees. What i need to do is create a function (or a button in a stateless form) that will allow me to generate a list of employee who have not yet submitted their timesheet, based on a date field (Week_of). Any help would be greatly appreciated. Thank you in advanced.
Fetch records from drop down
Dear all, I would like to fetch a record from a drop down field in the main form to a text field in the sub form. can you tell me how to do it? thank you, michael
Next Page