Embed Calendar view in Creator doesn't work
I can't seem to get calendar view in creator to embed properly in my website. All I get is the report view, not the calendar view. What am I doing wrong?
lookup field on a lookup field
Hi there I am trying to add a Look-up Field onto a Sub-Form that appears in the Parent Form, BUT the Parent Form Field I require is also a "Look-up" field, linking this to another table in my App. I tried creating a Look-up to the Linked table (Not my Parent table), but this does not allow me to run reports with data from my parent table. Any assistance? Thanks Kevin
Set default value in lookup field after submission
If I have a lookup field (dropdown) with countries, is there any way when I select a country and click submit then automatically set this country as default? . Can you please send me an example of this? I tried (in On Load) to fetch records like value = Country [Name_of_Country = "Germany"].ID; Lookupfield.select(value); With a country like Germany it works but I do not want this.
Zoho Creator: Error in executing Send Mail task. From Address is NULL.
Hello everyone. Just created an application including one form and one report via Zoho Creator. I set the form so that anyone filling the form will then send a confirmation email (one copy to me) including all data given. I tested the form and it works perfectly to me, I receive the confirmation email (I filled the form using my personal email account) and I also get it as a copy to my other email account as creator of the form. The problem is: when everyone else is filling the form, they don't appear
Field with Change Log?
Hi, I have a project tracker application, and a rich text field I use for keeping action notes, I was wondering if there’s a way to have a change log recorded option, and easy way to access it if I want to go back and look at notes I have deleted as I updated the field for new notes or projects
HTML in a formula field being displayed in a view as text
Hello, I have been using HTML in formula fields for some time and no problem at all. Today I was developing an application where the HTML code in the field resulted in plain text shown in the view. Is there anything I am missing? I am talking about a code of this sort: (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_View?MOB_idstr=") + MOBID) + "\">View Details</a>" below you can see what I am talking about, the field Titulo is a formula
HTML Page - iterate rows for each record
Hi everyone, I logged a call with support a few days ago, but have had no response and need to get a report finished for tomorrow, so am struggling. Herb has been fantastic assisting me with resolving some other issues but I hope someone on here might be able to help on this point. I have a database of student data. I have created an html page to display the data held on 15 tables, all of which are linked to the student personal information through a FullName lookup. Some of the tables contain multiple
Create HTML+Deluge Script button in a Formula field???
A Zoho Creator developer recommended that I add a Formula field to my form that contains the following HTML+Deluge script in order to create a 'View Details' button. (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_View?MOB_idstr=") + MOBID) + "\">View Details</a>"What the code produces is seen below. Since this is put in a formula field it is displayed on any of the views in which I choose to view this field. The Deluge script pulls
Problem signing into database after user changes email address in Zoho account.
Hello, I am the administrator for a database. One of the users changed their login account to a different email address: Now they are getting an error message when trying to log into the database: The error message is: "You have logged in as adminvs1. You are not allowed to access this application. ..... Please click here to login as a different user." I had already changed the usrer's email address/login to the new email address the user has changed to. The user is able to log into her Zoho account
Return the last two digits of the current year. For example return "14" in 2014
I wish to have it returned as a string value that i can concatenate into a file name. I guess that it is an index value truncation but I cannot remember.....
How to Assign multi-select records for Selected user and Allow Permission to view by only the User
Hi Guys, How to Assign multi-select records for Selected user and Allow Permission to view by only the User. I have couple of users (user-A, User-B, etc.) and couple records (record-1,record-2,record-3,record-4,record-5, etc.) in the application. I want to create one form with multi-select for records and lookup for user. on submit Select records must assign to the selected user. Such as for user-A assigned records record-1,record-2,record-3 and user-B assigned records record-4,record-5 Once done
custom action html view
Can I build a custom action button and open in a pop up an html view? When I try this i get a popup that just says "loading view" and after awhile it closes but the html view never actually opens or shows. Is this a bug? I found another post from years ago talking about this problem. Has this still not been fixed? Please help I would prefer not to screw around on this for hours if its just plan old broken. My custom action forumla button has the following code: "<a class='zc-formbutton' href=#View:RFQ_Send_Production_Order?zc_LoadIn=dialog&Request_ID="
Refresh the Captcha
Is there any way that a user can refresh the Captcha? I have a couple of forms that require the user to correctly fill in the captcha before submitting data. During testing, I've on occasion had to either guess 4-5 times, substituting 0 for O, I for l, Z for 2 (you know what I mean), and have a few times had to resort to resetting the entire form and adding all the information in a second time, hoping the new captcha will be more obvious. Am I missing the tool that ZOHO provides to accomplish this?
Error inserting value to linked field
Hello, I have a stateless form that is uses "insert into" command to populate two tables, "Contacts" and "Contact_History" in the "On Click" script of the "Submit" button. First I insert data into the "Contacts" table. The "Contacts" table automatically adds a 'Contact_ID' value via an auto-numbering field. Next I fetch that Contact_ID value (assigned to 'r') and use it to add linked data into the "Contact_History" table, attempting to populate the 'Contact_ID' field which is a look-up to the Contacts
input. removed from formula fields
I have a custom action in a formula field using the following code: "<a class='zc-formbutton' href='#Form:Approve?zc_LoadIn=dialog &Vendor_ID=" + Vendor_ID + "&Request_ID=" + Request_ID + "&RFQ_Response=" + input.RFQ_Response + "' >Select as Winner</a>" Immediately after saving this code the input value of RFQ_Response is working and the form that opens up has the proper value in the RFQ_Response field. Trouble is, if i edit the button or save the form later the code on the custom action seems to
Call a function on Field Action , On User Input
Could someone help please? I have this function which works fine on test: void workorder.UsedQty(Work_Orders workorder) { for each recRow in workorder.Pick_Items { Item_Name = Maintenance_Item [ID == recRow.Item_Name]; Item_Name.Qty_on_Hand = recRow.Qty_Remaining; } } But when I want to set variable or call this function, I get the error “UsedQty is not a valid function” I am trying to call this function after a Field Action , On User Input , script as follows which
When creating a form is their a way to duplicate fields?
I am building a Materials Tracking application which has both shipping and receiving forms. On those forms we have 24 pallet and weight fields. Each Pallet field would be a drop-down to select the type of commodity being shipped or received. I would like to add them without having to manually input all options for each field. Also, as an add on question, is there a way to show the next pallet and weight fields only if the previous have been filled out? Thanks, Chris
You have reached maximum number of rows. You can not add further
When I try to use a subform and add an entry I am getting the following pop up message that prevents me from adding new items in any of my sub forms across all creator applications: "You have reached maximum number of rows. You can not add further" Seems pretty self explanatory except we are no where near our record limit so this doesn't make sense. Is there a way to increase the number of rows allowed? Clearly either i do not understand what this message means or there is something wrong with
Update formula field with schedule
Is there any way to update a formula field that calculates the number of days between the current date and a future date using a daily schedule? I know you can't get a formula field to automatically recalculate (totally ridiculous but let's ignore that now). Is there a way to use schedules to update the formula field or another field that contains a number? I'm thinking pass the difference between the current date and a future date to a numeric field. Then on a daily basis use a schedule to subtract
Delete User After form is closed? Unshare/ deactivate users shared to app?
I am trying to delete users as soon as they use the application that I have set up. Is there a code that could help me do that? I tried "unsharing" the user in the "on success" part of the application but it doesn't seem to unshare the user at all. In fact, the command seems essentially pointless. I need users to log in so that an email can be sent from their prospective email addresses, but then I would like said user to be automatically deleted from the account. OR If there is a way to use their
Mobile forms
Hi, Is there an option to turn off the zoho header on mobile form? I can understand why Zoho doesn't support customization in mobile, but the ability to turn off the header should be available. Something like ‘form-mobile/formname/zc_Header=false….’ Having the ability to link to mobile forms without a menu back to the entire application seems like a big oversight... Is there a workaround for this? Thanks in advance.
Anyone else having issues posting a requirement on Marketplace?
I have reached the limit of my capabilities and was looking to post a requirement for developer assistance having a new html page populated with fields from my database, but every time I attempt to post, I just get a posting error. Anyone else having trouble with this?
How to specify the start marker for the form
I am new and I have created a survey form in zoho creator which I have embedded on a webpage. When the survey loads it loads at the bottom of the survey instead of the first field. Is there a setting I am missing or some other task I need to do to specify the form load at the top at the first form input field? Thanks
Help with a formula please
I need some help with the following code please.... visitDates = Signing[(Run_Number is not null)].distinct(Run_Number); for each dt in visitDates { code = ""; for each r in Signing [(((Run_Number == dt && Post_Code != "") && (Post_Code is not null)) && Job_Status != "Completed")] sort by Time_of_Visit { code = code + ":to:" + r.Post_Code; } for each r in Signing [(Run_Number == dt && Job_Status != "Completed")] sort by Time_of_Visit { //r.Map_Location
Variable sales price
Dear, I'm currently testing Zoho to replace our excel based order and quotation system. Up to now everything what we need seems to work but 1 thing I can't grasp. Hope someone of you knows how to tackle this... The sales price of our products are depending on the order qty. for example: from 0 to 5 pieces = 10€/piece from 5 to 10 pieces = 9€/pieces from 10 pieces = 8€/piece I would really appreciate any guidance on how to approach this? Kind regards, Noel
Zoho Creator Blues
Is anybody else having problems sharing apps in Zoho Creator? About a week ago I started getting calls from Users with whom I had shared apps. They were logging in as usual but getting an error message: You have logged in as (xyzabc). You are not allowed to access this view. When I checked the apps it showed they were still listed as shared users. I had not exceeded my user quota. My own login (as Admin) was working fine. Despite all that, when I tried to log in as them, I got the same error message.
Setting criteria for execute script with .getDayOfWeek()
Good Morning, I'd like to create criteria for execute a schedule. My intention is to have an alert with differencial text based on the days missing for the event and also according to the day of week in which the event will be occured. The first step is done, how you can see from the image. I used DATE.FIELD= zoho.currentdate.addDay(2), in this way the mail will be sent when missing two days, but I had problem with second criteria. When I try to differentiate the days of week to have a different
Linking a subform after data import
Hi, Im trying to import my data and structure from an access database into Creator. While the import works, after I have edited the forms i want to add subforms based on their relationship. I can set this up but there is no way I can see that links the 2 records. Please can you show me how to link a subform to its parent after data import? Thanks Amy
Unable to open attachment files in Google Doc Viewers
Even though I imagine this is not your top priority. I'm looking for a way to attach documents in the system PDF or DOCS and be able to view them in the browser. The problem is that Google Viewer does not work with Zoho attachment links. I've tried to translate a working link here: http://docs.google.com/viewer and copy paste the address to the browser address bar, google is stuck with translating DownloadFile.do script. Any chance you have a work around to not download attachment, but work more
Record Summary customization problem
I am trying to set up a record summary view very similar to the sample invoice shown on this page: https://www.zoho.com/creator/help/views/record-summary.html The problem I am having is that the subform area (like the Item, Quantity, Price fields on the sample invoice) are not displaying multiple records. Instead, they show the multiple items in one field (like instead of showing two records for Item "Widget A" and Item "Widget B" they show one record and list the Items as "Widget A, Widget B."
Currency field not formatted in HTML View
I don't know if this is a bug or expected. A currency field that is appropriately formatted for a normal view, is not formatted when using the <%=field%> tag in an HTML View. I am having to hard code format it. Please advise if this behavior is expected (and why)...or is it a bug? Thanks! Robert P.S. By formatted, I mean it is not rounded to two decimals, there is no currency sign, and there is no comma insertion.
Custom Button Function
Hi There I have created a Stateless Form with a Custom Button, in order to copy records from one form to another. My Script is: for each x in Project_Info[ID!=0] { insert into Install_Project [ <Job_No>=x.<Job_Number>; <Project_Name>=x.<Customer>; ]; } I however get an error on Line 1 - Improper Statement Please assist in explaining why this error is being received? Thanks Kevin
Double floating header in custom action button glitch
I have a custom action button that seems to have a strange glitch attached to it. The custom action button opens up a view and the header seems to be duplicated. I cant get rid of it with out navigating to another page and back again. This is very frustrating. What is going on and why is this happening. Someone started to look into this but I have not got any response yet and its been a while. THis happens in the following view: https://creator.zoho.com/precisionsailloft/prod/#View:Sent_for_RFQ
Summary View does not show all data. Specifically embedded external data. HELP.
I created a form that includes the "rich text" column. From there I am embedding external data. That data is not showing up in my summary view - which was the entire point of creating this form. Please advise. The html code I use elsewhere works fine, so its not the source code. Also, the document I am embedding shows up fine in the form when I embed it. It's just not showing up in the summary view. HELP Please. Rene
Switch Display Type for embedded view
Is there a way to display the cogwheel to change the display type when a view is embedded in a website? When the view is seen in the Zoho Application the cogwheel gives choices for View As List, Summary, Grid, Spreadsheet. When embedded this option is gone.
Writing condition
I'm new to zoho creator. Recently created a form. Now I need to create an automatic task. I have these fields in the form: Quantity Unit of measure Total Weight Here is what I want : When Pallet is selected as unit of measure each Quantity is multiply X 45 lbs. So if I enter Quantity: 10 Unit of Measure: Pallet I want the form to return automatically Total Weight: 450
How do I make prices not a preset value, rather a custom value that is subject to change?
I am trying to let users be able to set their own prices when they create a new order using the Order Management database for Zoho Creator. As of now, the price section is grayed out when I try to create a new order. Since we are a wholesale company, I want this to be a custom price that is subject to change depending on the volume of the order.
Help with some code please
In a multi line text box I use some script to populate the box The script is input.Map_Address = input.Clients_Name + ", " + input.Clients_Address + ", " + input.Post_Code + ", " + input.Telephone + ", " + input.Place; This produces Ian Mitchel, Benfleet Close, SM1 3SD, 07860635993, Sutton I want it to be Ian Mitchel Benfield Close SM1 3SD 07940635993 Sutton How do I add the carnage return and how do I centralise
Creator not getting CRM data using Zoho CRM field
I am new to Zoho Creator and have searched the help, support, this forum, and the web for a solution. I am having a problem getting the Zoho CRM field to work. I upgraded my CRM account to Enterprise to get the Creator integration and am paying for the Standard version of Creator to get CRM sync. (I'm still not sure if I needed to upgrade from CRM Proffessional to Enterprise to get Creator to pull data from CRM. But, because I'm having this issue, I upgraded to see if it would solve the problem.)
can't hide or disable fields in subform
My Creator app uses sub forms. As of today, the app produces an error if one or more of the fields in the subform are disabled or hidden through deluge script The error message: Error in executing GENERATEJS_TASK task. I verified this problem in a brand new form that only contains a subform with one field disable/hidden, so it can't be related to any of the other deluge code.
Next Page