How do I copy the data from another Application
I use the lookup field to get the data from 'another Application' so how can I copy to new form -new field. (Like the pic) I need to get data '8' in cavity field?
Fetch oldest dates
Hello Zoho Creator Users, I have a question for a report functionality. I have build an object list for vehicles. Each vehicle must be periodically inspected for various points. The dates of inspections are known and are located in the future. I would like to make a report which shows the upcoming, most recent, inspecting date. I tried to filter the report, but I can only filter one column. I think I have to make a blanc field, and this field must always fetch the oldest date of all the fields with
Count of new rows in menu
Hi, can i do this? in my ZC dropdown navigation menu, is it possible show last new added rows in view? for example ORDERS New (2) Completed (0) Canceled "2" - the count of new rows in the table view. When i click the table view an then close, the count return to "0"
Formula field format
Can I format a formula field in the report? The field value is the subtraction of two currency fields, but the result is show as long.
Launch view with search criteria
Is it possible to launch a view with a deluge statement with search parameters? For example, I have a view with Contacts and want to launch from a custom action in another view only those contacts that comply with certain criteria (coming from that othet view). can this be done? thanks Henk
Sum when add specific value
Hi, I need create the script to sum $5 every $50 added to the field.
User privileges vs admin privileges
So far, We are using Zoho Creator with 1 same login I would like to set User Privileges 1) admin can do anything 2) Users - see, add and edit info 3) if possible : each user has access to his records (sales orders) depending of a code in a "user" cell in the form (example : the sales rep called LF can see only the records were LF is put in the "sales rep" cell) Is it possible ?
How to add a total ?
How to add a total down on a list with numeric field that changes depending on a selected records ? (dynamic total)
Custom Customer Proposal
Hello I currently have created a Form that collects information for a proposal (Customer Name, Address, Products, Price, etc). I want to create a customized Page that allows me to present that information to the customer. The goal would be to make it so that I can email the proposal to the customer for them to review what we will be doing. I can easily create a custom Page using either Rich Text or HTML but I am struggling on how to populate it with the information from a single record. Do I:
how to autocopy files from entry to dropbox?
hi how can i automate copying files from creator app's entry to my dropbox account?
Daily execution limits
Hi Zoho Creator Sales support: I have a problem with your daily deluge statement execution limits and email sending limits. I pay a monthly subscription fee why do I get daily limits? A monthly limit is more reasonable. On some days I do more development work than others so an aggregated monthly limit makes far more sense.
Daily limit for deluge statements
Hi Zoho Creator Support: How do you calculate the number of deluge statements? One database update per each record counts as a statement? I never figured out and maybe I need to upgrade my subscription? thanks.
iCal feed shows wrong time in Outlook
I created an iCal feed: https://creatorexport.zoho.com/pcmtrials/ctms/ical/RES_COL13IBD08_Scheduled_Visits/3hnaYV0dxFhCG0hR8qeavHf5PEzY0ay41XDtBsq7nrjPPkVkmpdVpERPKwfX3fJ7zpBpBFMktyGsUw3GPKMwQkXyhe5X8gh3EX6P/DTSTART=Visit_Scheduled&DURATION=1&SUMMARY=Site_ID_Subject_ID_Visit_ID When I subscribe to it in Outlook, the times are off by the amount of the offset for my timezone (Mountain Time). That is, a time in Creator that is 08:00:00 Mountain Time, shows in the Outlook calendar as 15:00:00 Mountain
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
Next Page