Htlm View showing upload or not links from differents views
Hi, I have a HTML view that summarize datas and uploads from some views as: myAnswer = FormA [ID == input.recId.toLong()]; myAnswer1 = FormB [FieldUnique == myAnswer.FieldUnique.toLong()]; myAnswer2 = FormC [FieldUnique == myAnswer.FieldUnique.toLong()]; So when I want to put a download link in the HTML View I write this code: <td NOWRAP> <a href="https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=myAnswer.UploadField%>&sharedBy=IM&appLinkName=NAMEAPP&viewLinkName=NAMEVIEWFORMB"><%=tempVariable%></a></td>
multiple many-to-many relationships
Main Problem is I want to ensure the database structure is correct so that I can convert it into Zoho Creator Form Combination (This is one element from a multi-function 50 Form application (Functions range from ordering products from suppliers to maintaining inventory etc...) I can give access if necessary, I have attached a visual of the 'problem' as Design Specs.pdf and A copy of the already implement database in Zoho Creator (which works and I am happy with, I develop the relationships in Access
User Creator to create seo application to track domains and project status/next actions
Is there a way to use Creator to extend ZOHO Crm to track domains per Account and marketing activities. Is this done easily by integrating zoho projects or do we need to build a custom app in Creator? Thank You
Creator App - iPad / iPhone Issues
I have a lookup field (Lookup A) that fetches data and updates other fields in my form. One of the fields updated is a another lookup field (Lookup B). Lookup B then updates other fields. Problem 1 - Using the Zoho Creator app, this works on my iPhone - However - it does not show the data in "Lookup B"...instead it says "1 option selected" - How do I get it to show the value of Lookup B? Problem 2 Creator App on iPad - Lookup B is not updated Problem 3 Using Creator App on IPad - Pictures are
Missing Embedded Code
Dear ZoHo Experts, I have a problem with ZoHo Creator, i have builded an app. It looks good. But now the problem: I cann't find the embedded code for the website. It seems that the embedded code has disappeared from the Publish tab. Can you figure out what is wrong? Is it a bug that you have to solve? Kind Regards, Jan Willem
Possible Bug?
Hi, When I try to execute the "Add Product" action from your Order Management 4.0 sample. (Please refer to attachment Script image) The Error message displayed. (Please refer to attachment Error image)
Why does this request give error 2892? The application name is correct.
https://precreator.zoho.com/api/json/myapp/forms/?authtoken=0e508cec205591dc3f137662b614f2fb&scope=creatorapi I don't know why this gives an error. The authtoken and application name are both correct. Is this a bug? If not, how can this be fixed? Thank you.
Creator Data WIll Not Import Into Zoho Reports
I am no longer able to import Creator data into Zoho Reports. Steps to recreate: Creator - Data Location = web, in the URL box I am inserting the URL from Creator "links" "permalink", "publish URL". It returns a message "unknown host or host not reachable. Please verify the URL provided"
Submit Failure Message when Press enter
I have a form that will get data from zoho crm. My problem is when press enter, it will show the error message, All i need is to disappear that message only, if (input.Email != "") { vSearch = "(Email|=|" + input.Email + ")"; crmRes = zoho.crm.searchRecords("Contacts", vSearch, 1, 1); if (crmRes.size() > 0) { fa = crmRes.get(0); input.FranchiseApplicantsID = fa.get("CONTACTID"); input.First_Name = fa.get("First Name"); input.Last_Name = fa.get("Last
Pricing zoho creator
Hello, I used the free version of Creator Zoho, now I require buy 1 user, when revenue in my account the standard plan is $ US25 for 5 users, but if I enter a new user the standard plan is $ US5 for 1 user, I need only 1 user, I can buy it? Julian Calderón Escobar,
Not All Table Objects Available in Form?
In my Phone_Line form, I am trying to add a reference from another form Line_Account. The following is the code from the field I'm creating in the form Phone_Line. Why does this work: must have Line_Account_BTN ( displayname = "Line Account (BTN)" type = picklist values = Line_Account.ID displayformat = [ Parent_Account_ID + " - " + Phone_Number ] sortorder = ascending searchable = true width = 206px ) But this does
Is there a formal enhancement request system with Creator?
Is there a formal enhancement request system available for Creator? I am hoping that I can log many enhancement requests to make this tool more wonderful. It is a great tool already. But like every piece of system, there are always rooms for improvement. I would appreciate if any of the Zoho Creator team can response to this. Thanks.
Lookup Link Records with Pivot Tables/Charts
We have a table of sales data (A) which link to a table of product data (B) via a Lookup from A accessing a unique product ID in B. How can I access parent fields in B while running reports for A? This help document shows how to do this for List reports under the header "Creating a Link to Parent Records":https://www.zoho.com/creator/help/forms/creating-relationship.html But how do we do this with Pivot Tables & Pivot Charts?
Remove Commas on a Number field
Some of the user put commas, when they put commas, The formula field is when wrong, How can remove commas automatically on input?
Ratings
I am working on an application that I want users to be able to rate records (out of 10) in. I have created the fields for it, however, I am having trouble figuring out a way to display the average ratings. Right now, when a user rates a record, the view just creates a copy of the original, with the new rating. Could someone explain how I can get the average, without creating extra records?
Import Inline Subform Data
Is it possible to import data from Excel to a form that has embedded subforms in it (subforms that are created inside the parent form as opposed to being created on their own and linked)? In excel I have one subform field populated with comma-delimited values. In the import wizard, I map this excel column to the subform field (tried it by selecting and deselecting the import subform data checkbox on the first page of the wizard). The import declares success for both the parent record and the subform
Automated Mail to Specific used
Is it possible to send automated mail to specific users based on user selection? I have 5 spocs whose names are available in the drop down field, Automated mail need to be send to them based on the user selection with some or complete data of the details entered by user. As of now I have used send confirmation mail option which send mails to all users. I need to restrict it to specific users. I don't know scripting nor any have any developer to help me. I understand it is possible with little bit
Alert based on calculated time
Hi, I write to support but have no answer to my problem. I have a script to show an alert based on calculated time (lookup field of meeting) "on input" of field. Now, with Creator update, I try the same script in other form but don't run. Anyone have similar problem with? Thanks in advance. Mike if (input.lookup.toString() != "-Select-") { meetTime = FormMeetingPlace [PlaceMeeting == input.lookup.toString()]; timeDiffinMilliseconds = (meetTime.StartTimePlaceMeeting - zoho.currenttime);
Zoho Creator Form Builder is inaccessible to some users
Form Builder is not accessible through key commands or a screen reader (only through dragging with the mouse). Our users with visual disabilities and limited dexterity are not able to use the service.
Cannot edit records
Users of my application are unable to edit any records. I have logged a support request and need someone to contact me immediately
Possible bug with date-time list
I have a records with date-time values (Program_Starts), and have copied some of the values below to explain what I'm seeing 29-Apr-2014 13:00:00, 29-Apr-2014 17:00:00, 30-Apr-2014 09:00:00, 30-Apr-2014 13:00:00, 30-Apr-2014 17:00:00, 01-May-2014 09:00:00 What I'm trying to do it make a list of records that only have date-time values after today. Here's my code class_list = (Classes[(Program == "XYZ" && Program_Starts > zoho.currentdate)].Program_Number).getall(); When I run this, it returns all
Calling Zoho Creator API from .net CSharp
I'm able to make the request with desired fields (WebRequest.Create), using csharp code but got an error in response. Below is the response (request.GetResponse()), all required fields are provided still I get the error: Failure, Enter a value for...... <response><result><form name="Decision"><add><values xmlns="add"> <field name="LDC"> <value>AGL</value></field> <field name="Commodity"> <value>Gas</value></field> <field name="Customer Name and Parent Name"> <value>TEST CUSTOMER</value></field>
Autopopulate value in sub-form
Hi, I have a main form with sub-form that fetches another form. Sub-form has product related fields. What I want to do here is, based on the selected product(From CRM Module) I want to fetch its related price to a field. But it is not working as I expected. If my lookup field for product is within creator I dont find any issue. If I want to get the product from zoho crm I am not able to auto-populate unit price field.I don't know what I am missing. Help me sort out this issue Here is my code, [Products->On
Backup Failure
We set up Sales Management 4.0 for testing purposes, and we're getting failures when trying to create a backup of the app. Is there missing data we don't happen to see?
how do i change where the email notifications of a new request go?
the admin who created our request form left the company and i want to change where the email notifications go, as of now they still go to his email address. ps im a programming noob. joe
No access even after sharing
How come when I shared my app to my friend, he get's "You are not allowed to access this application." message even after he clicked on the link that came in his inivte mail? I have shared the application with him.
File upload does not appear in record
I created a form with a file upload field and in the form I can upload the file but when I view the record in the report view the field is missing. What am I missing or what am I doing wrong? Is there a place in the properties of the file upload field that I don't enabled or modified properly?
user roles can be assigned only after approval of Manager
hi, if admin assigned roles to user , mail goes to manager and if manager approve then only respected role assigned to user.. it is possible,if yes how?
Issue about HTML page
Hi, In old edit mode, I can using the code in HTML as below: <%if (count(Dept[Dept_NO == 1])>0){%> You have already added the department. <%} else {%> You need to add department first. <%}%> But in new edit mode, I can not using this code in HTML. It displays "null". Kindly help me to check it ?
Implement search algorrithm on zoho data
Hi, I have to created a form which takes the user input and stores data, for example a form like expenses. Now i have to create a page which will take input like expense type/date/ expense by fields and select all the rows belonging to the input and calculate the aggregate expense and display it to user. If i give all the parameters the logic works but i want to know if we can build dynamic queries based to user input to fetch the records from the database.
MS Access Migration issue
I have used the migration tool to migrate a small database from access to zoho. Each time I try I get a pop up that the migration was successful, but when I go to my account on zoho it is not there. Is there something else I need to do? I have tried waiting a whole day and checking back, but it is still not there. Thank you , Matt Holtzclaw
Zoho Creator - Mobile App
Hi I was using the filter to search for a customer in Zoho creator mobile native app. I received a message "Sorry" the application Zoho creator (process.com zoho creator.a) has stopped unexpectedly. Please try again. I thought I would wait 20 mins and try again...i got the same message. I am on day one of the 15 day trial.
Date field, how can i limit a value up to 30 days?
When i enter a date, how can i set limitation til 30 days? The date purchase will not exceed to 30 days, if exceed, it will pop a alert? I just need the If Statement for this, hope you guys can help me
getUrl has stopped working. Are others facing this issue too?
I had a working application until yesterday and the now, the getUrl call returns null for the code and text!! I have verified this both ways - I make the get call (from my browser) from my own PC and it works without any issues and I have also tried several other urls in the getUrl call. getUrl simply does not work. My suspicion is that a backend upgrade by Zoho could have caused this issue. Is anyone else experiencing a similar problem?
Invited new users being put into "trial" accounts that have no ability to access shared applications
Help! Starting today, my invitations to new Zoho users with whom I have shared my applications can no longer access them. They never see the "dashboard" screen - only the screen that prompts them to start creating their first application. They have to "upgrade" to a paid subscription in order to see my shared applications. I am supposed to have unlimited users on my subscription. Please advise ASAP!
checkbox to show/hide fields
I figured out how to have a field hide/show when a specific radial button is clicked. But I can't figure out how to get specific fields to show when specific check boxes are selected. Can someone help me with this?
need help with regular expression and matches function
if(mystring.matches("?")) == true) I need to check if mystring starts with number or any letter in alphabet A-D, not sure how to do it. Thank you in advance for help.
Execution Failed
Hi, I'm getting an Execution Failed error when trying to execute a Scheduled Report. Execution Failed Error details Error in executing ... (Custom Schedule) Error. Error in executing Send Mail Task Please advise on what should be done.
Execute Script Error
Hi, I'm getting an error when trying to execute a test report. I've attached the error. Thanks, Jon
How to get GetURL variable and pass it to another form?
I have a form that is filtered using a url variable. Example: ..//#Form:Income?invoice=123 When I click the "make payment" button from mu invoice page. The user will be redirected to another payment page and the payment page will inherit the selected invoice ID (in this case is 123). How should I code this in my "make payment" page?
Next Page