is UTF-8 character format supported for importing and exporting data?
Hi, I would like to import and export UTF-8 character with csv file on Zoho Creator. But UTF-8 character cannot be imported into Zoho Creator and UTF-8 characters is exported in garbaged characters in csv file. Regards Keita
Regarding external access to Zoho Creator databases
Is it possible for us to externally access and modify the fields in the Zoho Creator database outside of Zoho -- for example, to populate corresponding fields on a PHP form on our own website? Thank you!
"Date" field prints date and TIME from SendMail script
I am new to ZC, so this may be a fairly basic question: I created a date field called Start_Date, but when I call it up from a SendMail script it comes out with a date and unwanted time in the e-mail. (The time is always 08:00:00 - maybe because I have set the time zone as GMT) Is there a way to defeat this? It seems odd if you define a field as date only that it should produce a time as well.
documentation for executeXPath()?
Re the Deluge function "executeXPath()": Is this a wrapper for a specific Java function? Is there any comprehensive documentation on the xpath expressions and syntax that can be used?
Links in Table in HTML View
I have an HTML View that simulates my idea of a subfiorm with a table. I want to be able to move to a form with this: <td><a href="http://creator.zoho.com/peaslee/hyde-park-administrative-center/#Form:PermitComment">Add Comment</a></td> It just goes to the application's home page. Support edit enabled. Bruce
How do I test for a number?
How do I test if a string variable is a contains a number?
Order of Dropdowns
Is there away to sort the dropdown lookup menu's, I havent had much luck changing around the settings in the view
Dynamically add a value to a field
Hello, I have a form (Students_form) to add students information. Let's say that Students_form has two fields: 1) Student ID (automatically generated by Zoho Creator) 2) CostPerHour which is a currency field I have created another form called Invoice_form. Let's say that Invoice_form has again two fields: 1) Student ID (which is a Lookup field from Student_form) 2) CostPerHour wich is again a currency field What I would like to do is the following: When I select the student ID from the dropdown
Output data, taking selected information from a range of forms based on choices within each record
I have a question. I have an App with three forms in it. Form A - records contain a reference number and text fields.say A1 A2 and A3, and a lookup checkbox field which takes single line data from the records in Form B. Form B - simple records which contain only one field, single line text. This is read by form A and C to provide the check box field. Form C - Contains another reference number, a few single line text fields, and the same lookup check box field included in form A, reading the records
Bulk Editing a Checkbox Field?
I'm a new Zoho Creator user and I've been impressed with the service overall. Very robust and simple to use. But before I can bring my organization's data over fully, I need to figure out a solution to one problem ... I can't seem to figure out how to bulk edit a check list (multiple item) field without deleting the existing data in a record. This is a frequent need so I need figure out a work around. In another thread, "Suggestion for bulk edit of a multiselect field", a Zoho employee indicated
Sort Lookup Dropdowns
How do I sort Lookup Dropdowns, I tried changing the settings in the view form but when I use the lookup dropdown in a form it only shows in the order it was entered,
Embedded Grid view not updating
I have an embedded grid view in my html view. I can change the values in the grid view, but the Save at the top never changes so that I can save the change. Is this a bug or am I doing something wrong?
Backup isn't working
Just tried to start a backup, but am getting: Application Status Start Time Description Photo and Video Forms Failed 2011-09-15 16:08:12.0 null
Edit on linked forms from Views
I am very excited about being able to enable links from within views to related forms, can we have the ability to edit, once you have clicked thru to a linked form? Currently, if I want to edit, I still need to go thru and search for it, and then edit. This would be a really handy feature if enabled. Many thanks!
Share/UnShare Deluge task
I need to implement following: by creating new user in my application, automatically share existing application and another application to him. I know I can use share application(User.email) but it will only share current application. Can I somehow share another application to that user?
Re Creating a new button
Can any one tell me how to create a new button "Save & Followup Task" for a new form that is created using Zoho Creator.
Further tips on editing existing records.
Hi, I'm trying to create a simple application where a user can see a list of records that need editing, choose one, and then edit its data in a friendly form interface. For instance, I have 20 books already entered as records, but no author, description or date for them. I'd like users to be able to see the list of books, choose one, then enter/edit and submit the information. Ruben's been really helpful suggesting this:https://help.creator.zoho.com/Editing-Records-via-Record-ID.html Now I think I'm
Invalid Email while submitting the form
One of my form give error in the log "invalid email" https://creator.zoho.com/piju2111/penta-crm-11/form-perma/Company_Introduction/ Rather it was working perfectly before this. I haven't disturb any script. Note: I have give edit access to support. Thanks
changing field units ($ or %) based on user input
I have a field that has a pick list that contains "Growth rate" and "Cash Flow". I then have 3 number input fields, Min, Target, and Max. How can I change the units for these 3 fields based on how the user chooses growth rate or Cash flow?
Stateless Forms, Need TA Quickly, Willing to pay via paypal
I am working with a client DB and need to track various level of information over time. The central nucleus is the client, so all information will loop back to them. Different forms will be used at different times to enter information about the client (i.e. a patient, and all records relating to each visit will contain different fields, but we want to be able to bring up a view that has the client and shows all information about the client pulled from different fields.) I know this is possible
Problem with sending email to list out of Scheduler
I can't seem to get an email sent to multiple addresses out of the Scheduler. It works fine for one address, but when my variable uses .toString() nothing sends? Mac addresses = (Marketing_Reps[Status = "active"].Email).getall(); sendmail [ from:zoho.adminuserid to:addresses.toString()
Maximum Number of Fields
I would like to know the maximum number of fields that the creator zoho accepted in a questionnaire?
Lookup field not working
Hi, I've got a couple forms, I work with a work and travel placement company. One with Candidate info; their name, email, contact info. The other with their work placement preferences. The problem is that when I use the lookup filed to the Candidate Names in the Placement info form, every time I select a few of the names the list sometimes updates with the wring name. Usually the record just before it with the same first name. When I try to edit, I select the right record but when I save it goes
Can't properly format an If-Then statement
This is probably an easy one: (sorry) I have a database in which I want to first ask the respondent what continent they are from, for example "North America". I have a drop-down field with 3 choices for continents. If they choose "North America" from the drop down choice list, then the second field, "countries within north America" would then display. I can't seem to understand how to format the If/Then statement to get this to work. I have clicked on "Actions on User Input" for the first field.
Some tips/help on editing existing records in forms needed
Hi, I'm trying to create a simple application where a user can see a list of records that need editing, choose one, and then edit its data in a friendly form interface. For instance, I have 20 books already entered as records, but no author, description or date for them. I'd like users to be able to see the list of books, choose one, then enter/edit and submit the information. The edit option from the sheet view doesn't really work as, as far as I can see, it's essentially unstyled and my users
Insert record / add record Specify Variable (Optional) -- double check its usage
Hi just wanted to double check For Insert record / add record the Specify Variable (Optional) parameter is only used to return the inserted record ID Is this correct ? please confirm Can it return anything else ? Only thing i could glean was from this post ================ https://help.zoho.com/portal/en/community/topic/get-input-id-on-stateless-form-submission record_id = insert into contact_us [ Added_User = zoho.loginuser Address = input.Address Date_1 = input.Date_1 Email = input.Email Name
ZC API statements - Not application owner issue
I have come across an issue several times in the last few weeks. If my client is allows me to develop an application in his workspace I cannot add API commands (zoho.crm.updateRecord etc) to the ZC app as I am not the application owner. This only becomes an issue when the client will not let me use his ZC credentials to build the application as they are his Google Apps credentials. (It doesn't happen every time either. Sometimes I have added the statement as a comment and asked the owner to 'un-comment'
Fetch Latest Record
Hello, I have two forms, FA and FB FB needs to access the latest record from FA's table FA has an input field FA-NewRec set to "New" FB finds latest record like so.......... FetchLatestRec = FA[FA-NewRec ="New"] When found FA-NewRec is set to "Old" etc "If two or more users access the form at the same time, the issue reported may arise, as the fetching criteria is not unique to the task. " Thanks
Problem with importing ds file and duplicate the application
I took the Application(which is shared ) back up as .ds file and i login as a another user and i imported the .ds file then i am getting the error "Problem encountered while creating the application api functions can be created only by application owner" And if i create a duplicate of that application some functionality is missing . Can Any one help me out Thank you
Need to know how to get dynamic fields on a form?
I am creating an app with zoho creator . In one of my form in creator, there are 25 fields !!!! i want to display different fields for the choice i made from in one field. Can you please tell me as soon as possible .
Create a Function to Call a Form
I'm trying to create a function to call a form and embed in a view so that the user can click on the view (limited columns) to call the form and see all fields in a pop-up. I'm pretty sure this is possible but I can't seem to figure it out. How do I create this function? I don't quite understand how functions and arguments work as there is little information that can help a beginner understand the creation of functions in the help section. Dan
iFrame issues againg with https and http
Dear Danny and all at ZOHO, I tried to follow up directions to make creator use HTTP protocol instead of HTTPS. See my comments at: https://help.zoho.com/portal/en/community/topic/iframe-issues#2266000002661725 But I discovered that zoho has removed those options from zoho creator all together. So it seems that there is no way anymory to force zoho creator to go into http mode. What I discovered further is, that if my creator application starts with a creator-page loaded in an iFrame, I can load
Customized views for a "desired_item_number" in a relational database
I have a relational database in Zoho, with many related forms (tables). Link between these tables are created with import data lookup field. So as a result, for all tables, the first column is "item_number" Always there is an record for each item in the parent table but not always for a child table (because there are no entries for some items in child tables). I created separate views for all tables. How can I force all views to show just the records for a variable "desired_item_number" ? Until
Can't access Applications
Hi, I have been trying to get hold of Zoho support for the last 2 days but not getting any replies, so hopefully this forum can help. I am unable to access any of my applications in Zoho Creator ever since using the Google apps version to integrate with Gmail. Since I installed the app every-time i go to log in to my creator account I am presented with the Shared Apps Screen, but nothing to access any of my Applications. ther's' no menus or anything to get back to my applications. None of my applications are
Setting Initial value in Zoho Creator
I found that there is no Initial value in image field, how can I predefine the image url, when everytime user save a record?
Custom schedules with attached files are no longer executed
Three days ago the custom schedules which are meant to send attached exported views in XLS format were no longer executed. In my account at https://creator.zoho.com/showScheduleUsageLog.do in last 3 days there is shown that the schedules failed and the reason is... Error occured please contact application owner I meet the same situation in other 2 accounts belonging to a client. Does someone have a similar problem? Regards, George
Zoho Creator Search Engine for Applications
Recently I've been working on Zoho Creator applications that require search tools. I've been using the stateless form in conjunction with HTML view approach; however, the scripting involved is a lot of work and can get very complex as more search fields are added. I've noticed that the List View has a pretty good built-in search capability. It would be great to be able to use this search feature separately from the List View within forms. If it is not possible, it would be great for Zoho Creator
Scheduler won't work
Hi, Can someone help me figure out why this script apparently fails to work with scheduler? The script is valid if executed elsewhere on the site (for instance if I stick it in the "on user input" of a field somewhere). I don't get any errors when putting the script into scheduler; it just doesn't seem to do anything when the scheduled time comes and passes (I have waited 15+ minutes). Frankly, I find the scheduler fails to work with anything of any complexity. Will it not work with variables or
Export Form
I created a form using the Zoho Creator. I would like to export the form for use on my website. Just being able to export or copy the html code would be fine. Is this possible? If it is, how do I do it?
How do I restrict a user from exporting a view?
How do I restrict a user from exporting or printing a view?
Next Page