XML feed
I need to develop a Zoho Creator script to import data from an XML feed into forms -- could be multiple forms with relationship set up between them. I need to let the script automatically import at intervals, say every 12 hours. Is this possible?
Zoho Creator Help Desk cannot delete: you are not allowed to view / edit the script
I had installed the application for trial. Finally, I found no interest and want to delete, but I cannot..... "you are not allowed to view / edit the script" HELP!!!
Formula field help
I have a task form to assign specific tasks to individuals to work on them. I have "Estimated Hours", "Actual Hours" and "Remaining Hours" which is a formula (Estimated_Hours-Actual_Hours). I also have a Project Length lookup field that's a in which you choose how many weeks/months you have to complete the project and it will then formulate the Weekly Hours =(Estimated_Hours / Project_Length).round(2) which will break down how many hours a week you need to devote to the project to finish it.
How to display data in a form field?
Hello I want to display some data in a single field when i choose some option in a dropdown o multiselect field, or when i put some numeric values in a number field i want to display the sum total of that values in another numeric or currency field without going to the view from that form. Thanks for your time and patience Greetings from Colombia
If statement not working
For a Task form I've built, I want to be able to put in the Estimated_Hours of the project, the Actual_Hours of the project and how many hours a week I want to work on a project, Weekly_Hours. If the (Estimated_Hours-Actual_Hours) is less than the Weekly_Hours originally submitted, I want the Weekly_Hours to show the (Estimated_Hours-Actual_Hours) to have a better idea of how many hours per week you have committed to a project. For example, I'm working on project X and at the beginning of the project
API Add Record throws error 2900 if there is no fieldname in form matching submitted key value.
This is also an active ticket with support, but I figured I would look to the community for insight too. We use sendgrid as an external email provider. I wanted to send an email with unique record id in the header from zoho to sendgrid's web api (which then sends the email). The results from that send attempt would then be posted from sendgrid's event api back to zoho (to record bounces, unsubscribes etc). I was able to do all this successfully. But I hit a snag. One of the fields that sendgrid's
Set criteria not working
For a dynamic picklist I want to specify the criteria to show "Active" and "Maintenance" but not "Completed." I've tried this multiple ways and none of it will work though it accepts the command. I've tried: Project_Status = "Active" Project_Status == "Active" Project_Status != "Completed" I've even tried creating a decision box with "Active" and even that wouldn't work. To test it I've even tried what has worked in other picklist criteria and even that isn't working. Is this some sort of bug?
how to get the name of an unknown XML element?
For example, say the XML data is: <CustomerID>12345</CustomerID> <Name>Bob Smith</Name> <Phone>99999</Phone> But I don't know the exact names of the elements in advance. How can I extract just the name of each element - i.e. "CustomerID", etc - from the XML? Anton
Deluge Scripting textbooks
I am looking for Deluge Scripting textbooks. Can you help in recommending some good ones?
Importing data in views is not updated in zoho reports.
I developed an application and upload my data on creator views. In my application there are different forms. From them only 2 views data is not been updated to the zoho reports, others are able to get updated.
HTML View image only seen by admin
I have an image on my home page HTML View that uses this code: <img src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/1266858680427_HydeParkLogo.gif&sharedBy=<%=zoho.loginuser%>&appLinkName=hyde-park-data-center&viewLinkName=Images_View'> When logged in as admin it shows, but not when I'm logged in under my test user account. Any suggestions? Thanks, Bruce
Fetch Records to update dropdown box
Hi, I am currently trying to put a FetchRecords script in whereby a dropdown is updated with data from another table. The syntax I have is as follows: get_available_products = Available_Products [Product == input.Product]; input.Unit_Trade = get_available_products.Unit_Trade; input.Unit_Cost = get_available_products.Unit_Cost; input.VAT_Class = get_available_products.VAT_Class; The first two fields are normal single line fields and update fine. The VAT Class is a dropdown but does not seem to
ZOHO Creator & Payment Gateway Integration, is this possible?
I am in the middle of project and requirement is Form submisison created usin ZOHO creator result into payment process system, Is this possible? Please help
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
Next Page