How to Feth HTML Data with Xpath?
I would like to retrieve data from html pages using xpath. With Google Spreadsheets this is possible using this kind of code: =importXML("http://www.google.com/search?q=live", "//a[@class='l']/@href") The problem with Google's service is their limitation of external calls. I've read Zoho's documentation about retrieving external data, however I don't quite get this. It looks like one can only fetch xml files, not html pages? Is there a solution to this? If it's not so easy, I'm willing to pay a bit
I can't add any record. My limit is zero
Hi I can't add any record. My limit is zero. I can add upto 1000 records using free account right? Thanks
Semicolon Bug in Grid View Mode
Hello, I would like to report a problem / bug. When a user fill out a form to insert a semicolon in some field, no problems. But when I view this form in grid mode, and try to update it, the semicolon induces the system to interpret it as a jump to the next field, so that, in theory, data filling in "move" a field forward. For example, I have a form fields A, B and C. The user fills the field A = "aaaaaa", B = "bbbbbb;" and C = "ccccc", and C required field. Verify that B has the ";" semicolon, and
Load forms conditionally?
Is there a way to load a form from a script other than the openUrl? I want to redirect the user to another form where they enter default data when they first start using the application, but once it is populated they no longer need to see that form. I wish I had more time to read every posting, there is a wealth of ideas and information in these forums. Thank, Ken
data dictionary problem
My application was working fine and then I started to get these errors. I deleted all the data and even tried recreating some of the fields, but I can't seem to get it fixed. What happened? 1 . [t_547125000000097967] Exception occured while setting value in PreparedStatement for the Column [aborted_547125000000123120] Check whether the datatype for this column is given as specified in the data-dictionary .[t_547125000000097967] Exception occured while setting value in PreparedStatement for the Column
form disappeared
Jeez. Form disappeared. Can't access it. Spreadsheet still there. Help!
How to Populate Dropdown with Selected Values from Multiselect field
I am trying to use the selected values in a multiselect field in one form to populate the dropdown values in another form when the records match. 3 forms in all are linked. For example, if I have a multiselect field called "MM" in a form called "FormA" and a dropdown field (called "DD") in a form called "FormC". FormB contains a link field called SubID. FormA has fields: ID MS FormB has fields: ID SubID FormC has fields: SubID DD So if I select a SubID in FormC I find the record in FormB where
Moving an application
How do you move an application created in your personal workspace to another workspace?
User Account Info Help
How do I allow other users to edit my applications? I have other users set as developers in my account but they do not get the "Edit this application" option when they are viewing my applications.
Zoho Form and Trac Wiki
Is it possible to embed a zoho form within the trac wiki system? Joss
How to have a field (with number entered in it, e.g. 12), produce a corresponding number of fields for entry.
I am working on building an educational assessment tool for teachers to share data. I can't seem to figure out a simple way to do what I want, so I thought I would ask. If the user enters "12" when prompted for the number of students in his class, I want an action that generates 12 blank fields for student names. I hope someone can help
Specific Email Check Validation
I only need to accept form entries from certain email addresses. For example only people who have "@usc.edu" in their email address needs to be able to submit my form. If they do not have "@usc.edu" in their email address they need to see an invalid email address message. Does anyone know how to do this? Thank you in advance for your help.
Linking Zoho accounts/files
how do I link Zoho Creator files with Zoho project accounts
Access ZOHO Creator Application through ZOHO CRM
We are using ZOHO CRM enterprise edition in our company and we have around 50 users. I am the ZOHO CRM administrator. Basically, I want to create an application in Zoho Creator and include it is a part of the ZOHO CRM using the Web Tabs. My question is ... will the other users of ZOHO CRM be able to access this application. Regards, Renuka Chillal RIM : 09320 551753
Deluge help: adding to a list in another form
I'm trying to write a Deluge script that will add a name entered in one form (interview form) to the relevant address records in another form. Since the address records may have more than one name associated with them, I need to be able to add a new name to that field without compromising the old ones. In addition, I need to be able to remove the name from the address record just by removing it in the interview form. So far I have gotten the addition and removal to work when the addresses associated
Function Insert into
Hi, I have script which insert the data in to different form when condition happened, from last two days it stop working, i have gone through the script, it's fine no change has been done. Please do the needful. I have already allow access to support. my form name to_do_form (application penta_crm_10). Script start from line no 115 to 141. Comment // Auto Cash Entry in Finance Thanks.
Google Map integration in HTML View
Does anybody have a sample app using Google Map in HTML View ? I'd like to show a customer or a list of customers on the map. Thanks, Pascal
How can assign a permission to users for a Form or View?
Hi Harsha How can assign a permission to users for a Form or View? it's mean is user can't see the form or view if admin not assign the permission. but I knew that Office Sharepoint can do that even assign a permission to a record.it's future very usefull. Thanks! Stanley
Allowing new members to add themselves to the database?
I want to allow people to add themselves to my database from a web page. I realize I need to make the application public. However I don't want anyone to be able to read the database, and I don't want them to have to fill out all the fields. How do I restrict reading and limit the fields offered (through a view?). -- Kristy Dyer
Can not Share Views - Error: You are not allowed to view / edit the script.
When I edit views & forms, there is no 'share' tab - I am logged in as admin user. If I click on 'View Definition' for the view, I get the error: You are not allowed to view / edit the script. I finally found the 'share' tab so that I could assign non-admin user permissions to the custom view I created. However, whenever I click on the share tab it takes me to the 'Add Request Via Email' form & the share tab goes away. Thanks! -Randy
Is there a way to hide user input with dots or stars?
Is there a way to hide user input with dots or stars?
[ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
I tried to view the form via "form definition" to look at the code. But I got this: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' It's in my app movies*******
Is there a way to hide user input with dots or stars?
Is there a way to hide user input with dots or stars?
Linked To Asset: null - Can't link Requests to Assets
When I create a Request, I assign it an Asset. But when I view the request it shows: Linked To Asset: null When I edit the Request, I see that the Asset is assigned. I don't get it. When I change the Request so that no Asset is assigned, the main view of the request shows: Linked To Asset: -None How can I get Requests linked to Assets? Thanks. -Randy
Export of blobs
I have just created a test-db with a file-upload field. How can i export/mass download uploaded files (blobs) from a creator db?
URL Link to change the value of a decision box in a specific record
Hello my Zoho-ites, I've been reading the user guide section, but cannot solve the issue I'm trying to make. I would like to provide a link to a decision box to change the value from false to true by clicking on it. Does anyone know how? I don't want the user to view the record. Thanks for any help! Joe
Saving Lookup field data into new lists.
Hello everybody, I had a question. I have placed a lookup field in my form that has a list of 2000+ players, I wanted to be able to select a couple players from the lookup field then save them to a team record. For example... I select 7 players from the lookup field, save them into a list, name the list, then save it. I would also like to make another form that looks up the list of new teams i made from the prior form, a user be able to select a team, then edit the data accordingly. Like adding a
Rebranding on an Application by Application Basis vs. Subscription
I would like the ability to rebrand applications just like we can now with the added ability to do it on an application by application basis. If I develop an application for use by XYZ company, for example, they might want their logo and URLs displayed versus only being able to use my subscription based logo and URLs, etc. If I had 10 applications, I might have 10 different logos, for example. It would be greatly appreciated if you could make this enhancement. Sincerely, Russell S. Brown
Zoho Mail add on for Zoho Creator
Hi We have just developed a CRM in zoho creator. We want this CRM to manage emails like the zoho mail add on does in zoho crm, can this be done, if so how? It must be possible if you guys have been able to integrate google apps mail in your zoho creator helpdesk
Related records
I wanted to create a view, with the related records of a record showing on the same page.... Which is to say, in a one-to-many relationship, I want the main records and all the related foreign table records showing on the same page.... is this available now?
Sharing Application Doesn't Work Properly
I have an application (INZDB2) that I have shared with one of the people in my organization (see graphic below): The user logs in and can see the application as being shared (see below): But when trying to access the application, the user receives a message saying that they are not allowed to access the application (see below): I have shared access/edit to support for this application. Thanks, Leo Saumure
Does Zoho Creator support Regular Expressions?
I need to parse an XML feed, but I need to use regular expressions to filter out the data I need from the XML, as it is spread throughout strings. I need to apply regex in conditional statements to get exactly the data I need out of the strings. Does Zoho Creator support Regular Expressions? If not, how might I get precise patterns of data out of a string in XML? Thanks.
Unable to make form public
I am trying to make my form public but when I'm clicking 'click here to request for public access' it's not working. What to do now?
URL param: #form vs. form-embed
I have a stateless form. It has a hidden field to accept a URL parameter. One URL works and the other does not. Works: http://creator.zoho.com/ensobase/home/#Form:Task_Manager?DealPreLoadHidden=Deal-Name Does NOT work: http://creator.zoho.com/ensobase/home/form-embed/Task_Manager?DealPreLoadHidden=Deal-Name I need to use the embedded form because I cannot have the application chrome. Maybe there is another way. What am I doing wrong? Thanks, Tony
Error: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Hi, I have sent this message once before, but cannot see a record of it, so I apologise if you have received it multiple times. I am receiving the following message whenever I try to access the scripts tab in Creator: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' The error occurs only with one of my applications, and I think it is related to a problem with a view "Send midday messages" (not "Send Mid Day Messages"). I accidentally removed all columns from the view, except for a related
"For Each", "Sum" and then "Insert into" issues.
Hello All, Form A = Form with Data that I want to retrieve from. //Form A will have multiple records that are indexed by "Po_No" Form B = Form that I want to pull data into. //Form B will required the muliple records in Form A to be summed with the result being inserted into a record in Form B. I am trying to use "for each r" to pull record specific data from Form A, sum specific fields, and take the total sum data and insert into a field within a new record. I will need to repeat the "for
Forms and URL validation
Does anyone know how to validate the URL entered in a field on a form? I guess really to check for 404 errors? Thanks, Me
Multiselect lookup.
I would like to create a record for each item of the multiselect (lookup field) list which are selected by the user. Because when we select few items in the multiselect lookup field, those item are registered in one record. How can I do that??
training on "creator"
Heard about Zoho from various sources and am particularly interested in "CREATOR" as I run an SME on a bespoke database written 6 years ago. Can anyone point me in the direction of TRAINING ? Doesn't seem to be an extensive help function to fall back on. Are there training courses ? training websites ?
postUrl needs to support XML REST Services
I have an urgent need to interface an application in ZOHO Creator to an online bookkeeping system which supports REST based web services. I was a little surprised to see that the postUrl function only supports maps (key->value) pairs and not the ability to specify an XML body in the POST request. When is this going to be changed? Is there any chance that we can have a special key "data" that simply uses the value in the body. This would allow for backward compatibility in the function call and at
Next Page