How to modify mobile views
Hi, I asked this yesterday, but maybe something goes wrong because I can't see my question in forum, so I ask it again: How to modify mobile view of the report? I have 2 fields in my report and I would like to see them both in same row. 'Edit' and 'delete' commands should also place in same row. -Toni
Send automatic email
I wish to send automated email when you register operations. if(Proyecto1[ID == input.Proyecto1].count() > 0) { x = Proyecto1[ID == input.Proyecto1]; //input. refers to fields in current form Email=x.Email; sendmail [ from:zoho.adminuserid to:input.Email subject:"Subject of the email" message:"Your message" content type:HTML ] } I have done different methods used en the same a fetch mail, etc. I could not send mail. I want to know as how to send an email to a client of a lockup or fetch.
display particular name's profile
i am creating a member details management. in view it displays all members details. if i click a particular member name i wnt to display his profile alone in the page how to do it?
The Creator API is Broken... Again.
I think your API is broken again. Test data1 = postUrl("https://app01.nutshell.com/api/v1/json","{\"method\" : \"getApiForUsername\"}"); input.ResponseBox = data; So what this tells us is that the postUrl method is broken. Can you guys fix this on your end?
Update lookup field using Script Builder
Hi, I need to update a lookup field value based on the value selected in another field, how can I do this? Thanks.
Creating events in Zoho Calendar using Zoho Creator.
Quiet simply, how do I do it? I am having trouble finding the information. Any help would be greatly appreciated.
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
Embed database in webpage
I am trying to embed my databases into several webpages. Seems to go okay. I note that although all of the databases are marked (or not checked) to prevent anyone from making changes, when I embed in the web pages and publish, some will only have the SEARCH option for viewers (which is what I want), but a few will also include the ADD option, which I certainly do not want . And this ADD function will actually add to the information. I don't see any thing different in the makeup of those databases.
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.
Transfer Form Data to External Form
Hello, I have a typical form, where I add my student's data: name, email, phone address etc. In an external website, I have to copy-paste the above student's data one-by-one in a form, in order to apply to an organisation to acquire exam date for my students. Imagine that I have 50 students with 10 fields = 500 copy-paste actions. Is there any way to bypass this procedure through a function (maybe) or another action I can't think of. Thank you!
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.
Search Engine vs. Web Page
I want my databases to be seen and found thru search engines. But they don't seem to appear or if they do are way down in the relevance order. Will I have better luck with them being found as stand-alone databases or as a part of a web page ? My web sites all score high in the search engines.
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:
Record Level Security & Permission
Why I already upgraded to ENTERPRISE USER still can not use this fuction ?
Transfer data to and from web site
Can someone help with some logic please This is all an example of what I am trying to do So my web site has a line that says "hello I am a x" On my database I have the following fields Number Hello I am a Code in on user input in Number is if(input.Number = 1) { input.Hello_I_am_a ="Dog"; } if(input.Number = 2) { input.Hello_I_am_a ="Cat"; } if(input.Hello_I_am_a = "") { Number=1; } if(input.Number = 3) { input.Hello_I_am_a="Mouse"; } if(input.Hello_I_am_a = "") { Number=1; } if(input.Number
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
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
Next Page