How to Add Custom Styles Zoho
Hi, I am trying to replicate an existing form I am using, I need to be able to apply custom css to the form that I am currently using and also use a custom image for the submit button. How do I do this? I wasnt able to find any documentation and also when applying my styles in the stylesheet they don't show up Thanks
Share - Make Public option is not displayed
Hi Zoho, I like to share a particular form publicly, so anyone can fill in the particular form. I am following your instruction https://www.zoho.com/creator/help/application/application-sharing.html#Make_Public_to_all_visitors_over_the_web, but I don't see the option "make public..." displayed. I can only share with individual users or groups. How do I enable the "share publicly" feature? Thank you, Ivo
User Defined Variables
With "Script Builder" when I edit, for instance, an "if condition", a dialog pops-up to allow me to compose the statement. For the "criteria" I can choose to use a "User Defined Variable", but the list is always empty. Which is the way to create User Defined Variables?
Auto Welcome Email to those that register off our form.
I'm looking to create a welcome email back to those that register for our events after they fill out the form and submit it. I'm looking for this to be automated so as someone registers, it will kick out and email back to them of all the details for the event and a thank you for registering. Can anyone help me with this, I think I can do it but might need some guidance. Thanks - Mike Olivera
Set null to all fields in the form
Hi, I am trying to write a script on user input of a specific field so when user select the null (something like -Select-- ) then the rest of the fields will automatically set null values. I can try by below code but since there are lots of field so I am looking for short way to do that so I don't have to write all fields individually. Can anybody please help me . Code : if (input.Update_TVStation = null) { input.field01 = null; input.field02 = null; input.field03= null; input.field04 =
Zoho Creator form Integrated into Custom Module
I am using the Zoho Creator to develop forms that speak to the Zoho CRM. I am able to have a form create an entry on submit for the standard modules, however it stops working when I try to apply it to a custom module. For example, in one of my forms I have the following script to run when the submit button reaches "on success": myFieldMap = map(); myFieldMap.put("Product Name", input.Product_Name); myFieldMap.put("Product Description", input.Product_Description); //function to push data to CRM response
If Statement in a Function
Unsure if this is possible or just bad code. void OffHold(int ID) if (On_Hold_Date == "null"); { alert "Sorry, You can not take Off Hold that is not On Hold"; cancel submit; } else { rec = On_Hold_Test_App [ID == input.ID]; rec.Off_Hold_Date = zoho.currentdate; rec.Due_Date = zoho.currentdate.addBusinessday(2); } I'm receiving the following error message: Error at line number : 2 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Help with Date Function
I'm working on a weekly inspection application. The function I need will reset a date field based on the current date. But rather than resetting the next inspection date by one week, I need it to reset the date to whatever next Monday is. Example: Today is Wednesday 24-SEP-14. On-submit should reset the next date to Monday 29-SEP-14, not 01-OCT-14. Cheers, John Whitney
Page HTML not working
Hi, I'm trying to build a home page using the "insert HTML" feature on script builder. When I drag and drop, the screen turns to a transparent greyish/black (similar to when loading) but stays like that forever. I've tried using two different computers that but problem persists. Please assist. Siya
Linking CRM contact to creator
Creator does liink to CRM. I built a time and billing app in Creator. What I would like is the ability to start at a contact in the CRM and open up the app and have it carry over the contact info. Then have it display in the contact as well the time and billing amount that I entered. Any suggestions on how this can be done?
Restrict user access to certain records in reports
I have multiple users from multiple facilities accessing the database. I don't want all users to see all records from all facilities. How can I restrict the records in a report to one or more facilities, depending on the user trying to view the report? For example, John creates records for the Middletown Facility. Debbie creates records for the Milwaukee facility. Jane creates records for the Denver facility. Sara supervises John and Debbie but not Jane. Sara shouldn't be able to view Jane's
How to fetch data and show in textbox
I am trying to create a textbox that will show work # related to employees under their time cards. Is there a way for me to retrieve work # from one form that they fill out (which they are assign to and have to clock into) and show in the time card under the employee? I like to keep track of the work # they do each day. Could someone give me example on this please. Thanks in advance.
urgent: cannot load form from view
as well, when adding a record I receive message "Unabble to load data" I made some changes to field lengths (appearance and max length) as well as deleting some unused fields. please help. what field or script is causing the error?
Set submitted ID record as default in a lookup field
Dear All, I have two forms Test1, Test2. In the submit button of the Test1 form I have an openurl which redirects to the Test2 form. Now, Test2 form has a lookup field with the IDs of the Test1 form. My question is: When I click the submit button of Test1 I would like the submitted ID of the form to be the default value in the lookup field (in Test2 form). In general I want when I click the submit button then the ID of the submitted form to be the default value in the lookup field (which keeps the
insert a specific value from picklist to another field
Hi, I have a pick list -- Status -- field and which contains several values like -- Duplicate, Review and No Need . What I am trying to do is insert 'No Need" value from the lookup field Status to CD_Status field of Chanel_Database form. Can you please help me to fix . Below is my code if (input.Update_primarychannel != null) { insert into Chanel_Database [ Added_User = zoho.loginuser CD_ChannelType = "0.1" CD_market_id = input.Update_MarketID CD_Network
How do you do the same native form refresh on page with report and form view?
I've been reading the forums regarding refreshing portions of the page. I've tried the iframe method with no avail. My application is a simple inventory tracker, and I'm currently working on the inventory checkin workflow. I have a page that has an inventory checkin form at the top of the page, and a list view of the recently created records at the bottom. I'm not using the native form submit, as there will be instances where I want to scan in one UPC and then attach several serial numbers to it
When creating a record with script, how can I create a checkbox field 'checked'?
I've tried setting the field as true, I've also tried passing in the value to be selected, but every time I create a record with the script I'm using, all the values are set, except the check box. Please help.
Interfacing Creator with SAP
We are looking for interfacing data from our SAP system. On completion of some event in SAP we can push the data out from SAP by any method which ZOHO creator can receive. We would like to receive this data automatically uploaded/added as a new record into a ZOHO form. After an event completion in ZOHO creator we would like to push full or part of data to SAP for an update.I may like to push data from SAP in XML format to add/update a record in ZOHO creator and similarly expect ZOHO creator to push
Combined Reports issues
Hello, I need to combine two forms in a report, but I've been having problems because sometimes the report doesn't display the field data. I've tried this from the Zoho documentation: First: https://www.zoho.com/creator/help/forms/creating-relationship.html And then: https://www.zoho.com/creator/help/views/create-a-combined-report.html And it works but only with some fields, I don't understand why but sometimes some fields doesn't display any information in the report. For example, if I relate the
Error Duplicating records
Could you please tell me why I am getting an error whilst duplicating a record in mrcomputer/signedfast. I assume it is a scripting error but I don't know. Thanks
Application not working on iPhone
Has anyone had any success in getting applications created with Zoho Creator to work on smart phones, particularly via Safari on an iPhone? I can get the initial form to display, but when taps Continue to go to the next page, the next page never loads.
How to rename pdf?
Hi all, I have a formula to download an html view as a .pdf file. When it downloads, the filename is beo.pdf (my page is called BEO). Is there anyway I can name the file with some fields from the view (ie mmddyy_title_beo.pdf or similar?) I'm attaching the function for reference in case it might help somebody else at some point. void BEO.LoadBEOpdf(Events ThisEvent) { openUrl("https://creatorexport.zoho.com/jeffzearfoss/catering/pdf/BEO1?ID=" + ThisEvent.ID, "new window"); }
InValid email Address Found.
I'm new to ZOHO so I'm hoping this is an easy fix. I'm receiving this error message when attempting to send an email from zoho.loginuserid and cannot figure out how to fix it. Ideas? Thanks! Error details: Error in executing Error. Error in executing Send Mail task. InValid email Address Found.
Count lapsed times between Added-Time for Records created by the Emailed Data process?
BACKGROUND INFO: I have onSuccess script that works fine for the regular add record process, but doesn't work when records are created through emailed data. The script (shown below) enters the lapsed time between the creation of the new record and the most recent record created that day with the same value in the Person field, i.e. that meets the criteria : (Person == input.Person and Added_Time == today). This image shows that the first record created (Record Number 1) using the normal Add within
RTF - edit a table
I can insert a table; is there any way to add or delete rows once the table has been created?
creator embedded form click through background
I have embedded a creator form on my webpage. The problem is that this form is above several page elements and in order to make the creator drop down menu in the iframe to work, the height needs to be set fairly large. Trouble is when doing this all other elements and links on the page below it can no longer be clicked because the iframe is on top. I need to be able to click through the background of the iframe form. Can this be done? How can this be done? Al already have the background set to transparent
Run two different scripts on User Input Action
Hi, Is it possible to run two different script on User input Action ? Actually I have a stainless form to Update the data of another form. Below I describer What I am looking for . please help me to fix it. On User Input of TV Station below is script code : if (input.Update_TVStation != null) { dat = TV_Station [ID == input.Update_TVStation]; input.Update_ST = dat.Add_ST1; input.Update_Market = dat.Add_Market; input.Update_BM = dat.Add_BM1; input.Update_RF = dat.Add_RF1;
Will Their Always Be A Free Version Of Zoho Creator
Hi, I have just a quick question below: Will their always be a free version of Zoho Creator in the future? Thanks,Eric
Font size & custom view
I accidently did something to change Font size and in doing so my look ups are not in alphabetical order. How do I change font size? How do I get my custom view back working?
Data in reports won't refresh
Hi, I am updating data in one table on my app, but the data will not refresh in the reports of the other app that is pulling information from the first table. I have tried everything I can think of, clearing cache, restarting the browser, and nothing works. Basically the only way I have figured out is to look up all of the data again and again and that is not feasible when I have over 300 records that need refreshing on a weekly basis. Does anyone have any ideas? I am basically updating information
count and total scripts in subform work on add but not on edit
Hi, I have the following count and total scripts that work on add but not on edit: Count script on add row: count = 0; for each record in Bin_Weights { count = (count + 1); } row.Winery_Bin_ID = count; Total script on Gross_Bin_Weight user input: temptotal = 0; for each record in Bin_Weights { temptotal = (temptotal + record.Gross_Bin_Weight - 93); } input.Total_Net_Weight = temptotal; I am populating the Harvest form from my Work Order form by the following: if (input.Work_Order_Operation
Transposing the subform
Hi, Is there a way to transpose the subform field in zoho creator or switch the columns to rows this way it won't be a very long way to scroll to the right just to fill the 30+ fields I created in subform? Thank you, Jerome
Variable not defined help Please
I have for called Staff it has field called Staff_Member It has field called Cut_Code in main form I enter Staff member using lookup field I try to populate Cut_Code from Staff_Member choice by on user input in Staff_Member but the following code returns error when I try to save saying Error at line number : 1 Variable 'Staff' is not defined My code is if (Staff[Staff_Member == input.Staff].count() < 10000) { temp = Staff [Staff_Member == input.Staff]; input.Cut_Code =
Can't delete apps
Hi - I created 2 apps in my account and now want to delete them. I click on the delete symbol and confirm but the apps remain. I have enabled support access and app names end with "-delete" Thanks, Jeff
PaylPal Issues
Here's what my "on success" code looks like along with the line that's at issue user = DB[key == zoho.loginuser]; input.userkey=zoho.loginuser; input.PIN=((zoho.currenttime.toLong() % 1000000)).toString(); zid = insert into PTO_PIN [ Added_User = zoho.adminuser Claimed = "Yes" parentname = user.p1n parentphone = user.p1p PIN = input.PIN pto_email = "highschool@niskypto.org" school = "Niskayuna High School" useremail = zoho.loginuserid userkey = zoho.loginuser ]; success message "Thankyou
Custom view based on Report
Hi, I have a form and which have like below field. Now I want to create a new view based on the main form report. Form report : New view : I am trying to create below type report from above report. Is it possible in Zoho creator ? Please help me to fix it.
How do I lookup data in one form and populate it in another
I have two forms - one a registered players form that I will be pre-populating with an import file. I have a registration page where I want a volunteer to put in the last name of a player and if there is a match populate the registration page with all the information we have on that player - I have tried the fetch records but cannot get past an error message - any scripting help would be very much appreciated
Can I Cancel Submit if my field in not hidden?
My form checks from the user if he has filled the form previously or no. If he/she chooses yes in radio button I show an id box to enter the id they used. On filling the ID, some times they try to click submit anyway and it ends up asking for all the mandatory hidden fields which is a mess. I want to cancel submit if my field which determines if the user has filled the form before is visible and not hidden? Is this possible?
Conditional Criteria to filter Report? PROBLEM SOLVED
BACKGROUND INFO The weekly cycle in my app is Thu-Wed. Records have an integer field called WK which stands for Week. Records created Thu-Sat are assigned the week ahead, i.e. WK = Added_time.getWeekOfYear() + 1 Records created Sun-Wed are assigned the current week ahead, i.e. WK = Added_time.getWeekOfYear() QUESTION How can I set a criteria to select records on a report so that IF viewing the report on Thu, Fri, or Sat THEN record criteria is Week = Added_time.getWeekOfYear() + 1 and IF viewing
Rich Text Pop-up
Hello Experts! I have a well organized report (a List) which shows a series of records with specific sorting and grouping. Users started asked me if they can add notes to specific records with specific messages. This would be easy to accomplish with a multi-line or a rich text box. The problem is that when I add the notes to the table, the table starts looking weird with some record taking just one line and other taking huge space to accomodate the notes. Ideally, when I look at the list, it would
Next Page