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;
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
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
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
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
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
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.
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.
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
<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
Go to URL after form
From a list view, I have a custom action which leads to a form: void Company.AddCalendarEvents(int CoID) { openUrl("#Form:Calendar?Company=" + input.CoID + "", "same window"); } Once I enter values, and hit submit, the form re-loads, but it's not useful to me as the Company Value is not pre-loaded. I would like to either: - have the form reload with the same CoID value OR - re-direct to a different url what do I do?
Can you filter a subform based on a data in the main form?
Can you filter a subform based on a data in the main form? Example I have an employee Data Form and an Employee Time form (for time entry) Can I add the Employee Time as a subform to the employee Data form and only show the time records for that employee? does this make sense?
Creator form code to embed on webpage (not iframe)
Is there a way to get the html / java / whatever code of a creator form so I can put it on my webpage? The iframe embed code does not work for me as i need to be able to add my own css to the form. I need to be able to manipulate the way the form is displayed beyond what you can do in creator. If i could get the source like you can for a CRM form i should be ok. My main problem is i need to put the form at the bottom of the page and the drop down menu from the search form field appears below the
Using ZCStyles
Hi I found this application called ZCStyles (https://creator.zoho.com/public/showAppInfo?ownername=srhyne&callbackUrl=zcstyles) and tried using it. But, noticed that the <style type="text/css"> tags got wiped the next time I opened the note. Maybe that's a bug? Could you please guide a little how to use this application? Could you please guide on changing the theme of my application? I have my own theme and want to customize the application's look and feel.
Problem Setting the Field Permissions
I am a Zoho Creator Enterprise subscriber. For the last two days, I was not able to set or edit the filed permissions for all the profiles. Does anyone also has this problem?
Error while summing rows in subform
Hi, I have a subform called Bin_Weights. I am using the following code to calculate the total net weight: temptotalB = 0; for each record in Bin_Weights { record.Sub_Total = record.Net_Bin_Weight; temptotalB = (temptotalB + record.Sub_Total); } input.Total_Net_Weight = temptotalB; The script saves but has the following errors when I run it: Error details: Error in executing On Add Row script of Bin ID. Error. Error in executing For Each Record task. Error in executing Set Variable task.
All Requests report wrong HTML
As you can see from the attached picture the issue I'm experiencing has something to do with HTML escapes. It seems Zoho sends HTML link code (subject column) with < and > instead of < and >. This leads the code to be incorrectly interpreted by the web browser as plain text instead of HTML. Any advice to resolve this issue? Thanks, Marco
Best way to create Master-Detail Forms / Sub-Forms
What is the best way to create a master - detail form when a master has multiple sub-forms where each sub-form needs to be entered and maintained by a different role 1. Create a master form and then in the master form add sub-forms. Assign access rights for each sub-form based on roles. I guess in the form entry and the form report view this will show only those sub-forms assigned to a particular role when they are viewing it. Also in the Record View it lets you select the sub-forms to be added to
Accessing text of lookup field record rather than record ID
I've been working for several hours on trying to retrieve the String value of a record that I am accessing via a lookup field, but I cannot seem to figure out how to do it. Here is the script I'm using: RepresentativeItems = (Products1[Representative == input.Representative1.toString()].ID).getall(); Basically I want to be able to populate a subform with all of the product sales by a representative, which I will select from a drop-down list, as you can see in this photo: My problem is that when a
Published Report Permissions
Hi, When I set the criteria on my report to.. "Email" == zoho.loginuserid ..it works fine when I access the application, but when I publish the report and access that particular published URL, no records display. However, when I set criteria to.. "Email" == "me@myemail.com" ..all records with "me@myemail.com" are displayed. Why does publishing criteria work for a hard-coded values, but not work for system variables? This seems like a bug..
Error on add row script in subform
Hi, I am using a subform called Order_Details to enter the products and quantities on a Purchase Order form. In order to filter product availability by Supplier, I have written the following script which runs "on add row". itemlist = Winery_Supplies [Contacts == input.Contacts]; clear row.Product; row.Product:ui.append(itemlist.Winery_Product_Name.getall()); The script is filtering the products by supplier in the Product field but the following error appears when a row is added in the subform:
Permission Denied To Update Record(s).","code":2897
Using the REST API (I know where the documentation is : (https://www.zoho.com/creator/help/api/rest-api/rest-api-edit-records.html) to try to update a field on a record. Am getting a response with error 2897 - Permission Denied to Update Records. The view has edit permissions already. Here is the request url: https://creator.zoho.com/api/<owner>/json/student-record/view/myob_invoice_line/record/update/?scope=creatorapi&authtoken=<mytoken>&criteria=('ID = 1612333000001258123')&SYNCDATE=20140905Can
For a List type report is there a way to display/print only the totals rows?
For a report type of "list" you can group by certain fields. When you run the report it shows the grouping header row, detail rows and then a totals row. I want to display/print only the group heading and totals rows and not each detail row. Is there a way to hide the detail rows so that only the group header row and totals row displays/prints? For example we have a table that captures payments (receipts) from donors. This table (view) is linked to the donors table. On the donor summary by name
Can I randomly sort a view?
Hi there! I have a view / report listing potential penpals which is embedded on a website. People are more likely to choose the people listed on top of the list, which I think is based on how recently the record was added or modified. We would like every penpal on the list an equal opportunity to be selected, so we would like the ability to randomize the way the records are listed. Can this be done? Thank you! ~Reed
Zoho Creator - Zoho CRM Zapier link
I have a number of zoho creator forms. I have set up Zapier triggers to zap over the information to Zoho CRM. It works fine with a manual entry to the form. However, when I imported from a spreadsheet into one of the form databases, it failed to trigger the zap of data over to Zoho CRM. I have questioned Zapier and they can find no error on their end. They said "It appears that possibly the API does not support spreadsheet uploads". and suggested I contact Zoho support. I have not heard back from
Sort in For Each Statement
Hi All, I am using the Deluge "for each" statement in a script but I need to treat my records in a certain order. Do you know if I can use a "sort" statement within my "for each" ? It does not seem to exist. Any workaround ? Many thanks ! Guillaume
text field limit length
I have a form that gets filled out by a posttoUrl. Basic information , Name Address etc.. Recent changes in the data has my text field for zipcodes getting the zipcode +4 . I need to validate the text field is only 5 characters and eliminate anything after that
disabling a mandatory field
Hi, I have a form in which I am using the hide and show features to customize the form fields according to the selection made in a lookup field. This functionality is working fine, thanks to advice from the very helpful forum community. I have three fields in the form that are mandatory: -Vineyard -Grower -Lot Depending on the selection made in the lookup field that customizes the form fields through the hide/show feature, either: -Vineyard -Grower or -Lot is displayed in the form. For example,
Validate that file name of upload is not a duplicate file name? SOLVED
(FormName[File_upload == input.File_upload].count() > 0) doesn't seem to work. Neither did (FormName[File_upload.contains(input.File_upload) == true].count() > 0) Any suggestions? (And as usual any help will be greatly appreciated!) SOLVED IT: The problem with the above attempts was that ZC adds a unique string of digits prefix to the front of each File_upload field string to differentiate that file from files uploaded to other records which might have the same file name. The solution
Next Page