Values derived by dates
Good Afternoon, I wonder if someone could give their advice on how to achieve the following. I wish to create a document 'due date' field derived from 3 other fields which are:- 1) Document date e.g. 19/09/11 2) Number of days e.g. 30 3) Terms e.g. from document date or from end of month. So based on a document date of 19/09/11 some of the options could be 1) Number of days 10, terms from document date would result in 29/09/11 2) Number of days 10, terms from end of month would result in 10/10/11
Sharing applications forms/view to a group
In order to make management of access to an application easier I am trying to use the Sharing to Groups functionality. Whilst is looks simple to use, it does not appear to wrk for me. I have added a user to a group and then shared a view to that group. However, that user is not able to see the view. What have I done wrong?
Need a developer for sales/workflow solution
We have started a sales/workflow solution and concluded we don't have resources in-house to complete.
Executing scripts in a subform that update fields in ANOTHER form
Hi All, I'm working on an app I created a while back that tracked orders for multiple clients, and updated client budgets each time an order was placed. The way I had orders set up was two forms- Orders, which contained an order as a whole, and Order_Lines, which then broke an order into lines for each client and charged the client accordingly. This was a little convoluted, so I started trying to use the subforms feature today but find I need to make several modifications to my script in order to
"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
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?
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
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
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
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
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?
More zoho._____ variables for easy debugging && full app source search
1. more zoho.____ variables and perhaps an assert method I just built a simple logging system for debugging. In my functions I just use something like... log("functionName", "line #", "messages") If we had zoho.funcName, zoho.line_number, zoho.funcId, zoho.formId, etc we could build some pretty awesome logging, documentation systems. I could create links straight to the form edit view! I'm trying to use unit tests as much as I can for testing functionality so using info messages for debugging is
API development
I have an account with ChannelAdvisor where daily there are some orders generated: I have developed some Zoho Creator forms to hold the data from these orders, manually. Now I am looking to use ChannelAdvisor API to let Zoho Creator automatically grab orders from ChannelAdvisor: http://ssc.channeladvisor.com/howto/sales-and-fulfillment/fulfillment/downloading-orders Look in "Developer Network APIs". Can you guys help develop it?
Import and export the bulk data
Hi I created a duplicate application .i am able to duplicate the structure and not data .You people replied that there is a option to import and export the table data. But I have so many database tables in my application . Now i am able to import and export single table data at a time. can i have the option to importing and exporting the bulk data(like more than 10 tables data at a time ) ?. Please Help me out Thank you
Sharing an application
If I share an application in the developer zone to a client "Without Source" and then later i do an update to the application and want my client to have access to the source is this possible to change? When they more to the updated application can they have access to the source on the updated version? What I want is the client to not be able to view the source but i do want them to be able to create new views on their own. Would this be possible when publishing without source? If not, can i do what
How to get database tables data with duplicate application
Hi, I duplicated my application .In The Duplicate application i am unable to get the database tables data .I need the total database data in to my duplicate application . Can any one help me out Thank You
Bulk Editing a Check Box 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
Re need need your help for how use ZC API to run pic data of Flickr
Hi Could you please giveme a sample code how use ZC API to run pic data of Flickr.. Thanks Stanley Guo
Auto mis-direction in Internet Explorer - link to form
I have a public view embedded on our website. There are links on the view that take people to a form. http://www.gormanfarm.org/volunteer.shtml When the links are clicked in Firefox or Chrome, they work as expected. When the links are clicked in IE, they re-direct to the wrong form. If you watch the navigation bar, you will see the correct URL for a second, and then it redirects. This is a huge issue for us. People cannot register interest as they are supposed to. I tried these issues both logged
Filtered dropdown
I am creating an app with the form name Salesman Data . Now in this i have different fields . One of them is Salesman name and other is salesman id ,etc . the salesman name is looked up by new form !!!if salesman name is not found !!! it can be add !!! now what i want to do is when someone want to add salesman id !!! it should be auto generated and the same id be used the next time the some user use tat salesman id. Please help me asap
Many-to-many relationships with large forms
I'm trying to find the best approach to creating many-to-many relationships between a series of forms (tables) that have hundreds of entries in them but generally only a few are selected. For example, - a farm will sell their produce to one or more restaurants, - a farm will sell their produce to one or more distributors, - a farm may be a member of a market group, - a distributor will sell to one or more restaurants, - a restaurant buys from zero or more farms, - a restaurant buys from zero or more
Duplicate AND Bulk Edit at the same time
I often need to add records that are exactly the same as others but have 1 or 2 fields that are different. Currently, I select each field and duplicate. I then select each duplicated field and bulk edit the different fields. Unfortunately, because some of my forms can't have duplicates, I can't get past the first step in this process. Can run scripts off of duplications? For instance, if I duplicated 20 records in a form that didn't allow duplicate records, it would ask me to change a field to make
Suggestions for bulk edit of multiselect field?
Hi everyone, I only started using Zoho yesterday, and I love it! I hope someone can help me with this (or suggest something else I could do instead). I'm making a marketing campaign tracker. So I have a list of customer and a list of campaigns (several customers are linked to each campaign). The only way I can think to do this is by using a multiselect field (or checkboxes). That's fine if I'm adding customers to a campaign one-by-one, but if I want to add a whole heap of customers to a campaign
User Email Activation
Hi! Wondered if you could help me - I added a user to my list, and it didn't send a activation email. The junk/spam folder has been checked. Thanks for your help! :)
Best practices for Zoho Creator migrations
I will be working on a Zoho Creator application that was previously developed by another group. I have a series of new enhancements that will need to be incorporated in the application. Part of my challenge is determining the most effective way to make changes to the existing application. There does not appear to be any sort of migration tool and/or best practices around change management. I have thought through a couple scenarios: - backup/restore the production application, make changes to the
Restrict user access to certain records
I'd like to use Zoho Creator as a database to keep track of several client details including notes from client contacts. We have several consultants spread geographically and a staff at the main office that would be using the database. Is there a way for the consultants to see only their records and the staff to see all the records? I've seen solutions on these forums where the consultant can only see the records they create but that won't work for us because the main office staff will also be
Build a drop down list
Hi, I want to build a form that has a drop down list of items e.g. grocery bought. How can I make it into such a way that if a new item has been bought and is not in the list previously, it allows the user to key in manually and be added into the drop down list?
changed and saved code not actually run in Deluge
I've changed and saved code in Deluge, but when I run it, it runs the old code. However, when I then look at the code I saved, it still displays the new code, even though it runs the old code. This lag takes a few minutes, and then suddenly without any input, it runs the new code. odd...
postUrl problem - XML beginner
Hi all, I'm a complete noob with XML, HTTP Post & the like. I have a Saasu account and I'm trying to send client details from my ZC database to Saasu. I'm getting a response code 200 but it's not working, ie no record is created in the database. Here's the response code the saasu server is returning: {responseCode=200, responseText=<?xml version="1.0" encoding="utf-8"?> <tasksResponse />} The Saasu team have had a go using the output string I provided them (FinalDest below) and they were successful
Next Page