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/
Lookup and display current information on forms and views
My Zoho Creator database has a one to many relationship of one skater to many tests passed. In several views, I need to be able to display the highest test passed of three different test types (Moves, Dance, and Free) for each skater. I have successfully created fields in the Skater Information form which are populated on form success. The script in the form looks for the highest test of three different test types and places the high test number and name in fields in the form. I can display those
App sharing
I am the admin of an app. I shared the app to a "developer"-type user, but this user can't edit the app..... do I need to do something additional?????
Pivot Chart generated from Creator subform column
Hi How do I make a pivot chart auto-regenerate when the underlying data in the subform it is based on is updated? If I have a pivot chart that is created from a main form it auto-updates the chart when ever I add new data via the form but if my chart is based on a column in a subform I can only get an updated chart by manually clicking on "regenerate" option. Thanks EDIT: Actually the chart based on the subform data will update automatically(synchronize) if I submit the subform data by using the
Create an estimate from Soho Creator
Could someone provide a sample code to create an estimate using Soho Creator's Deluge script? The following script doesn't work. For the XMLString, I copied the sample that is given in the Soho Invoice API documentation for adding an estimate into a map. What am I doing wrong? mymap = map(); myURLXMLstring = encodeUrl("<Estimate><CustomerID>3000000000338</CustomerID><EstimateDate>2009-09-06</EstimateDate><ReferenceNumber>121</ReferenceNumber><EstimateItems><EstimateItem><ProductID>3000000000332</ProductID></EstimateItem><EstimateItem><ItemName>Sample
Expense in Zoho Creator
hye there, besides creating new invoice in Zoho Invoice in Zoho Creator, is there any way to create an expense in Zoho Invoice (expense) through Zoho Creator? may i know, what's the function invole? zoho.invoice.XXXX? thanks..
On Add Row in Subform, Lookup field pre-fills automatically with data from previous row (unwanted behavior)
Today we are noticing that when we add a row to a subform, the first lookup field pre-fills automatically with the value entered in the first row of the same subform. Other fields in that row are scripted to auto-populate depending on the value chosen in the lookup field. ex. given Row 1 Lookup field = X, several fields in row auto-populate according to a script using X as an input Add row Row 2 Lookup field pre-fills with X, incorrectly, auto-populates other fields incorrectly That lookup field
Update count
Hey, I'm trying to use the Fetch and Update records to update a count/total number of items. eg I have an inventory form with toner cartridge with a count, eg I have Model: "lexmark T644" Cartridge: "black" number: "3" And so on for each item. In another form, when people input they changed one of these, how can I update the count from 3 to 2? eg minus 1?
Missing Feed URL tab
I would like to generate an RSS feed on my database, so i can import 'm in Google Reader. On this webpage https://help.creator.zoho.com/Import-and-Export-Data.html i see a FEED URL option, but i can not see/ enter this tab.
How to use openUrl to act like the built-in edit record behavior
Hi i have used customer action to call forms to update records in popup window but i encounter some problem while closing the popup window if using openUrl("#Script:page.refresh", "same window") the view page reloaded to default setting, all search/filter are gone if using openUrl("#Script:page.close", "same window"); popup window closed, but the newest update is not shown in view page how can i make the openUrl act just like the built-in edit record behavior? remain the search/filter
Can Invoice pass "paid" status to creator?
is there a way to pass a "paid" status to Creator from Invoice. If the customer has made a full or partial payment, can a custom variable be passed to a table in Creator to reflect it that a payment has been received?
How to make fields required by default?
Is there a simple way to do this? In our forms, almost every field is required. It would be much easier to make everything required by default rather than having to click 'Options' and then 'Required' for every field in a very long form.
Ticket ID: 934663 (7 Days A go)
Dears, I send 2 mail but no any answers. I am still waiting... Rgds CTG
How do I paste the contents of one field into part of another field?
Hello - In my database I have a field called "subdomain", and then I have six other fields called "URL Europe", "URL Alaska", URL Caribbean", etc. The six fields have exactly the same content for every record, with the exception of the subdomain. i.e. - http://[subdomain].europe.myvacation.com http://[subdomain].alaska.myvacation.com http://[subdomain].caribbean.myvacation.com I would like these fields to auto populate once the subdomain has been entered. What is the code to program this? Also,
Workday function
I am familiar with solutions from here https://help.zoho.com/portal/en/community/topic/calculate-number-of-business-days-weekdays?reply=true But I don't understand how to use it. I have formula field named "Day" with this formula: ((zoho.currentdate - Start_Date) / (1000 * 60 * 60 * 24)) "Start_Date" is data field. I want in output to exclude weekend days (Saturday and Sunday). In other words I want formula only to calculate business days. I am happy to pay consultant for help.
Next Page