Track number of times form completed by each person
Hello, I wonder if anyone out there can help me. The nice guys at Zoho support have tried to help me but unfortunately it doesn't allow me to do what I need. I have two forms: 1. SERVICE USER DETAILS (name, address etc). 2 WELLBEING They are linked through a look-up field on the wellbeing form (last name, first name, DOB). Each service user will complete the wellbeing form a number of times over a period of months/years. Each time they complete the form, I would like it to capture that this
Linking fields and forms
I am creating a client database for my Dog daycare and i am running into a couple problems with linking fields and forms. I have one form called Customer info and this form has fields for name, Dog's name, number, email, Daily Credits and a sub form for vaccination records. MY second form is called Dog account/payment history. This has a look up field for Dog'ss name, a radio button for Checkin/Checkout , a payment field, and a Credit field. I would like to link a couple items: 1. I would like to
CSS HTML Image Holder Align
Hello, I have a CSS holder for an image but I cant align to the center I have the following script: CSS .holder { width: auto; display: inline-block; } .holder img { width: 30%; height: auto; } HTML output = output + "<div class='holder'>"; output = output + "<img src='IMAGE.jpg';/></div>";
using stateless form from data entry
I am using a stateless form for data entry (timesheet application) I would like to attach a file or image of the actual timesheet to each record i create with the stateless form. I know you can add a file with a normal form and copy it to another form when you submit.
How to show report from button onClick event?
Sorry, can't find this in Help. I want to show report for a particular month, selected by user. I create stateless form for month input, with Submit button; all works well. Now, from onClick deluge script, I plan to launch an existing report. What is syntax to do it? Second question: how can I send a parameter (month number) to a report, and how can I use this parameter inside report scripts, what will be a name for this parameter?
Is Hide/Show available for formula fields?
We're desiring to conditionally hide/show a set of fields, 2 of which are formula fields. All is OK except for the formula fields. The editor refuses to save, unless we comment out the 2 formula fields. The error is "Hide function cannot be applied for <fieldname>". And, "Show function cannot be applied..." These 2 fields have the "Show on Form" option selected, because we DO want them to show on the form. ...Unless they are hidden with the set of fields. (I am using the Deluge names for the
Data not properly exporting from ZOHO creator, what can we do?
I am using the free version of Zoho Creator and I want to export the assets list I created; however, a ll the data that is available in edit record, which we have maintained, is not exporting. It is only exporting the summary and is missing the title, purchase price, purchase date, rego, colour, year, notes as well as some blank fields. How can we resolve this issue? Thank you for your assistance.
Error occurred while executing the workflow
I'm getting this error when I execute a function "Error occurred while executing the workflow". The function reads a record and then creates records in several other tables. Does anyone know what error this message indicates?
How do I persist values in lookup field?
I have a timesheet application, where the field "Customer name" is a lookup in Customer table. The customer table will occasionally be wiped and new valus inserted. Unfortunately, this deletes the lookup values in the Timesheet table. How do I keep the lookup values? It is OK that the lookup values is not valid for old records, but new entrys should only use current rows in customer table.
Application Loss of Formatting
Me and several of my users have regularly been loading our creator app but instead get a format-less page. Has anyone else had this problem and know the fix? It happens with explorer, chrome and opera with several different user accounts and computers but never consistently. Sometime a refresh fixes it, sometime not.
Add a date restriction to a Zoho Creator date field?
Here's a quick video that describes my question. http://screencast.com/t/fb3oCO5JCHEc I want to add a restriction on the date field to not be able to choose a date unless it's three days into the future. Any assistance is appreciated!
Unable to hide/show field based on fetch data field
I have two forms: New Request and Request Status. In the New Request form, I have an AutoNumber field, then many other fields, including Request Type. Staff members are to enter info into the New Request form, then based on their requests, an email is sent to the appropriate Purchasing Staff member. Request Status is a stateless form, and I have the Puchasing Staff member entering the AutoNumber that they received from the New Request form email notification into this, which then auto-populates fields,
Tooltip on Forms not working
OK - maybe it's me, but the Tooltip function is not working for me. Is there a secret trick?
CREATOR work offline
In the future you have plans to increasing Creator to work offline?? Sorry for my english and tanks
convert single line field to rich text
After entering more than 10,000 records, I now find my single line field with max of 255 characters is not enough. Is there a way to covert this single line field to a Rich Text Memo field without losing all the already entered data ?
Inserting Comments into Free Flow Scripting
Can't find an answer to this, so hoping it hasn't been raised before. Whenever I attempt to add a comment in free flow, like this: //comment text I get a "null" error. It works in script builder, but I want to be able to do it within form definitions and so forth.
Auto-Fill text box
I am trying to autofill a text box based on what I have chosen in the above lookup drop down box. This is linked to another form. Form 1 - New Request Form - this has the fields Supplier and Manufacturer Code. Supplier is a lookup drop down field which gets its data from Form 2 (Suppliers form). Manufacturer Code is a text box which is supposed to autopopulate. I would like to choose a supplier in the Supplier field and have the Manufacturer Code auto populate in the Manufacturer Code textbox, but
Duplicate application
Hi, I'm trying to duplicate my application (penta-crm-11) but it's not creating another one. Pls suggest. --I have shared application to support.
Is it possible to bring auto alignment inside deluge scripting?
it is very difficult to align when we do free style coding
I cant see user permissions in my app
I tried to search in every corner of the CREATOR! In Manage Users for example or in Share settings, this option doesnt appear to me! I remender to see these options in the old creator but now a cant find! I wanna create a user with read only permission! Its simple but i cant find! I use a Personal Free Edition with some adds!
Create a Sales Order in Zoho Books from Zoho Creator
Hi, How do I create a sales order in Zoho Books from Zoho Creator either as an On Add -> On Success action? What script would I use. Thanks in advance, Siya
Auto Filling from the same field.
Hi! I have an application that can be used by both new clients and existing ones. The form has a decision box which when checked distinguishes the user as an already existing client. When this is checked a look up table is shown with all the existing clients, Once a client is selected I want to be able to auto fill his client information, Email, number, etc.. I am unsure how to auto fill this information when the information I need comes from this forms report. Thanks!
TIP: Using Deluge, create URL field with dynamic parameters such as record ID.
Using Deluge, create URL field with dynamic parameters such as record ID. After reading dox and lotsa forum posts, here is what worked for us just now. We're sorta new at this, maybe there are issues, or a better way. Our purpose was, on the convenient "pop-up" page that can display when on a report you click on a linked item's name, to have a linked field at the bottom for "Edit This Record". (A big convenience if you spot a need, you can edit it right away w/o going to a the different report
Data dump
Hello, Does Zoho offers the functionallity to automaticly generate a data dump for example Excel? No export from a report. We can use this data dump for intergration in a financial application we use. Greatings, Erwin Fennema
Alternate View in Report
In a list report I've a "customer" column field which links to the customers form, and when clicked shows the customer view (customer name, email, address, etc.,). How can I change this view to show aggregate data? Id rather see the number of purchases, total purchases, order history, etc.,
Mapping Look up Fields to Zoho Reports...
I tried to map fields from Zoho Creator to Reports.. For most part, it worked with the exception of the Look Up field.. I get a unique number ID for the customer name... ... Any tips on how to take care of this? Thanks
Sub Forms in reports
I am using a Sub form and i am curious what happens to the data when it is entered. I can not see it in the report and all of the data is reduced to some ID number. What happened to my info and how can i find the Sub form in a report. IS it possible to create a link to that sub form that will then open up the data added to the subform?
Multiple if statements in a formula field
I'm trying to figure this out with no success. Can someone chime in on this one? Thank you. FIELDS: QTY_Suspect is a number field Piece_Price is a currency field Suspect_Product_Disposition is a lookup field if (input.Suspect_Product_Disposition == "Sort at customer", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition == "Return to plant", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition == "Scrap at Customer", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition
Would it be possible to enter data into form using HTML Page?
Hi everyone, First of all, sorry for my english. I'm new to Zoho, just building my first application. A little help or guidance would be very much appreciated regarding my biggest problem so far. We are a dental lab and I'm trying to create an application for filling in worksheets. This is a section of our worksheet, the numbers are representing teeth Every square above and below numbers represent a field. Each field can contain 3 different values. (BG, K, T). I would like to create an HTML page,
How do I change columns to Row in a pivot table?
Hi all, Can some one help me in placing column to row I want to shift that to rows. Thanks in advance Venkat
Error with If then statement
I am having a problem with this statement. I am trying to populate the field Fee on my form based on the selection in the field Age_Group. if (input.Age_Group == "70 and Over") {input.Fee = 115}; else if(input.Age_Group == "13 - 69") {input.Fee = 125}; else if(input.Age_group == "5 - 12") {input.Fee = 25}; else {input.Fee = 0}; The error is Error at line number : 1 Number of arguments mismatches I searched the Forum and found a similar issue and put the semi-colons in but I am still getting
Adding current date when choose specific option of Radio button.
I have a form for a Dog day care that i work for. The form has a look up tab for a dogs name and a radio button with two options "Check in" and "check Out". I would like for each time i select "Check in" the current date and time is added to the Date_time field before loading the form and adding it to the report . I have been messing with the script and i cant get it down. I know it is fairly simple but the grammer of the script is not very easy to understand or set-up.
Help with sub form please
Basically I have a field called Documents which has a list of check boxes, when the box is checked it will show a date created field and a upload field. My problem occurs when I create a subform of my Documents form, when I run the application the subform will display all of the fields even though the code is set to hide. How can I make the subform work as intended ? Thanks! :)
Help with my subforms
I currently have a form called Documents in which I have several check boxes, when the boxes are ticked the code will allow for a date and upload field to be shown in the application. I would like to use this as a sub form but when I load the application with the Documents as a sub form it doesn't carry over any of the code. So all of the fields can be seen. It would be a big help if anyone could assist me with this problem. Thanks! :)
Date Field
Hi, I am currently having some trouble with my date field. At the moment I have my date field set to upon the form load it will fill with todays date, however this is all good for making a new user but when I wish to update and existing user it will only display the current date, not the original date when the user first became a new client. Thanks! :)
Sub forms in report
I am using a sub form and i am not sure what happens to the sub form when i view the report. In fact, once i enter the data into the Sub form, this sub form being called, "Vaccination Records", i am not able to access an of the information i have entered. I am glad i am able to add new lines that i have created to the sub form easily but all the data is lost, unless i export the report to excel. How can i get the Sub form to show up on my report, best if it was a link to the Info imported into the
Complex "Duplicate" warnings in Forms
Hi all and thanks for your understanding. i try to setup a Duplicate record warning when user input data in a form. I have three fields : "Item référence" : a no duplicate filed "Start date" : date of use of the item "End date" : date of end of use of the item. If I select for a second record a period inside the period allready selected for the same item, an alert prevent me of saving the record. Exemple : Row 1 Item1 - 01/01/2015 - 31/01/2015 : input accepted Row 2 Item1 - 01/02/2015 - 28/02/2015
LIvedesk pricing with zoho creator
Hi I just take out a business plan and discovers livdesk . I have a doubt about the cost : should register on top of a livedesk plan or business plan creator of enough?
thank you for your answer
Need to create Application "Call to Support".
I am using Zoho Creator for making an application "call to Support" which will create a ticket in Support. When the ticket in Support is closed, its status should be communicated back to Creator. Then, we will work on the same process with CRM. I have created form of Ticket. But I need to add auto reference number for each submitted ticket. How can I add this? After submitting this ticket, I need to show ticket status like open or close. How can I add this option to show ticket status? I need a page,
Can't open page editor (AGAIN!!)
I have an html page, and when I try to open the editor, the page hangs and never loads. The html pages still load, but I can't make changes to them. Anybody have any ideas? I have submitted to support already... Last time this happened, it was because I used "count" as a variable, which is apparently not supported. I got the ever-helpful troubleshooting error of "null". I have not made any changes since last time this happened. See that conversation here: https://help.zoho.com/portal/en/community/topic/can-t-open-page-editor#2266000005930001
Next Page