Re Chinese version of the synchronization
Hi Latha Hope to the creator of the new features with the Chinese version of the synchronization, for example, create a report directly to thecreator, etc. Thanks Stanley Guo 2012-1-29
Urgent help! Changing a field type from 'Single Line' to 'Import Data'- will I lose previous entries?
Hi everyone, I'd like to take advantage of the new search and auto-complete function in creator. I have a 'Single Line' field that I'd like to change to an 'Import Data' field. Will I lose the data from previous form entries if I do this??? Thanks!
On Load View - Check Fields & Input Value
Hello Zoho Community, On Load View I Would Like To Check Fields & Input Value. FOR EXAMPLE: When I Click On The View. It Will Auto Check Each Record If Current Date Before 1 Month > Membership Expiry Date Then On Input.Status Show "*" On Load View For Each Record If zoho.currentdate (BEFORE 1 MONTH) > input.Membership_Expiry_Date { Input.Status = "*" } Looking Forward To Your Help. Thank You.
Custom Action - E-Mail Notification + Input Current Date
Hello Zoho Community, Custom Action To Send E-Mail Notification + Input Current Date. void email.EmailNotification(int toaddress) { sendmail ( To : zoho.adminuserid From : zoho.adminuserid Subject : "Subject of the email" Message : "Your message" ) input.Sent_Date = zoho.currentdate; } Looking Forward To Your Help. Thank You.
Sub Form Field Validation ?
I have a subform where I have set a script for converting the contents of a field to 'Upper Case' input.Product_Description = input.Product_Description.toUpperCase(); And when I access the form directly, it works really well - and I can add the script to On Add, On Edit, Validate etc..doenst seem to matter... But when I enter data through a master form, that has the first form embedded as a subform, the field criteria are not inherrited, so the data entered does not get converted to Uppercase....
select criteria query
I have a form for a 6 month period, January-June. If a student comes in January, I mark the appropriate dates with a '1'. If the same student is absent all February, for example, I mark the dates with '0'. I set the criteria for all months to read 'display if date columns equal 1'. Of course, it displays the student for January, but I expected it would not display that student in February, however, it does. Is there a way around this ? Thanks for any advice.
Field Actions - On User Input
http://help.creator.zoho.com/Field-Actions.html "The On User input script will not be called if there is no change in the value of the field (i.e if the new value being set is same as the old value." This implies to me that I should be able to make a change to a field On Load and expect that field's On User Input to be called. Through all of my testing I have not been able to make that the case. How can I make On User Input code be called as a result of changing a value in the form On Load?
see only selected records (updated)
I have 3 forms the first form is called "Car " single line "Automobile Make", single line"Model", single line"colour" single line"unique ID" (database driven) Each Automobile has 5 wheels and tyres hence 2nd form is called "wheels" Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile Make" single line" Wheel1, single line" tyre 1, single line"wheel2, single line"tyre 2, etc etc Form 3 is called "emissions" Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile
Update with ' symbol
Hello I would like to update a field with ' symbol Here is my request : <FL val="2ème ligne d'adresse"><![CDATA[${sdme_ligne_d_adresse}]]></FL> Zoho response shows that the update is succesfully done but nothing is done in zoho Can you tell me how to add a ' (apostrophe) symbol ? Thanks for your help Regards
No hyperlink for underlying data in ZOHO creator report / chart
Hello i am a ZOHO creator enterprise edition user i have created some reports / charts for my colleague but only the Admin user can use the hyperlink to see the underlying data could any one show me how to share charts with underlying data enabled thanks regards, Matthew
Custom Action showing on clicking on view
I love the new feature of being able to put a custom action in any location on a View. However when I click on the view button to the left of the record the custom action shows as a field label. Apparently it pushes the other field names down on the list so the data associated with the field label is offset by one. If the view is: Field1 Field2 Custom Action Field3 Field 4 Field 5 Data1 Data2 Button Data3 Data4 Data 5 Then the view is Field1 Data1 Field2 Data2 Custom Action Data3
Why not provide "break" keyword in Deluge scripting?
Hi there, Why not provide "break" keyword in Deluge scripting? In many cases, I've to imitate "break through out loop" function like this: for each r in form { processed = false; if ( !processed && conditon ) { processed = true; process(); } } If Deluge scripting provides "break" keyword, I can just implement it concisely as following, just like other high level languages, such as Java for each r in form { if ( conditon ) { process(); break; } }
Field Number
Hi, anyone may suggest how to display in the number field the zero (0) at the beginning of the number string? And also, anyone know if exist an option to format the number as this example: 000.000.000-00? Thanks!! Mic
Testing Scheduler?
Is there a button to test the scheduler? In other words once I've created the schedule is there a way to cause the event to trigger without waiting for the clock to roll around to the time of the event? Herb Wexler
Need help with null values
I have two fields that I want to add. Deposit 1 + Deposit 2 = Total, however one or the other might not contain a value. How do I get it to add to give me a total if both fields are not completed?
Update Links in Help Center
Am hoping that by reporting these it will help others also 1) https://help.creator.zoho.com/Deluge-Reference.html Cant find the link from the help center, the only Deluge link goes to https://help.creator.zoho.com/developer-guide-home.html 2) https://www.zoho.com/creator/help/script/aggregate-records.html not in the table of contents for Zoho Creator Help Center > Deluge Developer Guide > Statements > Data Access >
will the ical feed work with 30 boxes?
Unfortunately, Zoho doesn't have a robust calendar for scheduling, so it has referred developers to Google Calendar. I (and a number of others) am very unhappy with the Google Calendar and am trying to find an acceptable alternative. I have heard 30 boxes is a much better calendar that google, but I can't seem to get the Zoho generates iCal url to work in 30 boxes. Do you know if it will work with 30 boxes or not? If so do you have any tips on how to make it work with the zoho generated ical feed.
ZC there any way to get SQL or ORACLE data in these databases?
Hi ZC there any way to get SQL or ORACLE data in these databases? Thanks Stanley Guo 2012-01-29
Stateless buttons not wrapping in IE 8 & 9
When I embed a stateless form in a website Internet Explorer does not wrap the form to fit in the space. Firefox & Chrome will wrap to fit in the space on the website. In IE 8 & 9 the buttons do not wrap and the form is truncated. I attached a document with screen shots. Is this an IE bug or is there some code I can add to get the form to wrap to fit the space? Herb Wexler
Add calendar by URL to Google Calendar Failing Again
I read the previous discussion and resolution regarding this problem this problem, which apparently occurred about a year ago. I am having the same problem today. I suspect the problem has come back again. I am using the example provided by zoho. The iCal url posted in Google is as follows: https://creatorexport.zoho.com/acalver/mycal/ical/CALDATA_View/DTSTART=STARTS&DTEND=ENDS&SUMMARY=TITLE&DESCRIPTION=DETAILS&ZC_FULL_DAY_EVENT_VAR=ALLDAY Google returns the error: The address that you provided did
Lookup field doesn't update the value
Hello Team, After that migration of Lookup Field there are few records in which the Lookup field value doesn't seems to be update. Application: Penta CRM 11 Form: TO DO Form Record url: http://creator.zoho.com/piju2111/penta-crm-11/To_Do_Form/record-edit/All_Records_of_TO_DO_Form/190193000006486043/ When you open the above url it show the CallStatus feild as "Scheduled" rather we tried twice choosing "Closed" and submit the form. * Edit access given to support
Sub-forms in sub-forms
Hello, I have 3 forms - Machines, Drawings and Works Orders Works orders has a look-up field to drawings so you can select the drawing number for the order (as well as other fields in the Drawing form). But the Drawing form as a sub-form which links to Machines. This is where information is store for how the part is made and times, etc. Under my view for Works Orders - I can't get it to show up the relavant fields from my Machines form (the sub-form in the Drawings form). Is there a way to display
Lookup Forms Issue
I'm on my trial and I have an issue that is a kicker to determine going forward. I'm setting up a business process that each form will build on a previous form's submitted data. Form 1 - initial input to start process Form 2 - management form, to be used to accept what is in Form 1 - this form uses a lookup field to get "Name" from Form 1 Form 3 - is the next set of criteria that "Name" will need to go through. (HERE IS THE PROBLEM - see below) Form 4 - another management form to determine going
Adding links to Edit Form and Pass Value
I have a relatively simple DB schema. I am building an application for a charity auction. There are multiple bidders, each of whom will likely bid on and win a number of different items. We won't know the price they will pay for an item until the auction is over. At end of the auction, we need to list all of the items that each bidder won and total up how much they owe. There are 3 tables: (1) Bidders. While there is information here like name and contact info, we are concerned with 3 fields:
Need to fetch a record from another application
I understand that ZC does not support fetching records from another application. Sadly, I'm new to ZC and don't understand the nuances of building functions. I have an application called Common Lists that contains multiple forms populated with common data for an organization (e.g. Employees, Departments, Accounts, etc.). I want to build a suite of applications that share the common data in the Common Lists application. For example, the Purchase Manager application has a form called Requisitions.
I created a form. How to prevent people from viewing the database of records?
Hi, thank you for this useful tool. I just created a form and made it public. How do I prevent people from viewing the inputs made by other people? Currently the records can be viewed when the people clicked the database view. All advice will be greatly appreciated. Thanks!
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
Next Page