problem inserting a field upload into a record
I have records created based upon options selected for a list. However, the only field that isn't populated is the file upload . For some reason I get the error-the file upload field can not be add to insert record. Please assist.
creating invoices from creator
I'm not a developer but fairly technical. Is there a tutorial regarding how to do the following 1 - I have a Customer file 2 - I have a file that has all items we sell and prices related I also have ZOHO Invoices setup in a way that integrates with Authorize.net (our gateway). How do I tie this all together so something as easy as the following can be done. 1) An employee can pull up a customer, apply detail items to it, generate an invoice, and email it to the customer, who can then pay it through
Custom Actions - Field Validation & E-Mail Notification
Hello, I Would Like To Create A Custom Action For Each Records It Checks If The ALERT Field = "EXPIRED" Then Sends An E-Mail Notification. For each records with input.ALERT = "EXPIRED" { Send E-Mail Notification } ... Looking Forward To Your Help... Thank You.
Not sorting fetched records
Hi I am trying to fetch and sort a list of items before adding them to a drop-down list. Here is the code: destinations = Destination_Modifier[true] sort by Destination_code; for each destination in destinations { Destination_Code:ui.add(destination.Destination_code); } It fetches and adds successfully but only the first items are sorted and then many items are not. Any idea what am I doing wrong?
Usable list of values in a single field - is this possible?
Quite new to Zoho so please bear with me, is there a good way to achieve the following? Suppose I have two databases, database 1 is a list of companies and database 2 is a list of projects. Each record in the project database needs to contain some basic info about the project, and a list containing a selection of companies from database 1, with the potential to create project-specific views and reports using this list of companies. I would really appreciate any advice as to whether this is possible
Share form/view between apps
Is it possible to share the same form/view and all data between applications? I have the same application duplicated for two different user groups, they have the same 5 forms/views but one I need all the data to be shared and editable between both apps.
Login for users - basic question
Hello, My company is looking to use Zoho creator to collect sales reports. I've created the necessary form, but I am wondering if each sales person can only have access to their specific sales reports and not every else's. In other words, when one of our sales reps logs in, I want the form to know it's them and only show them their reports in the spreadsheet view, but have managers able to access everyones reports within the company. Is this achievable? Thanks everyone!
Dropdown not loading a list today
Hello, system are not loading a dropdown list in my application consulado-geral-do-xxxxxx form Matr_cula. The field Cidade Res. It. * are not displaying all options. Still loading, loading... without the list. It's a mandatory field, so we are impossibilitate to work on this today. Thanks Mic
Migration tool and Lookup field problems
I'm having problems importing data from Excel into my form using the Zoho Migration tool. I have 2 fields in my Zoho Creator form, called Form1: FieldA is a plain text field which contains names (example: Apple, Banana, Grapes) FieldB is a Lookup field, which is a multiple select list. This looks up a name from Form2 (example: Red,Yellow,Green,Delicious,Disgusting).Visually, this is displayed in the Zoho view as a comma-separated list for that field. My Excel file that I use for the Zoho Migration
Tag Clouds
Have you considered adding a tagging and tag cloud capability to Creator?
App workflow overview
I'm sure I'm missing something obvious, but I have run into a brick wall on my private app... So I have several forms and views. I just created an HTML view, put my main control panel in it, started the app. Entered a couple of required items, all good! But I can't find where to go back to that item in the database and edit and fill out other pieces of information! How do I, as an application USER (not admin) edit and view information that I just entered?
How to set conditional Next URL to go on success?
How to set from the script conditional URL to be displayed when a form is submitted?
We are looking for Zoho Creator users to speak with BusinessWeek. Would you be interested?
If you're a US-based business using Zoho Creator, BusinessWeek wants to talk with you this week. They are interested in how a non-technical business person uses Creator to develop apps. Requirement: You/Your Business is based in the US You are a business person and not a developer You are willing to share your app-building experience You are available to speak with the press ASAP Developers: You can also get your clients to participate in this campaign. Fill in your details in the form below, and
Subforms and record counting
Hi, Just a little remark about using subforms. Subform is a very nice feature in ZC and can be used in a lot of situations. It will add a lot of new records in our account and then our limit can be reached very quickly : it needs one record + n records for the "subform-records" : So 100 records multiplied by, say, just 2 subform-records each = 300 records. Without subform, we just need 200 records ... I just wonder if it's really logical to count subform-records as one record ! Cyril
Problem Inserting Record Using XML API when there is a URL field included in the XML.
I am trying to insert a record that has a URL value which is actually a google map address. If I exclude the URL the record insert works fine. But if I incude it fails. URL: http://maps.google.com/maps?q=-27.53150579971,153.07693150793&t=h&z=18 I have tried wrapping with CDATA and it still fails. I get an error code 4600. getUrl Request: https://crm.zoho.com/crm/private/xml/Leads/insertRecords?newFormat=2&apikey=ADj-pp1lHB1bAdeClMlwQoXYrTHXc2z4kQaMGWeIdlI$&ticket=e601c6db9fe24df81a0265475bdfd40b&xmlData=<Leads>
Problems updating the field value in my form!
Hi I have problems with my form. If I change the value in the drop-down list and try to update the form nothing happens. It seems to have started in the beginning of last week. This is becomming a bit anoying so any help will be appreciated Any ideas? Dennis
Mail merge
Could someone please create an example so we can grasp the idea of mail merge in Zoho Creator. I have a for with Name, Address, Telephone No and Email. I have a form with a multi line field that I want to include a mail merge so each email is personalised with the name and address. I then want the text in the multi line to be emailed to the correct email for each recipient. Thanks for any help you can offer. Nigel
Form changes will not save
I tried to edit a form by inserting a second address line but every time I go to use it, the changes are not there. It looks fine in edit mode, but not when I try to use it....
Error occured while uploading the file
I'm unable to load files to form. I get the above error.
Add a "Run Now" option to the scheduler.
Since the only way to write a custom script to be performed on the database and process it on demand is by creating a custom schedule. A "Run Now" option would be a simple and nice feature instead of entering a time in half hour increments. This way once the save button is pressed the script would run immediately. This would be helpful when there are thousands of records that need bulk edits made instead of using the bulk edit feature and only being able to update 200 records at a time.
HTML Reports
Hello, I am looking at write a HTML report for my Zoho program but I am not sure where I can get help from to write it. I want to have a report for each order which will have information on it such as customer order numbers, delivery dates, and then machine times and notes which are all related to the drawing number. Could someone point me in the right direction in making this report? Is there a tutorial or a template I could play around with to learn how it works? Thanks in advance
How to automatically insert a value into an email from a completed form
I made a simple form to retrieve lead data for an upcoming show, see the form: https://creator.zoho.com/millward137/medtrade-vegas-2012/# The first field is "First Name". I need this information to go into my email that I send to them from the view area but can not for the life of me figure it out. Please help. Thanks,
How to make the field "Name" in the "Requester Details" inactive
How to prevent make nonsense in the "Name" in the "Requester Details" and allow only the names of the Active Directory? For example, how to make this field inactive, allowing the selection of only the Active Directory ? Thank you.
Commented Code Lost from Free Form Script Editor
I have lost about 70% of the code for one of my forms. EmailToLeadForm. The code I lost was in the ZC_Content.On User Input. There is only 85 lines of code and there should be about 200+. Are you able to revert to the previous version so I dont have to spend hours rewriting the code
Dynamic Field Color in Calendar View ?
Is it possible to have dynamic field colors in a calendar view ? For example if I have a FORM called celebrations, which contains 3 fields (Type, Date, Description) and Type is a dropdown of three choices {Birthday, Anniversary, Wedding} and I build a calendar view based on this form, I would want 'Birthday Entries' to appeare with a 'Blue' label, Anniversaries with a 'lime' label and Weddings with a 'Yellow' label. I cant see how to include this in the deluge script using [zc_LblClr] ?If this cant
Help for Newbie with Report Schedules...attaching report to weekly email.
I am new to Zoho Creator and trying to figure out how to schedule a report to be emailed weekly in pdf form. I have set up a Form that my business uses daily to report sales info. I want to schedule a report that will automatically email a pdf report to me with various sales data pieces. I have set up the reports.....but can't figure out how to "attach" the reports to the email option in Report Schedules. The online instructions for Report Schedules indicated that in GUI mode there should be a
Creator Form -> Potentials
Hi, I am trying to create a form when upon completion a new "potential" is created in Zoho CRM. In my implementation, the potentials tab has been renamed "Sales". When a form is submitted, nothing appears in Zoho CRM. I think the problem relates to the mandatory Closing Date field. I don't think the formatting is correct for it to link correctly into the CRM. Can someone advise me? Here is the script I'm using: leadinfo = { "Sale Name" : input.first_name + " " + input.last_name, "Closing
Drop down list not displaying records - has stopped administration for today - When will this be fixed??
Hi there, Our drop down list now longer displays all the records from the drop down list. We have a large no. of records to choose from. This has halted the administration for our company for today, which is costing us alot of money. We desperately need this fixed ASAP. Can you please provide us with some feed back, or at least let me know if I should look into alternative options (adding a new text field and getting rid of the lookup field if its not going to work). Thanks Patrick
Success Message:
I need to disable the form Success Message: I'm using the following syntax to load a record in a frame: <a href="http://creator.zoho.com/ensobase/home/Deals/record-edit/All_Deals/(ID)/" target="ltarget">Address:</a>This URL syntax properly targets the frame with the designated record ready for edit. However, when I save the form I get the form Success Message: The real problem is that the Success Message from the following URL breaks out of the frame and renders in the TOP-PARENT window. http://creator.zoho.com/appcreator/jsp/successpage.jsp?success=Data
How many simultaneous form entries can happen if we embed the form in our website?
We would be sharing this form with about 20 internal team members and just wondered if we would run into problems if 2 or more people happened to be entering data into the form at the same time. I currently have one form created using the free version... Thank you!
For Subform on user input it does not seem to update main form unless you click another field first
Hi I am updating a main form field from my subform Main form = balance each row in the subform is for payments For testing only one row in my subform If i enter a payment and click another field the balance changes and upon clicking update it is stored correctly in the main form If i enter a payment (DO NOT CLICK ANOTHER FIELD) I can see the Balance change (the on user input script is working) but when i click update the value in the main form is not updated Thanks
Form Object to Function my Form has Subform Rows
When writing the function i can see that the subform is available as a collection but how do you know which row is being acted upon example Function .... .... if (Function.SubForm_1.this_is_a_row How do you know which row is being evaluated Thanks
Form does not always clear on entry
I have a form which seems to be working fine and storing information as expected. However I have a small problem in that on submit, the form does not clear, unless all fields were complete...even non required fields. Not sure if it matters but it is embedded in an iframe
Reports on multiple views in Creator
Hi, I have created several views in Creator and they are all linked to each other in some sort of way. I am trying to find the best way to report on them. From what I see, I am only able to report on one view in Creator. Do I need to import/export the data into Zoho DB & Reports in order to be able to generate reports using multiple views. If so, how do I do this? I would think it would be rather transparent but having a hard time finding instructions. Thanks for your help! Quranna
Dropdown autopopulation
Hi, I was wondering if it is possible for the dropdown list to be autopopulated with values from another field. For example: View 1 "Authors": Name, Books written View 2 "Books": Title, Author(dropdown) Now, I would like the Author(dropdown) in Books to automatically contain the list of records from the column Name (in Authors). Is this possible?
NOT AGAIN!
Yet again you have released software that simply DOES NOT work. The lookup lists in my edit forms are not loading properly which makes my application near unusable. I have emailed support with details.
Student Conference Counts
Newbie here... I have a form for student data in which I enter all demographics. I have another form used for each conference we have with a student. In this I record the student name (pulled from the demographics form), date of conference and notes. On the first form, I would like a field that calculates how many total conferences I've had with each particular student. It would also be nice if it could show me the dates of those, but this isn't a must-have. So, when I look at the demographics form
Built-in Functions
HI, is there a page with a list of deluge functions (toUpperCase, Lenght, ...)? thanks
transfer field data from stateless form
I have two stateful forms - "Entry Form" and "Entry Detail Form" and have set up the Entry Form with Entry Details Form as a sub-form. Unfortunately the scripted calculations carried out in the sub-form, whilst they work in stand alone form, do not work in sub-form, so I thought I would try to make entries to the sub-form using a stateless form "Class Entry". However although I have set up the stateless form and it works perfectly properly, and despite reading and re-reading the advice in Developer
Subform: problem with 'Decision box'
Hi ZC ! we use several 'decision box' fields in a Subform, used to do calculation. Creator believes that all the DecisionBox are checked (true) as they are all unchecked. Could you have a look in https://creator.zoho.com/wdrspens/slm-equestrian-centre please ? Thanks. ps: notice also that formula field don't display its result in subform.
Next Page