Delete record in two different form
I create this scripts to add records between two different form: if (input.Prestamo >= 0) { Add_Pay = insert into Pagos_del_Prestamo [ Added_User = zoho.loginuser Nombre_Prestamo = input.Nombre_Arbitros2 Prestamo_PP = input.Prestamo ]; } if (input.Prestamo <= 0) { Add_Pay = insert into Pagos_del_Prestamo [ Added_User = zoho.loginuser Nombre_Prestamo = input.Nombre_Arbitros2 Prestamo_PP = input.Prestamo ]; } Asignacion = insert into Asignacion_Mensual [ Added_User = zoho.loginuser Fecha_AM = input.Fecha
!!!!! deluge script just stopped working -- date not accepted as a valid parameter type
This method: string utils.getDateAsParameter(date inDate) { return inDate.toString("MM/dd/yyyy"); } stopped working on Thursday. When I checked creator had "magically" dropped the datatype of the inDate parameter so the method signature looked like this: string utils.getDateAsParameter( inDate) apparently undesignated parameters default to INTEGER type because all the methods that call this one failed with incompatible parameter types. When I try to save the method with "(date inDate)" I
Deluge expecting different data type
This method (below) has been working fine for 9 months. Last night it appeared to fail. This morning I just tried to re-save it and got "Mismatch data type for function 'getPreviousTradingDay' at argument index 1 expected data type TIMESTAMP found data type DATE " the method signature for getPreviousTradingDay is: date utils.getPreviousTradingDay(date inDate) void utils.doCMEUpdate(string commodity, date inDate) { clist = {}; if (input.commodity == null) { return; }
URGENT: Failure of embedded reports by user's geographic region
Since the Zoho server burp last week, most of my application is working fine. BUT, I've had 18 different reports out of our application fail to work as embedded tools in a very specific geographic region, Vancouver BC. Those same reports are working fine in other parts of the country (Calgary, Toronto) I've tried to recreate the same report and embed as new, same failure. I've embedded those same reports onto pages with other working reports, same failure. Tried using the permalink, same failure.
urgent - android mobile cyrillic fonts
hi right now in process of implementaion zoho creator mobile app for employees we use iphones and android mobiles and we use cyrillic (russian) in description. for android mobiles all works well but for some android mobiles there are troubles for russian descriptions _for custom actions only_ see screenshots all good some trouble
notification when access to app?
hi there are 2 managers who works with app how can i make temporary notification for manager when he accesses to application? it is enough simple pop-up window with text inside
No record found within criteria
hello, I'm looking up records in a form. Is there an expected response from the system if there are no record found? Here's my code: // Check to see if there are any batteries that need to be replaced. Battery = System_Batterys [ID = TempAssignedSites]; (TempAssignedSites is the record ID to look for) if (Battery.Battery_Replacement_Date <= zoho.currentdate.addDay(120)) { // If the batterys meet the criteria tell the
How to establish a relationship between a custom module and a contact record through deluge
Hi all, I've got a custom module built in zoho CRM that has a relation to the contacts module, so contacts can have 1 or more of this custom modules related to it. What I'm trying to do now is have a form in zoho creator create one of these custom module records, and link it to a contact. I've tried using .put("CONTACTID", xyz); and .put("Contacts ID", xyz) and other variations thereof, but nothing I do seems to work. Any ideas?
Report Summary field and label colours
In a report summary how can I quickly set all the labels / field, borders and backgrounds to white?
changing font color
I want to add a check box field which when checked will change the font color for the record. Is that possible to implement?
How to I autofill a field?
Hello I am creating a form and there is a section called SKU that is a search bar so i have to search for a part number and select one. Below I have a section to add the urls of the listing I created for that Item. How can I auto fill on the opposite side the urls that I have already submit to avoid doing double work. Example Sku: W10130913 URLS Amazon _________________ Amazon __________________________________
Permissions, Groups, and Customer Portal
I'm operating an events system. I have a system of teams which consist of managers and employees. If I assign an event to a team, I would like that team's managers and employees to be able to read and update that event, in addition to creating, reading, updating, and deleting their own events between one another. As I create and dispatch the majority of events, I should be able to see all events (administrator). I would care to only maintain one list of events, I do not care to create a report for
Accessing upload field from external website
I'm looking to post image upload field to an external site. I need to export images and signature fields via script to web-merge or another external software. I need to access the URLs without login or using an authentication token. So I need the actual link to where the image and signature fields are stored in the db. Any suggestions?
iCal feed throwing syntax errors with newline character
Hi I am trying to share my calender report with google calender using ical(using two fields Address and Datebooked), the Address is a multiline field, when this is added to the ical URL, google calender comes back with syntax error. I put ical URL through an online validator, and its is pointing to an error when there is an newline from my address field. When this is removed the ical feed works. Is it possible you can fix this by encoding the newline character so its readable in the ical format
Sort by date in a form
Hello, I have a Customer_Info form and an Inspection form. I have looked up the customer form where the assigned technician is assigned to that customer. The customer has an annual inspection which is due through out various times through the year. I have found all of the sites where the loginuser is the assigned technician for the site. then looked up all of the inspections that correspond to the customers account. I would like to sort the list by the inspection date, then put it into my drop down
Failure in mass-data-update using the migration tool
I am using the migration tool provided my Zoho Creator to do mass data updates, so I don't need to write functions to do it. But during the update process I got "data already exists" errors... of course "data already exists" because I am using the ID as the unique identifier to update existing records with data from my spreadsheet... any clue? ID field1 status seriqla 21677000010333591 dupe_48f86a66-e8e2-41d7-86a8-5263a83bd10b 120 100001 21677000010333595 dupe_48f86a66-e8e2-41d7-86a8-5263a83bd10b
Embed Form Field Params
Good day, I have an Embed Form in myCurrentApp, I want to prefill a lookup field in the Embed Form called Projecto according myCurrentApp projectname, I have this code but it doesn´t works. htmlpage Reporte_Horometros_Combustible() displayname = "Reporte Horometros/Combustible" content <%{ projectname = Project[projectcod = 1].projectname;%> <div elname="zc-component" applinkname="mantenimientoytaller" sharedby="czambrano1" formlinkname="HoursFuel" params="zc_Header=false&zc_SuccMsg=Project
Pivot table/chart system user data
Hi all. Is it possible to use system user data such as "Added User" and "Added Time" as fields within a pivot table or chart. Currently they do not show as usable field options. Thanks.
Pulling data from CRM into Creator using searchRecords
I'm trying to build a Creator application that will update CRM data using zoho.crm.updateRecord method. For this method I need the ID, and I am having trouble finding a good way of getting the ID of an existing record. I have tried using zoho.crm.searchRecords with the Email as a criteria, but I do not know how to then extract a specific segment of the response. Here's what the code looks like. I just don't know what to set CRM_ID to to get only a part of Record. Record = zoho.crm.searchRecords("Leads",
already defined of datatype 'BIGINT' but trying to update 'DECIMAL' datatype
I am trying to add in a simple piece of code but I keep getting this error Variable 'a14_current' is already defined of datatype 'BIGINT' but trying to update 'DECIMAL' datatype a14_current is a decimal field a12_allotted is a decimal field if (input.template08 == "01-Preflight") { a14_current = input.a12_allotted * 0.6; }
Passing Parameters in mobile form
Hi, I realize that the "#" URL notation is disabled in mobile form. I need to pass parameters to certain forms. Is there a function that will let me check the users browser? Otherwise, can you please do the auto-reconfigure of the URLs (changing #Form: to mobile-form) to include the parameters. Right now, it just crashes and burns (i.e. redirects to the app home) if there are parameters passed.
Inserting Notes Under Reports within a Page
I'm having trouble finding a way to add a note under embedded reports within a page. I'm familiar with adding notes within a form, but there is no form builder that I can see for pages. Any tips would helpful. Thank you
ZOHO CRITERIA in Zoho Creator
Hi, Is there any ZOHO CRITERIA function in zoho creator like zoho reports? I want to filter the records dynamically in pivot chart based on some conditions. Kindly assist me. Thanks Satya NHM
add date as a criteria in pulling records
Hi, How do you include a field in a form that is part of a "for each x in AssignedSites.sort()" - AssignedSites is a result of a list created by another "for each statement". I want to add a date reference in the for each statement to pull put dates within a range. Here is the code for each x in AssignedSites.sort() { xx=AssignedSites.size(); ThisSite = Customer_Info[ID == x]; ThisInspection = Inspections[(ID == AssignedSites && (Next_Inspection_Due <= Next_Inspection_Due.addDay(input.Fire_Inspection_Range)))
Combining single line text fields and autonumber field
I'm in need of combining 2 single line text fields and 1 autonumber field into a new field. The single line text fields just need to combine the first letter from each field together with the full auto number field. Example: Text field 1: Ext Text field 2: New Autonumber: 1234 Combined output into new field: EN1234 I found this example on How Combine 2 fields into One. But is is only part of the solution, I'm stuck on pulling the first letter only from the single line text fields. https://help.zoho.com/portal/en/community/topic/combine-2-fields-into-1
Report using 2 times the same form
Hi, I would like to build a report which uses 2 times the same form with different criteria. I have Form A with a one to many relationship with Form B. I need a report which extracts rows from Form B with certain conditions, that are linked to Form B (via Form A) with other conditions. Not sure if I am clear enough. Basically, in the report builder, I would like to see 2 times the same Form. I can't find a way to do that. Any idea ? Many thanks !
Dynamic Lookup
Hello All, I am attempting to build an estimating application. Within this application I need to have a 4 level lookup filter. For example, the user selects the material dropdown which filters the type lookup which in turn filters the description lookup which in turn filters the size lookup. How I am attempting to achieve this: The Material field is a dropdown list. I have a form (L2 Descriptions) which stores both the Material information and the Type information. I have a lookup field called
Fetch Record using Auto Number Field
Hi there I am new to Zoho and have successfully used the 'fetch record' to get fields from one form into another using Set Variable BUT, I am trying to populate a form using the AUTO Number field in the Fetch Record script., but it won't work,. I have made it work by using the ZohoID, but this is a big number, and would rather use the auto number which starts at 2014 here is the script that doesn't work (where incident ID is the auto number field ) IncID = Report_Incident_or_Serious_Harm[Incident_ID
API Criteria &&
I am trying to view & update through the API. It states that I may use criteria. I can get it working fine provided there is only a single criteria required, however I am trying to do this with 2 & 3 crtieria that must be met prior to the activity being undertaken. Specifically the API documentation states for multiple criteria - Example : (Name == "Jean" && DOB == "20-Jul-1981") So I have built this into the JSON array I send. It appears to be reading it and trying to act upon it but is returning
creating a summary field from another form in a report
not sure how to explain this, but here goes: I have a form called Items. Items contains two fields: item_name and item_price. I have another form called Master List. Master List contains a number of fields, one of them is a lookup to a third form called Room. Master List also contains a lookup field to the Item form, retrieving the item_name. I wish to create a report on Master List, grouped by Room, that shows the individual rows and gives me a total of item_price. However,when creating the report,
Conditional form feeding web-to-lead
I have a web form that walks users through a series of questions and essentially records the answers in their web session. Once they have finished, if they pass all the criteria, they are presented with a form that allows them to input name, email, phone and submit. The submitted form comes with the answers to the questions in the form of an email. Is there a way of doing this with zoho creator, or other means of doing a more conditional web-to-lead form?
Added_User not returning a name but a "numeric string"
I have several portal users who are inserting records into a table. I need, for an email, to list the users along with the records they have entered. I am trying to find the users with the following statement (or nearly). UserList = Table[TableReference ==SearchReference].distinct(Added_User); I have also tried UserList =( Table[TableReference == SearchReference].Added_User).getall(); with the same result. What I get in UserList is a 'numeric string' - looks a lot like a row reference ID to a table
Can not delete field / form.
The function getUsersTeam did once exists, but was deleted long ago. I continue to receive this error.
Publish URL?
All, I have a free Zoho account and have created a one-form application and would like to make it available publicly. According to this help page, https://www.zoho.com/creator/help/forms/publish.html, the Publish URL button should be available for me app. However, it is not - neither it nor the Embed URL buttons are available. Would you please help me figure out how to publish this app? Thx.
href help
Hi, I am trying to hyperlink a text "Website" with the URL . But something is wrong with my script so I am getting below result. Script : input.UPM_links = "<a href=" + TV_Station [ID == input.TV_Station].TV_Website + ">" + "website" + "</a>" ; could any please help me Thanks Arfater
Mandatory Field
Hi, I generated ID field is in Single Line so set as a Mandatory field.Its working no pblm but i want change that error line For Ex: Duplicate value found for "ID" how can i change this text .Its possible or not Please reply me immediately. Thank You.
Question share from list / consulta compartir desde lista
Español: Buenas me gustaría saber si existe la Posibilidad de compartir por medio de una lista armada . Espero se comprenda la inquietud y disculpen la traducción. Ingles: Good I wonder if there is a possibility of sharing through an armed list. I hope the concern is understood and excuse the translation recordUsers { email={user1@tes.com, user2@test.com........} (String) } recordItemShare { type = {"section, form, view, page"} (String) nameObject = {"form1, form2, section3, list1......"}
subform suddenly broken, need help please!
Hello! I’m having a problem with a subform in my application that suddenly started behaving strangely. There are four fields in the subform that are not working now. 1. 1. Event Name is a text field that pulls from the master form in which the subform is embedded. 2. Event Date is a date field that pulls from the master form in which the subform is embedded. 3. Event Type is a dropdown that pulls from the master form in which the subform is embedded. 4. Site ID
Url Image Field Deluge Update
Good day, I have a product catalogue, each item have a Url Image, I want to update the Url Value with Deluge when every new product is created, I use the same syntax to feed a url on a plain field but in the Url Image field nothing happens. iniciolink = "<a href="; mediolink = (" target=_blank>"); finallink = "</a>"; thumblink1 = "http://www.zhingenieros.com/zoho/productthumbnails/"; thumblink2 = ".jpg"; thumblink = thumblink1 + "1" + thumblink2; input.Image = iniciolink + thumblink + mediolink +
How to create a report that shows items with zero dependencies?
I am trying to create a report that has two tables (forms as they're called in Zoho), one table is Stores, the other is Accounts. The Accounts form has a field has a foreign key from the Stores table. How do I create a report that shows me how many Stores do not have a foreign key associated with data in the Accounts table? The MS-SQL equivalent of the results I would like to see in the report would be: SELECT s.Store_Name FROM Stores s WHERE s.Store_Name NOT IN ( SELECT
Next Page