Remove minutes from dates
I have 3 dates in my application. I do not need minutes on any of them. Is there any easy way to have those removed from the reports?
question on deluge script usage limit
Let's say I call a custom function in my html view does it count for 1 deluge script action and my script got its own usage limit or every line in my script count toward my html view script limit ?
Creator reports on iPhone
Hi I assume that the reason for only displaying 4 columns on a report on an iPhone, is based on the screen area, or lack there of. So I'll pose my question bases on that theory. It would appear that the report shows only the FIRST 4 columns, but the first 4 are not the best ones to show, but they are ordered like that deliberately as a logical sequence. Is there any way I can increase the. Number of columns displayed? Or select which columns to show and which to ignore. (or perhaps a workaround)
Anyone got experience with automatic printing?
Hi Does anyone have any experience with automatic printing/silent printing to a thermal label printer? Thanks Shaheed
Blocking fields from a condition
The users in the form have the authorization to update the data previously registered, but what I want is to fill a specific field, can not be updated or modified again, is this possible?
Copying content in other column of same report
How can I copy content of A column to Column B using deluge script in same report
One field is changed on the form when the other field changes
I am developing a form , where the change of value in one field will trigger the change of value in another field, in real time, as the user is entering data into a field and then tab to another field..... how can a deluge script be written to reflect this?
Lookup field to show dropdown value
What I find annoying is , in a lookup field, you can't even choose the value of a dropdown field on the lookup form?
Update Lookup field through the Rest Api call
Is there any way of updating the lookup fields through the REST Api calls..?
Formula with fields from a Lookup form
I need to use 3 fields in a lookup Form in a formula field.... this can only be achieved with a "On Add" or "On Submit" script... Is there a static way for doing this?
Embed Zoho Creator Form WITHOUT Iframe
Hello, Is there a way you can provide the code / script or otherwise that I may embed my Creator form into my external website without the use of an Iframe? Unfortunately Iframes don't render properly in Safari. A support request was sent in another post regarding the Iframe issue but I have had no resolution. Is there any other way I can embed the form? Thanks Emily
Multi-page forms
Could someone give me some insight into creating a multi-page form? It doesn't seem like that's out-of-the-box functionality, but is there a way to simulate such functionality through other means? I basically have a form, which is a bit long, so I would like to separate it into 3-4 separate pages. Ideally, I'd like the information from the form(s) to be stored in a single table to facilitate possible later edits. Searching through the forum, there seemed to be vague details about using subforms
Download all file attachements
Is there an easy way to download the file attachments for a table? I have a table with 340 records. Each record has between 1 and 4 attachments. Too many to download each one by hand. Any suggestions? Herb Wexler www.PreventingMediocrity.com
Update multiple records at one in Deluge
Is there anyway to get Deluge to update multiple records at once. A record in Table A has multiple records in Table B. Some data from Table A is replicated to Table B to speed performance. When Table A changes, I need to update all the records in Table B. This does not work Fetched_Records = Table_B[Key = TableA.key]; Fetched_Records.Field_to_Update = TableA.New_Field_Value;Other than iterating every record with a "for each matching_records in TableB" is
On Load set variable of User lookup field
Hi - I have a task form that includes a "Users" look-up field set to display the all user's Email Id. I'd like to set this variable to the logged in user but still allow the option to select another user manually if need be. Under workflow I have added the following code under On Load: input.User = zoho.loginuserid; However, it is not selecting the logged in user or anything else....any ideas? Is it perhaps because email addresses are being used instead of username? Thanks.
how to find a space or filled space
I have a column of data. Some are filled with 8 digits. Some are filled with 8 digits with spaces. How do I search for only those without a space ? Example: 22996218 or 22 996 218. I want to find all that have no spaces.
Changing Messages from ZOHO
How can I modify the "Data Updated Successfully" and "Please Wait". I have a slow DSL connection, and when I change the information in the database, the messages cover a large amount of the data and I am forced to wait until they disappear before continuing. I know I must wait until the change is actually made, but if I could see the data while it is being changed, I can be planning what to do next. I looked on the Internet with this question and your site says to open DASHBOARD and then FORM PROPERTIES.
How to add print button in creator
Hi, I am new to the creator. I am working on a form to print a copy of the same when I use the Print Button and also create a copy of the form in my system in some assigned storage place. I changed the name of Submit button to Print. Now when I am trying to add a rule or edit this button to perform print action, I am not finding any options here. Please help.
How do i export my Zoho calendar to my Google calendar
How do i export my Zoho calendar to my Google calendar? I found sync but that only brings in my google calendar to zoho. I need it to go the other way.
Field for hours and minutes
Hi. How to best create a field for Hours and Minutes? I want to have a field where I can input how many hours and minutes was used, then create a report that summarize the total time spent. Format for the field should be HH:MM Best would also be if I could write it in format HHMM and then the app auto insert the : between. Any one that can help?
Creating Custom Action Button
Hi Zoho Community, I'm trying to create a custom action button called "View Record" that does nothing more complicated than open a view of the particular record - exactly what you see when you click "edit" to that record. I am trying to follow this tutorial but I'm having a hard time understanding what needs to be done different to "view attendance" instead of "add attendance." Any help on either count would be greatly appreciate. Thanks!
Show Link Name instead of Title when viewing a lists of Forms, Reports, and Pages
Is there a way to show the Link Name instead of the Title when viewing a list of Forms, Reports and Pages in development mode? As my application grows, I am naming forms with a similar prefix to keep modules together. For example, forms that have to do with user management are named usrUser and usrCompany. I want to be able to look them up by these names when doing development, but I want my customers to see User and Company. What approach are you using to keep track of related Forms, Reports, and
criteria report last record
hi I would like to give as criteria in my report the following : [last_record_added = STOCK [(CLIENT== input.CLIENT && SUPERMARKET == input.SUPERMARKET)] sort by Added_Time desc; (last_record_added.TOTALBILL> 0.0)] is it possible to have this level of criteria in the report? How could I filter my report that way thank you
Automatic CSV Import/Upload
Hello All: I am attempting to set up a daily import from a local CSV file into my Creator Application. I have found the migration tool and understand the parameters. I just don't know how to edit the commands within the zohocreator.exe application. No doubt this is simple, any help would be appreciated. Further, I may be overstating my knowledge so specificity would be helpful. Dave
Remove Set Filter Limitation From Report
Hi - I have a form that collects employee names, and then a form that collects notes for each employee, using a drop down field for name pulling from the employee name form. I have used "set filter" to limit the drop down to active employees, which is set in the employee name form. I would like to create a report that shows notes on inactive employee with a filter by name. However, when I add the employee name as a report filter, it applies the same "set filter" limit so I only see active employees.
How to Make Pre-Filled Form to build an attendance register
Trying to build an attendance register for small manufacturing company - can be used for schools, hospitals etc. Up to about 30 names can be displayed on the same page, The default radio button is set to Present - most people come to work most days. The manager, supervisor, teacher explicitly chooses absent. I tried to do this with look up field in the form but could not succeed. This is a best approximation of how people work today. then ensuing reports can calculate attendance, pay, leave records
Pull Date from CRM
Hi there, I'm having issues pulling date data and auto-populating my Creator fields with it. I'm successful in pulling other types of date. Here's the code I'm currently using to pull data: crmResponse = zoho.crm.getRelatedRecords("Contacts","Contacts",input.Customer_name_ID.toString()); c=crmResponse.get(0); Email=c.get("Email"); Account_number=c.get("Customer number"); Address=c.get("Address"); Address_cont_d=c.get("Address cont'd"); City=c.get("City"); State=c.get("State"); Mobile=c.get("Mobile");
Changing a radio button to a check box?
I recently took over administration of an already created form. There are many instances where there is a radio button but I need it to be a check box so multiple answers can be chosen. Is there a simple way to change a radio button to a check box? Thanks!
Implementing global variables...sort of
One of the big gaps in Creator is the lack of support for global variables, i.e. variables with a scope extending outside a given bit of script. The usual workaround suggested by Zoho - creating hidden fields on forms just to store temporary data - is really ugly. Three reasons it's a bad idea: a) Even if you hide the fields from all but admins, admins do have to see them (it's a pain to issue hide statements in script all the time, too); b) they aren't truly global, but are scoped to that instance
Offline mobile app
Hi guys, Can i use my custom app offline on the Zoho creator mobile app? If yes, can i get a link please? Thanks!
Workdays Calculation
Hi everyone, I've created a function to calculate the number of workdays between two dates. I use it to measure how many weekdays have passed since a record in our action log was opened. Previously, I was using the function suggested here. But this function is recursive and after a record was open more than around 50 days, the stack limit would be reached. Have a look at my new function below. The only limitation I can see is that any holidays are not taken into account. What do you think? int
Sorting Lists. Airplanes and Trucks.
I'm attempting to display a single list of airplanes and trucks sorted by due date. Airplanes and Trucks are each different forms. What is the best way to merge records from many forms into an array and sort the array? Here is my attempt and the point where things go sideways. Maybe Keys can help but i'm not sure. What do you recommend? tx,tt //fetch records airplanes = Airplanes [Status == "Active"]; trucks = Trucks [Status == "Active"]; //create and fill lists vehicleIDs = airplanes.ID.getAll();
Search interface returning no records found
Hi, I have built a search interface from two resources: https://www.zoho.com/creator/help/tutorials/advanced-app-building.html#Create-sform https://www.zoho.com/creator/help/application/search-interface.html However it is returning no records found all the time, for any search text. below are my codes for the Search Page: htmlpage Search_Results(searchParam, sIndex, eIndex) displayname = "Kết quả tìm kiếm từ vựng" content <%{ recLimit = 10; if(input.sIndex == null && input.eIndex == null) { stIndex
Where are images stored?
Hi guys, Can anyone tell me where my images are stored? src='/platform/images/logo.png' id='zohocreator_logo' I want to replace this with my logo.
- or + until the maximum of
hello does anyone knows how to script x = input.1 - input.2 ( input.2 can't be more than 10) many thanks
I want to print the pyramid star, but i cant able to print. The value of i is increase when comparing to j
void star() { fruits={"mango","apple","banana","pineapple","watermelon","pomograned"}; i=0; j=0; for each rec in fruits { if(i<4) { for each rec in fruits { if(j<=i) { info "*"; j=j+1; } } i=i+1; info "\n"; } } }
Deluge script and on succes action
Hi all, I have 2 Forms "Buy" and "Sell" with 2 reports ("Available" and "Buy report") based on "Buy" and 1 ("Sell Report") on "Sell". Can someone help me with the code to Fetch the records of "Buy Form" to "Sell form"? i have a lookup field called "Model" , So i can use that to create a relationship with the forms, am i correct? as last, is it possible to have a "On success action" on the "Sell Form" where it takes away the quantity of the "Available report"? Thanks Guys!
Function
Hi all! I have this function: void order.toDelivery(Orders order) { status = true; for each recRow in order.Add_Product { product = Products[ID == recRow.Product_Name]; balanceQuan = product.Available_Stock - recRow.Quantity; status = true; if(balanceQuan <= 0) { status = false; } } if(status) { for each recRow in order.Add_Product { product = Products[ID == recRow.Product_Name];
Data in Subform
Hi guys, I have a subform where i can "add new records" and fetch records from a form to my subform. The first row fetches the record perfectly, but from the second row...it fetches nothing. This is my fetching script: for each rec in Available [ID == input.Product.Model] { input.Product.Supplierl = rec.Supplier_Available; input.Product.Date = rec.Date_Available; input.Product.Price = rec.Price_Available; input.Product.Stock = rec.Price_Stock available; } THis code only fetches
Script for addition
HI all, Can i get a little help pls? I need a Script that will do addition to Sub Totaal for every "Add new record"
Next Page