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
Are Creator Reports currently down?
I am unable to access any of my reports right now on Creator. Is this function currently down? Please see result from link below, which is one of my reports https://creator.zohopublic.com/fiscalservicesboe/bid-portal/view-perma/Bid_Portal1/d7w38RHSJT8xARafvT8DUXzetO7eBpHXEXjetu2NyxuEFs9KyYEjE71dtSQAMNkrBfNBHFs2DwGZNpHhG26jKxD6eAaf51jqH0wr: Can you please help with this issue?
!!!!! 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; }
email adres innactive
hello This morning I decided to check my mail info@klimaforum.net and email client gave me error . I went to zoho.com and when trying to login shows message "Account is inactive" I have not received a notification letter , that address will be deactivated. How can I activate your address again?!
Add Symbol cash to the result of a formula.
I need help with something and I have not resolved my doubts in a long time. The table above is in the dashboard, the hize starting from: todayExpense = Gastos.sum(Monto); thisMonthExpense = Gastos[Fecha in this month].sum(Monto); thisMonthSales = thisapp.checkNullNum(thisMonthSales); todaySales = thisapp.checkNullNum(todaySales); thisMonthExpense = thisapp.checkNullNum(thisMonthExpense); Gastos = Gastos.sum(Monto); GananciabrutaSP = Ordenes[Fecha_de_compra1
Error with iframe mobile
Hi Until a few days ago we were using the mobile form on our site in joomla and functioned properly. Now the modules do not appear. The code inserted iframe. is this: https://creator.zohopublic.com/rossato.group/contatto-generico/form-perma/Modulo_contatto_generico/fAp73ypfp2eQDqwEKWBBJJ7JOpjUv0dkKP5Ew1kxMMVnOeFRrO1bMgrZZwfb2A1PHTCxa7e2JNatKx8C3Cpwr2X2YWzDzWMbCrpE/ But if I replace "form-perma" with "form-mobile": https://creator.zohopublic.com/rossato.group/contatto-generico/form-mobile/Modulo_contatto_generico/fAp73ypfp2eQDqwEKWBBJJ7JOpjUv0dkKP5Ew1kxMMVnOeFRrO1bMgrZZwfb2A1PHTCxa7e2JNatKx8C3Cpwr2X2YWzDzWMbCrpE/
Creator Reports Links Not Working
Hi, I have two separate apps in Creator and the links to the reports appear broken. I'm copying the link directly from the "Publish" section and when I try to go access the URL for the reports, it does not work. The embedded links in my website also do not work. For example: https://creator.zohopublic.com/fiscalservicesboe/assignment-tracker/view-perma/Assignment_Tracker_Report/OHHwvjyukwTqC8RMY82yTw7NG7vKhQ8RuJh26aOQODnO0k2Oazm87pqChgywAG2zXdy7zK3SKfG3xYRVszNJHhtTQUBFBmTdz1K8 and https://creator.zohopublic.com/fiscalservicesboe/bid-portal/view-perma/Bid_Portal1/GjZ8XJxxORs9ehGUUHuMMgYWHE0a3JqVggYuKkGPQaNfJ1pPdrdSV4KHxTZnZtFaZxptH3BuYR0zjXDwH2amqQPWAknrvdUCpjv3
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
Can no longer update a creator form from Apple or Android devices
I haven't made any changes to my app, but I can no longer submit and post data from mobile devices. I used to do this successfully from Apple and Android devices. Now instead of getting a "data submitted" confirmation, I am presented with a "please wait" response that continues to hang. The application continues to work just fine from Windows 7 IE
Q: no. of records in free account
Hi, hope someone can answer this. I saw in one place it says the free account allows 750 records. But in another it says "3 users, 250 records per user". Does that mean that if I am just one user, I will only be able to manage 250 records? Thanks, Roy
1 user?
In continuation to my earlier question - My situation is I only need 1 user, but to manage roughly 700 records. I thought I would go ahead and subscribe to the basic plan, but the I saw there is a minimum of 4 users? is that the case? i.e. I have to pay $20 per month minimum? Roy
Frequency Chart / Histogram
Is there any way to create a chart/pie graph displaying the percentage of times a response is recorded? For example: Yes Yes Yes Yes No Then, create pie chart displaying: Yes = 80% No = 20%
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
removing edit ability on public share
New to Creator but have created an online data submission and using the public share so I can have the data be viewable online. Awesome tool! However, I do not want general viewers to be able to edit/ delete data and cannot find function which allows a public view w/o public edit rights? Any ideas/ help? Thanks, Eric eric.c.seto
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?
How can i fetch the products in the qoutes modules?
Is that possible? if yes? can you give me some idea since products in quotes is not a field? im no sure Please help me:(
Report Summary field and label colours
In a report summary how can I quickly set all the labels / field, borders and backgrounds to white?
Help with some code please
I have written some code to send to a web site to include in an embed statement on the web site. The code is if x = 1 { input.rep = "<meta HTTP-EQUIV="REFRESH" content="0; url=http://www.signedfast.mymomentis.co.uk/products-residential-uk.asp?CO_LA=UK_EN">"; } Trouble is because the line has more than one " in the statement it returns an error. How do I enter this statement into a field on creator. Thanks in advance
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
Remove box-shadow on Embedded Form
Hello, I just attempted to use the code found here (https://help.zoho.com/portal/en/community/topic/is-there-a-way-to-get-rid-of-box-shadow-on-embedded-form#2266000006342219) to hide the box-shadow on my client's form and while most of the code was accepted and used, I am still finding that the specific box-shadow value is staying the same as it was originally (box-shadow : 0 1px 2px #cdcdcd ;) and will not be overwritten, no matter what I code. The specific page is here: http://www.sharespace.co/practice/
how - move old entries from creator to zoho reports database?
hi need to move entries older than 30 days to zoho reports database there is synchronization in place i need exactly move functionality as scheduler in zoho creator oк zoho reports
Auto fill in fields on base from a lookup field
Hi, I'm new to Zoho. i'll build a form where the first field (name) is a lookup field (from the table Customers). When my users select a client. So far so good that's not a problem to build. The 2 (adress), 3 (zipcode) & 4 (City) fields must be auto fill with the data witch is also on the table Customers. And i don't know how to build that or how to construct that Can someone please help me with this. Kind regards Maarten
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.
Built-in Functions Broken
Really!
Next Page