I cannot duplicate an application in my workspace
Hai I cannot duplicate an application in my work space . Can anyone clear this problem?
Regarding the update of my dash board
i had the total salary data in my forms a dash board to display the monthly wages of each department every month and total wages of the every department in a month
CUSTOMER PORTAL EXAMPLE
Hello, anyone has an example of "Customer Portal" made with creator? I want to try it.
Application Design Help - Delivery Driver
I'm trying to work on a delivery driver application. We have 13 AM drivers and 8 PM drivers, they deliver to pretty much the same buildings ever single day (i.e. repeating / automated daily records is a must). There are some variances (quantity, additions, subtractions, etc). As a driver leaves our production facility they check out their truck and their product. Once they deliver the product the need to update the building as delivered. I need to keep records of all of these deliveries. What
Can't drill down on published pie chart
Hi Everyone, I published a pie chart report and send the url to an email. When the recipient clicks the link the pie chart is displayed but they can't drill down. When you hover the mouse over the pie, the tooltip doesn't say "Click to see the data". I have a basic plan. Is there a restriction on that plan that does not allow drill downs on published reports? I can do it from the creator though. Here's the report: https://creator.zohopublic.com/rleiman/vacation-requests/report-perma/Days_Vacations_were_Taken/x8mBtFXOz4qMXyH4YnX3b5h3nAbg32mBxHE28R3p5DqfYVnCVXfH4UxtzYDVsUYkZQd36yEPM4QqjsVsW5Wuaaj9hsUHRgju9xzV
Work-around for working with Bank Account details
HiI believe Zoho Creator doesn't allow storing of sensitive information like bank account details in its forms. But most of the applications I'm building (e.g. vendor management, payroll) would be incomplete without bank account details. For instance, how can you claim your payroll application is complete if it can't generate a report containing the following basic fields- employee code, employee name, net amount payable and bank account details. These are the minimum information a bank would need
Avery 5160 Mailing Label Support
Hi Everyone, We are evaluating Zoho Creator and want to know if it has support for printing to Avery 5160 mailing labels or exporting to a PDF using the 5160 labels layout and positioning? We plan to print names and addresses to the labels. Thanks in advance. Truly, Emad
Year view for Calendar report
Please implement this feature! A year view for the calendar report!
Photo Metadata
Hello! Is possible to keep the metadata of a photo when is uploaded to Zoho Creator? What i need is to obtain the GPS coordinates of where the picture was taken. Thank you in advanced, Regards!
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
Using URL to fetch record and open in a stateless form
Struggling with a stateless form problem. 1. Public - stateless form 2. Form includes a lookup field; that once a lookup item is selected the record is fetched and the fields load with data. r = Vendor_Dispatch [ID == input.Vendor_Dispatch]; input.Description = r.Description; input.Open = r.Open; input.Close = r.Close; input.Start = r.Start; 3. URL to form has the lookup field at the end with the lookup ID https://creator.zohopublic.com/USERNAME/APPNAME/form-perma/Vendor_Invite/ENCRYPTIONKEY?Vendor_Dispatch=3080649000000690931
linked lists like in CRM
Hi all! Please, help me with one issue. I want to create linked list in Creator with algorithm like in CRM. I mean that when I create record in related list using it's own form (analog in CRM - creating Deal for Account using module Deal), I want to see this related record in main record's form after saving. When I adding subform to form, relations added only if I create record using this subform. If use the main form for the same operation there are no relations between main and subordinate records.
Zoho Creator + Zapier
Hey guys, I'm trying to write a Zapier hook so that I can import data into Zoho from other sources. The limitation of Zapier is that they only support sending JSON for the post body (ie {"authtoken" : "MY AUTH"} ). I don't see any sort of Zoho API that accepts data in this format. Am I missing something or does Zoho not support POSTing JSON? Thanks
Mail Merger with Writer
is it possible to do a mail merge with documents sitting in zoho writer?
Custom Action Edit Function - Not Getting Saved
Hi, I have created a leave application app. In the report , I have added a custom action for leave status ( pending , approved) . I need to send mail based on the approval . I try to edit the function page , but it is not saving. I have attached the screen shot of the function Edit option
I could not add record for lookup field via another form.
I could not add a record for lookup field. It's shows error message Error in executing On Add - On Success script. Due to invalid expressions insert statement is terminated Line:(2) Error on inserting the value for field 'Service_ID'. Given value '4' doesn't exist in 'Add_Service' form Line
Passing parameters to edit a specific record in embedded form
I am creating a dashboard for a customer portal in which I want to use the current logged in user (zoho.loggedinuserid) to find their corresponding customer account record and display it for editing after they log in. However I can't get the syntax correct. Here's my code: ******************** htmlpage Home_Page() displayname = "Home Page" content <%{ if(Boat_Owners[record_loginuserid == zoho.loginuserid].count() > 0) { //Display the Boat_Owners form so that the logged in user can fill it out
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!
What is ui means ?
States:ui.add(statelist.ID.getall()); Here what is ui mean?
Can the 'Show/Hide Columns' option be shown or hidden in the url
Is there a switch in a url that will enable or disable the Show/Hide Columns option? In some reports I want to start with only a few fields and let the user choose the additional columns they need to see. In reports available to my customer portal users the 'Show/Hide Columns' option does not show. For some reports I need this option.
Fetch Data between different Applications?
Hello, When I fetch data among different forms in the same application, everything is ok. I am using: if(input.Project != null) { dat = Project[ID == input.Project]; ProjectName=dat.NAME_OF_THE_PROJECT; } But when I am trying to fetch the same value in another application, it's not working. I am trying the below code: if(input.Project != null) { dat = Project_Management.Project[ID == input.Project]; ProjectName=dat.NAME_OF_THE_PROJECT; } But it is not working. Can you please help me. Thanks Mustafa
Error in Fetching Data From Another Application - In Zoho Creator
I have written function in Application 1 to fetch Data from Application 2. The data passed and returned are in map format. i) I always get null values from Application 2 though the script and data passed from Application 1 are accurate. ii) But when the function in Application 2 Executed directly it gives correct values. App 1 Function: void retrive_from_Apptwo.retrive_information(int uniqueID) { product_information = Map(); product_information.put("UniqueID", uniqueID);
Content-Type is header not set correctly
I am attempting to update a contact in Google Contacts with postURL. It fails with error code 415 which seems to be connected with the content type. The Google contacts API requires atom+xml content type. I set the header for "Content-Type" to "application/atom+xml". API = gAPI [Name = "Contacts"]; header = map(); header.put("GData-Version", "3.0"); header.put("Authorization", "Bearer " + API.Auth_Token); header.put("If-Match", "*"); header.put("X-HTTP-Method-Override", "PUT"); header.put("Content-Type",
Library Form - Book Issue Return - Synchronisation -Stock upadtion -issue -Return
I have 3 forms for library management - 1) book stock entry 2) Book Issue 3) Book Return book stock has fields like bookId , bookname ,author etc , In bookissue form I am fetching, bookid , memberid as lookup values . when a book is issued to a member the respective book is subtracted from stock and the report shows the details of the member and the books taken by him or her . in book return - when a member returns the books it has to be updated in the stock . (each member is allowed only 3
there Should be a Button Field in the Form Body
it will be good if there's and button field in the form body , it can help in the type of form where an algorithm has to ran or a calculation has to be done on user input more often. like in quote calculator form I am developing , I use decision field right now , which seems inappropriate , since whenever user click calculate, after performing the calculation I have to uncheck the field via script to make it clickable once again due to which it runs the user input script once again. it would be
Unable to use GRID VIEW in a report although no client side Deluge Script is configured in the form.
As title says, I'm unable to use GRID VIEW in a report although no client side Deluge Script is configured in the form. At least none that I can see. Anyone would know how to solve this or how to troubleshoot?
update form from another form
Inventory system. I have a form/table containing (among other fields) part number and quantity on hand Three scenarios which I guess would be handled with a series of if statements. 1: New part is received from the distributor. 2. part is removed by a technician for use on a service call. 3. part is returned from tech to warehouse a. defective part which was replaced is returned to the distributor . b. part is returned unused and will be added back into our inventory on hand a separate form
Exporting files
When I export a view with attached files, the output contains a link to the files on Zoho but not the file itself. Can thsi be achieved any other way. I would like to be able to fully back up my data locally. Thanks Roy Watt
Print as PDF on Submit click
I would to like to print the record as a PDF when the user hits the submit button? I want the record to print as a summary, so that when the user opens the PDF record they can use a PDF signer to put a signature on the PDF. Is this possible?
How do I run the same functions for On Add and On Edit?
Hello, I have a bunch of functions/scripts that run when a new entry is attempted to be added to a form (i.e. On Add > Validate and On Add > On Success). I'd like those same functions to run when a form entry is edited (i.e. On Edit > Validate and On Edit > On Success). Is there a more elegant way to do this beyond simply copying and pasting all the functions? Thanks!
entry changes logging
hi! is there any tools to log each change for every record in zoho creator app's database? or may be there is some webhook functionality to send every record's change to other database? need to know info like "at field A - new settings are X, Y, Z" so - task is to send current new settings to other resource when this field is changed
update creator's entires by csv file
hi! There are number of entries in creator's app. Each entry has email field (and info plus text fields): entry1 -> email1 entry2 -> email2 entry3 -> email3 and so on.. And there is an excel file with emails and other info for each email. row1 - email1 - info1 - text1 row2 - email2 - info2 - text2 row3 - email3 - info3 - text3 and so on... how can I update entries in creator's app using CSV file from excel? so that entry1 will be updated with info1 and text1 (email1 <-> email1 are equal in app's
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
Dynamically updating field title text
I need to create a simple Form which has two single line text files, let's call them "Name" and "Response". Initially the "Response" field must be hidden. The "Name" field must give the prompt "What is your name?". As soon as the user enters a name, the "Response" field must be shown, and the prompt for that field must be "Hello <Name>, how are you today?" where <Name> is the value entered in the <Name> field. How can I implement this? So far, I've got both fields created and in the init script
Automatic
Hi guys, So i have a small problem. Sometimes i have 100 of products of the same brand, but with different serial numbers. So i have to input it separately. Is it possible for a field to remember the brand i choose previously ? For example : Serial num 001 Brand XLo (Input) Serial num 002 Brand XLo So if i have to do it manually for 100 products,it takes a while. is it possible for a field to choose the brand automatic, based on the previous choice? Thank you
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();
What's the best way to display aggregate data contained within a form?
Hello, I have a form that contains various data relating to my clients ("Clients"), and another form with information pertaining to my team members ("Team Members"). I would like to manipulate this data in order to provide KPIs that I can easily reference. There are three specific KPIs I have in mind at this time: Gross Income. This one's easy; it just needs to calculate the sum of the Gross Income field in Clients. Total Cost Per Word. This needs to add up the sums of Writer Cost and Editor Cost
Add PDF to email from URL
Hi, When a user books a course, I generate an invoice with an API call to our online invoicing platform. As a result from that call I receive the URL for downloading the invoice as PDF which I save in Zoho Creator. The next operation is to send an email to the user with the generated invoice attached. Adding a link in the mail to download the invoice is not an option, since the link contains our API token for the invoicing plattform. Is there a way, that I can download the pdf file to a File Upload
populating one subform data to same subform on next count
hi all, I have a form (Inwards) in which there is subform (remaining items on P.O). forget count 0 plz on count 1, subform add row i have populated count 0 data to subform which is working nicely on 2nd count, subform add row i want to populate (remaining items on P.O) to same form. i am using this script for 1st and 2nd count if(Inwards[Purchase_Order_Number == input.Purchase_Order_Number && Field_field == "Open"].count() = 1 ) { rec = inward_items_lookup[Inwards == input.Inward_Number]; i = 0;
Best way to plan a project?
Can anyone refer me to a best practices guide for planning a Zoho Creator (or similar) project out (i.e. how much you should plan a project out before jumping in, etc.)? I'm wary that I'm going about my project in a rather haphazard manner, but then I don't know any better.
Next Page