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
Zoho CRM field in Native Mobile App
I realise that forms using the Zoho CRM field aren't available in the Native Mobile App. I am curious if this is because of a platform constraint on the Native Mobile version or will we see this in future? I am developing an app that requires CRM contact data and know that I can code a method to pull down contacts that meet criteria x and populate a dropbox with them, but its not as clean. Really hoping we will be able to use the CRM lookup field on Native Mobile at some point... Thanks, Mark
Filter a subform?
Is there a way to filter a subform. Perhaps if row.field = "Inactive" { hide row }
Error in executing zoho.invoice.createinvoice task
Hi Team I have been using a Zoho Creator to Zoho Invoice creation task for several months. Today it stopped working. The error it produces is this: Error details: Error in executing On Add - On Success script. Error. Error in executing Set Variable task. Unable to update template variable invResp. Error evaluating MAP expression : Error in executing zoho.invoice.createinvoice task : Error.. Here is the code that I am using to create the invoice.. .Can anyone please tell me what is wrong with
Need Help
I am farelt new to Zoho creator and had schooling on Microsoft Access, but it has been years since I did any coding and this is almost a different way of coding. It just seems I just can't get it right on this. Here is a draft of what im trying to do: If Company_Name = "Company" { Labor_Total = Labor_Hours * 60 } { Else Labor_Total = Labor_Hours * 70 } Note: -The Company_Name is a dropbox...would I need to give the comapny I put in there a value and if yes how? -Labor_Total is a currency
Formula field
I'm new to ZC and am hoping there is an easy answer here. I created a form where people are rated "evident", "emerging" or "not evident" on a list of competencies. Each competency is a different field and they rating is selected using a radio button. I am trying to create reports on how many evident / emerging / not evident ratings were assigned and am struggling to find the solution. I am trying to use a formula field to sum the number of each rating on the form and am struggling. I also tried using
Default value for related drop down
Hello, I have a related field that contains a list of employees and is displayed as a drop down in a form. I need to set a default value for this drop down, how can I do that? This value depends on the logged user, if this user is listed on that drop down I have to set it as the default value, how can I achieved this? Thanks!
Drop Down field looses it auto complete function when populated from a list.
I have a drop down field that i populate from a list. The list is created then sorted into alphabetical order and placed into the drop down field. Once I do this the list is correct, but the drop down field loosed its auto complete function. How can I maintain this feature as it is very useful to the end users.
Schedule limit
What does this mean please You have reached the maximum Schedule limit permitted for this account. Please upgrade to add more. Thanks
Send entire form to external site
I want to submit my entire form to an external site to be processed. I see that there is a deluge function, post Url. When I try to set up the function, I don't see an option to send the entire form, only a single field. Is there a way to send entire form?
Retrieve the data from another form
Hi, I have a application in Zoho creator which consist of three form -- Market , TV Station , Census Market form has two field : Market Name ; Market_id ; Census form has three field below: Market Name ( look up from Market form) , Market_id ( lookup from Market form) Households Value . TV Station Form : This form has three fields below TV station Name Market (lookup from Market Form) Households What I need to do is when user select Market from drop down then a script will run and fill the
Field Filter not working after variable assignment script
I have a lookup field with a filter added. When I choose a value in a different field, deluge script assigns a value to the field that is indicated in the filter, but the filter does not execute. If I manually select the Value in the field, then the filter works. I also have a script that runs on user input to that same field in which the filter is dependent "GHS Co". and that script runs when GHS Co is autofilled. The filter is not added via script, it is added in the field settings.... so
All Zoho creator applications are missing.
For our Zoho account caluganda, all of our creator applications are missing. When we sign in with any of our user ids/passwords no applications show up. We created several applications and they are all gone. We need them restored as soon as possible and we need to know what the problem is. Why are they missing in the first place??? Jim K.
Barcode scan
Is it possible to achieve the following? I want to add some barcodes in the windows applications. This barcode should be displayed when I click a button. I am new to this and wondering if someone could help. If some sample code will be great！
Add Button to a Page
I have a Page which pulls and summarises data. At the bottom of the page I would like a button which once the user is happy the summary is correct can click to load data into ZCRM. I have created the data load to ZCRM using a button on a stateless form but would like to do it from a Page. Is this possible? Thanks Gordon
Import Dropdown choices
Hi, sorry if this question is answered, but I didn't find it. How can I import all choices of a dropdown field? For example, if I have a list of countries, how can I import this list to a dropdown field to be selected in a form? Thanks in advance!
Unable to Set Access Permissions for Fields
I am not able to set or edit the Filed Permissions for all the profiles. This issue had started two days ago.
I have set a scheduled email for a specific date, tried to execute but I get an error, what am I missing?
The error message is Execution Failed Error details: Error in executing form schedule(Form Schedule). Error. Error in executing Send Mail task. To Address is NULL. The function is below SendMail [ From : zoho.adminuserid To : input.email Subject : "Subscription update" Message : "Hi " + input.First_name + "<br />\n<br />\nJust a quick not to say your subscription is coming to an end and wanted to check that you still need access to the proxy server<br />\n<br />\nRegards<br
First line of code gives error
I have used this code for 3 years and now it gives an error If(input.Owner_Offering_Trade == "Keith”) Error when I try to edit: Error at line number : 1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression What do i do?
<enter> key for "add new" in subform
Hi, I have a subform that records bin weights for harvested grapes for each of my growers. I can receive 30 to 50 bins at a time. I would like to use the <enter> key on my keyboard to add a new row instead of having to click on the "add new" button. I would be grateful for any advice on how to do this. Best regards, Jeff
Invoice with Multiple Lines
Hi, I'm working on a project where I'll have vendors across the country that will collect orders and payments for me. They will pay me the total payment less commission that we agree upon. I will grant them access on Zoho Creator - Customer portal where they can keep track of the orders they submit to me. For each vendor, I want to export all the orders they submit (on a given period) to Zoho books and prepare an invoice. I've just tested the export feature from Zoho Creator to Zoho Books and it
Copy Record only once
Hi, I've been testing the script below on copying records to another form: void copyRecord(string Name, int Phone, string Email) { insert into Clients [ Email = input.Email Name = input.Name Phone = input.Phone Added_User = zoho.loginuser ] } I noticed that this script allows you to copy the same record more than once into another form. I want to only copy a record only once. How can I modify this script (or another script) so that once a record is copied into another form by executing this script,
Next Page