ZOHO Creator
It's too bad that I can't use an icon for a field; ie. a paperclip to indicate an attachment and a yellow note icon to indicate a note. betty
Formula Field Update Frequency
My app is designed for elderly people. I need a formula field displaying how many months have passed since the record has been updated. But my formula will always display CERO because the record is updated everytime I try to update the formula field by giving the order r.formulafield=r.formulafield; ¿What is the "updating frequency" of the formula field ?
Views can't display data of two identical subforms
Hi, I need to use two subforms in a same parent Form. Those two subforms use the same form (there's just one column displayed alternatively [Stock-in and stock-out for example]) All works fine, except in the views. To display subform data : it's displayed in one column and is concatenated (like this : SubFormData1SubFormData2), instead of two separated columns (SubFormData1 | SubFormData2). Even in XLS Export, I use exportDisplayData=false to have data in separate tabs, but it creates only one tab,
downloadable scripting instruction manual
Is there a downloadable version of the scripting language? It is extremely difficult to determine an exact question that asks precisely what is being researched. For example, I have designed a form that has a dropdown with data from another form. I want it to display the dropdown information, but I also want other fields to populate based on the data selected from the dropdown box. This should not be a difficult procedure, but finding the answer in the knowledge base is difficult
How to update a boolean field via XML RPC API
Hello, how would I pass a boolean value to the XML RPC API, if I want to update a boolean field (Decision box)? When I use the following XML <ZohoCreator> <applicationlist> <application name='TestApp'> <formlist> <form name='TestForm'> <update> <criteria> <field name='ID' compOperator='Equals' value='519261000000601003'></field> <reloperator>AND</reloperator>
Copy Name from form to sub form
I've read through all the topics, but I cannot get it to work. Seems to be simple. Main form is named "Contacts", sub-form is "Invoice". I just want the field "company" to populate into the sub-form. on load on "Inventory" Input.company = company.company Help please!
Link PostGreSQL
Hello, Is it possible to link a PostGreSQL database to forms etc written with Zoho Creator? Thanks, Jen.
Which plan should I get to start a business?
Hello, I plan to develop a baseline app and sell. Assuming each customer has 5 users, and there are 2 customers, A and B. Does that mean I'll duplicate my baseline app twice for them? If customer C requires customization, I'll duplicate baseline app and customize for them? So now I have 4 separate apps right? I would like to bill customer separately, and just give them user IDs and passwords to use the system. In other words, I'll be meeting prospects face to face or through phone to sell my app.
how to round robin like functinality in leads
leads gets a number from 1-6 and after it again number starts from 1 and end on 6.
Print Views
It would be helpful to be able to select a record from List View and print the detail of that record in a nice format. Right now, I have to open it for editing, highlight the fields and then print selection. How about a print button on the record summary screen? A print button on every view that would popup a version formated for printing would be another nice option. I tried limiting the summary view to just one record, but it only works if that is the default view.
Single record view
How can I create a single record view in Creator that shows the fields of only 1 record? Thanks!
Trying to wright to Subform field inside a "for x in" loop
In the code below, the "Notes" field is a Subform field I'm trying to wright to when an auto reminder email goes out. I can't get the syntax correct to access the Subform field. What am I doing wrong? The Main form field name is "Notes" and the Subform field name it wrights to is "Notes" I've tried y.Notes.Notes, row.Notes, y.row.Notes ******************** for each y in test_emails[Received] { y.Notes = zoho.currentdate + " Auto DEL notice"; // Trying to create an entry in Subform field "Notes"
Schedules Attach Summary View as PDF
Is it possible to attach a summary view to an email in the Schedules section? Currently it convert the Summary view to a regular list view. Herb Wexler
can not access the application in Zoho creator (account stanleyguo) from China
Hi I can not access the application in Zoho creator (account stanleyguo) from China, but be able to access Zoho Home,also can access creator application through Special VPN software, I do not know what happened has been a smooth access to the creator application, can not access from yesterday. Have any special status? Waiting your help and thanks Stanley Guo 2012-3-12
Shared App Not Displaying
I'm trying out the free version of Zoho Creator but I'm having big problems when I come to Share my app. I add a user, share the app with them, but when they go to the weblink all they see is two nested navigation bars and no content (screen shot attached). Makes no difference if they are set to be Users or Developers. Any and all help appreciated please! :) G
Cannot create invoice through a form in Zoho Creator
Hello, I have created a form in Zoho Creator and I am trying to ask Zoho Invoice to create an Invoice. I am using the script code below (which I found in your help page:https://help.creator.zoho.com/create-zoho-invoice.html input.Invoice_Detail_Status = zoho.invoice.createinvoice({ "CustomerName" : input.Customer_Name, "ItemName" : input.Item_Name, "ItemRate" : input.Item_Rate, "Quantity" : input.Quantity }); I get the following error when I am trying to save the script:Error in statement at line
Strip out file attachments from database, leaving core data intact
Hi Zoho peeps! I know that you are download file attachments with the App you developed which works really well. However, when these files are downloaded, I want to be able to delete them from the database without having to go into each record one by one and do this. This will allow me to keep my records on and create an archive situation. Can this be done? Dave.
Reset form On Success
I am using a form in an iframe to create a Facebook tab. To do that I am using an Wordpress plugin, Facebook Tabs. This means I effectively have an iframe inside an iframe. This is OK, except the form will not redirect On Success. Is there a way in the script to at least clear/reset the form? I can cope with the redirect failing, but I do need to empty the form. Adam
Action button windows with forms loading with large white space on the right
This happens quite alot with deferent forms I'm opening for filling out. My form is jammed on the left half and white space on the right half. If I go into the delveloper tools elements inspector of my browser, I find the Table containing my two column form <td> tags, but also this third <td> tag. <td elname="zc-formTableFix" style="vertical-align:top;width:99%;"> </td> If I remove this tag using the browsers developer tools window, the form than looks correct. Question, Why is Creater adding
Embedded reports not scaling correctly in Dreamweaver created site
An interesting one this one. I built a site with ten embedded Zoho reports. This was a very simple site and worked just fine. I adjusted the iFrames to 600 x 500 and the ZoHo content scaled perfectly. I then decided to do a better job based on CSS using Dreamweaver CS 5.5 (don't ask) and the reports did not NOT then scale properly and were elongated only showing about a quarter of the bar charts in the vertical direction. Actually it was very browser dependent - the only common thing was that no
Fetch record using checkboxes (Multiple Values)
Currently I have a form i.e (Finance Entry) in which we make Payment or Receipt entries. One of my another form having the entries of our Customer Outstanding. Form name: Payment Outstanding (eMail_Tool). In [finance entry form] I have to fetch the value from [Payment Outstanding form], I am able to do so using "Lookup - dropdown" (single entry) this is script I using in "Lookup - Dropdown" [Update_PO] // Variable FPO = eMail_Tool [Ticket_No == input.Update_PO]; // if (input.Customer_Name ==
Appending items in Lookup Field which display value is different than its value
Hi, In one form, we have a lookup field looking for ID but, displaying the description. Then, when we try to programmatically append a new item (we have also inserted the new item in the corresponding form, programmatically too), the only way is setting the new ID but then it displays the ID, not the description. It looks horrible! Is there a right way for appending the item correctly and displaying the description (the ui.append() function has only one parameter, for the value). Thank you very much,
Bulk Edit-Bug or Feature
I'm not sure if this is a bug or a feature. I tried to do a bulk edit on a field that is shown in the view but is hidden on the form. There was no error message but the value did not change. When I removed the hide statement from On Edit->On Load I was able to bulk edit the field. Thanks Herb Wexler
Simply adding an image into my form to be displayed when the form is being filled out...
I just simply want to add and image to my form to be displayed when the user is filling out data for reference reasons. Through research it appears that this can be accomplished using the Notes filed; but I am not understanding how to get the image I want to use in an appropriate area so that the URL tags in the Notes field can reference and access it. Does my image need to be uploaded to Zoho somewhere so that it can be used in the NOtes field? Pardon my ignorance; but I thought it should be rather
Photo upload
Hi, I am setting up a database/online form for a project called Muddy Water Watch in Zoho Creator. I have enabled a field to upload photos so that the volunteers can send in their photos of sedimentation pollution when they enter a Site Report. I can view my test photos in the database, but I can't view the photos when I export the data and they are not attached to the automatic email notification even though I have enabled User Submitted Data. Everything else comes in the email, but not the photos.
Search and Auto-Complete in bi-directional lookup fields
Hi ZC, I have a lookup field with bi-directional links (both multiselect). 'Search and Auto-Complete' is enabled (Form A). On the other side of the lookup field (Form B), I want to enable 'Search and Auto-Complete' too ; but then, in the original field (Form A) the 'Search and Auto-Complete' has been automatically switched to disabled. I did the reverse, and it's the same : actually 'Search and Auto-Complete' is possible in only one side. Other remark about the 'Search and Auto-Complete' with checkbox
What is the differenc "Creator" & "Support"
My Quick thoughts are that the Support module is newer and the advanced Creator? Is Support replacing Creator? Where is the comparison?
Dynamically Created List Bug
Here's a picture of a test form's checkbox field with one item: In the form's code, I clear the checkbox and dynamically add items: clear ITEMS; for each r in LIST { ITEMS:ui.add(r.ITEM); } In live mode, it looks just fine. So I select an item and submit the form: Back in edit mode, the item I selected is now appearing! Somehow, the form's definition code was changed. This also happens for anonymous users submitting data with the form. I view this not only as a bug, but a security issue. For
Zoho App Hosting
After creating the online database can I have it hosted elsewhere in other webhosts?
Lookup field for corresponding value?
Hello - This is novice question so please bear with me. I'm looking to replicate vlookup function in Excel. I've read several related posts on the forum, but still do not understand. Example: * Two forms - Department and Employees. The Employee form contains fields such as Employee Name, Phone Number, Email, etc. * Department form contains lookup field that enables user to select Employee Name (employee_name) from Employee form. * I would like to include another field in Department form which would
Can forms/views be hidden from the navigation?
I have certain forms and views that are embedded inside an HTML View. I want the user to access only the HTML view to access the underlying forms and views (embedded in that HTML view). How can I take the underlying forms and views off the navigation so that user only sees the link to the HTML container view in the left navigation pane and never sees the direct link in the left navigation to the embedded forms and views. Thanks in advance.
Deleting entry with a field, possible?
Hello, I have a barcode scanner and I'm creating some entries in the database with it. Is it possible to make a field where you can delete the original entry when you enter the same barcode. For example I have "7012345" entry in the database. And i go to "Remove barcode" field and write the same "7012345" number and it deletes the entry from the database, so I don't have to go and select the "7012345" entry and click delete. Thanks in advance
If then formula for final cost
I am totally new to this and I think it is something simple. I'm trying to get final cost...This is where I'm at If(Margin= =20),(input.Net Cost x 1.25), If(Margin= =25),(input.Net Cost x 1.33)
Make your HTML views (appear to) load more quickly
Just a small trick I discovered the other day... When you embed a view into an HTML view you get a piece of code that looks something like: <div elName='zc-component' viewLinkName='My_View' params='zc_Header=true'>Loading View...</div> In this case, when the user loads up the page, they'll see 'Loading View...' for a second or so, then the view itself will pop onto the page once it's been fetched from the Zoho servers. As I discovered, you can replace 'Loading View...' with anything else and Zoho
Creating Facebook-like Public Facing Profiles?
I'm thinking of using Zoho Creator to give my vendor-clients the ability to manage a publich facing profile that our customers can view. In some ways I envision it being something like facebook, but without all the permissions issues. I simply need to create a long form that all vendor-clients complete, and maintain. We currently track about 100 different attributes about each vendor (like whether they have upgrades, cost, bolt on products and such) and with over 200 vendor-clients I'm looking
View criteria help required please
Can anyone help with the following with regards to setting criteria for a view. The following statement works fine and restricts the view to show only records where field "Load_ID.Status" is null and also where field "Status" is null... show all rows from Create_Pallets [(Load_ID.Status is null) && (Status is null)] I need to add another criteria to further restrict the view to show only records where, in addition to the above, field "Client.Company" contains either "word_a" or "word_b" I've
Cancel button not working in popup window opened from an embedded stateless form
I have a stateless form that is embedded in my website (no Zoho HTML view, a regular HTML website). In this stateless form I have a checkbox that opens a record for editing in a popup window on user input. To open the popup window I use openUrl("#Form:Test_Form?recLinkID=" + r.ID + "&viewLinkName=Test_Form_View", "Popup window"); where r.ID is the id of the record I want to edit. Unfortunately the Cancel button in the popup window doesn't work. When I click on it, nothing happens and the popup window
Updating existing data in a form through Excel import
I want to update existing data in a form through Excel import. How to do it?
Login Issue in embedding in other site.
I am facing an issue. I had created the form in the Zoho creator and it is in private Access. Once i embed the form in my webpage, It will ask for Login for the form. It was shown in the attached screenshot. [File name: beforeSignIn.png] After i logged in, The form is embedding in the same iframe. Refer to afterSignedIn.png. But i want to redirect my webpage to another page, which contains the form of my application created using zoho, once it is Logged in. Is there is any other options to use
CAPTCHA component in Zoho Creator forms
Dear Zoho Creator Team, Is it possible for you to introduce a small CAPTCHA field in the toolbox used to create forms? I think that would be very much beneficial to combat spam robots visiting the form. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Next Page