Record Count for our application
Dear Sir, The following are the top most record consuming forms for our application. New order - 8150 Order Item 25903 Logistics 7704 Events 5735 Billing 8000 But our total records used was 49325, but the above alone comes to 54000. Pls let me know, what we are missing. Thanks, Anitha
Unable to update email content
Hi When I try to update the email in script builder format ...the following is shown No rows found for the table Form_To_SuperDO in this DataObject Does anyone who what the problem is? Regards Umar
Zoho Creator get records from SubForm error
Hello, I'm making an app in Zoho Creator. I have one problem with SubForms. The app is like this: I have one Main form, with SubForm in it. I have a html view where I load one record. rec = Main_Form [ID = input.ID.toLong()]; Now "rec" holds all the fields from the main form. What is the correct way to iterate though the fields in the SubForm. When I try this: subform = rec.Sub_form; I get this error: Form does not exist - ZC_SUBFORM_9 What I want to do is make a for each of the fields in the subform.
Unable to duplicate a form without data
I have a long, complex form with sub-forms. Attempts to duplicate the form according to the "How can I coppy/duplicate a Form?" knowledge base instruction lead to a "null" error (old builder or new). Suggestions? Thanks.
Fetch record using criteria based on a lookup field
I have two forms, one is report and a form called persons. Each report could be linked to more than a single person using a lookup multi-select in the form. Now I want to fetch all reports linked to a certain person provided that each person field int he report form most probably contains more than a single person (a list of persons). How to do this without iterating through the whole database of reports then iterate each list of persons?
Links
Am pretty new to this. Currently have a a jobs form and a wages form and report. The wages form has a lookup field to get the job ID from the jobs database and works fine. I want to create a link on the jobs form/report that links to the wages form and shows wages relating to that job. There maybe multiple wages relating to the one job. I currently have hard coded in a link using the Note field but want the link to populate with the job ID. I would like to do this from the jobs report and also edit
Connecting two forms through an alternate submit button
I have two forms that I want to "connect". For simplicity's sake, let's call them form_a and form_b. In form_a, I have a field that I want to retain in a field in form_b. Let's call these fields field_a1 and field_b1 respectively. They both contain the relevant Project ID for the same project. What I currently do is: Open form_a. Enter the Project ID into field_a1. Submit form_a. Open form_b. Paste the Project ID into field_b1. Submit form_b. However, I want to combine the steps 3, 4 and 5 into a
Zoho automatically generates single fields in on edit form action
Dear all, I have the following problem. As you can see in attached image 1 I have a form with some fields (I do not hide any field). Hotel Name and Year are two dropdown fields which fetch data from an another application. The problem is that when I click edit in the report it generates the attached image 2. As you can see there Zoho automatically generates two single fields below of Hotel Name and Year. Why this happens? Is there any way to hide these two fields because I do not need them? I wrote
Lookup field filter
Hello, I have a form called [Master Inventory] and among its fields there are a few in particular... Device ID Assigned To I have another form called [Work Order] which has a subform called [Work Order Subform]. In the subform I have a lookup field called Device ID In the subform when I click the Device ID drop down field I would like to only see Device IDs where the Assigned To equals a field in the [Work Order] parent form called "Installer". Is this possible? If so how would I do this?
Manage Users & Groups
is anyone else having trouble accessing the 2 pages for managing groups and users???
move form button?
Is there a way to move an embedded form button? I need to change the styling / format of an embedded form. I am using an embed url on my webpage and need this form to be formatted slightly different. Here is the published url of my form: https://creator.zohopublic.com/precisionsailloft/prod/form-perma/Boat_Selection/Q95daGBSWbGHdWV0a7tJOZKeqOVGOY2vJmD9yMCpJkXp9Bab6RDhyGbR9nMufdHGRwmNxYmppaYEPquNpr2MOwtC915shJP62D0F Specifically what i need to do is move the Search button up to the right of the Manufacturer
Deluge Script - syntax needed for reaching to another application
In the script below, how do I indicate that the Companies form is in a different application? if (Companies[ID == input.Company_Code].count() >0) { temp = Companies [ID == input.Company_Code]; input.CoCodeFetch = temp.Code; }
How are child records related to parent records when using subforms?
I am new to Zoho Creator and I am having a problem understanding the link between child records and parent records when using a subform. I want to be able to initially import the child records (rather than have to enter them all in the interface) and still have them display in the subforms when editing a parent record. I can only get the ones I enter directly into Zoho to appear in the subform. I import the child records with the correct ID for the appropriate parent record and they load into the
Relationship
Hi, I have created 2 forms 1 is Property Details another one is requirement details so i want to show property name in requirement details form
What does this mean and why am I getting this error?
Any help would be appreciated. I don't even know where to begin with this error on an Add Record script. See the screenshot please.
Aggregate Records
I cant see the result of "Aggregate Records" on html page view I already see this link https://www.zoho.com/creator/help/script/aggregate-records.html#Sum_Function I folow the steps of the link I have a form SaidasRomaneio that have a field Valor Here is my code: htmlpage Flow_Page() displayname = "Flow Page" content <%{%> Fluxo de Caixa<%Valor = SaidasRomaneio.sum(Valor); }%> Do not show de result of "sum" on page What is wrong?
Hide fields if not equal to
Hello, The fields below are on a form and I only want three zoho IDs to see them, all other zoho IDs hide these fields. I want to hard code these zoho IDs into the script. How would I do this? Payroll Amount Deduction Total Iram
Viewing records in the parent form even if records in the sub form gets deleted
Hi, In our application, we have a parent form NewOrder, and a sub form in that parent form, order item. If i select 4 values in the order item, these 4 values are viewed as 1 field in the parent form. but if i delete the records in the sub form, the field values get deleted in the parent form. Pls advice on how to proceed with, even if i delete the records in the sub form, it should be visible in a field in the parent form. Detailed step on how to proceed is very much appreciated. Thanks, Anitha.
Sharing Data between Creator databases
Is there a way to dynamically reference data from another database within the same account?
Return to Previous Form Code for Stateless Form button with mandatory fields.
Hi Zoho! I created a form and whenever I press the cancel button, it prompts me to enter the details. Please see image below: Note: I just put openUrl() in my DELUGE Script for the close button. Any help will be much appreciated! Thanks!! Joy :)
Why does this deluge script not work?
The script below hangs, and doesn't work. How do I fix this? I think the script is saying: show all rows from Groups where Group_Members.UserRecrodD contains (zoho.loginuserid) I want it to say: show all rows from Groups where Group_Members.UserRecordID contains (User.RecordID) list Copy_of_Groups_Report { displayname = "Groups I belong to" show all rows from Groups [Group_Members.User.contains(zoho.loginuserid)] ( Company CompanyViaFetch Group_Name as
How to automatically add another upload doc field after one has been uploaded
Within a form I am creating, I want to know how do I let the system automatically create another File upload field after a document has been uploaded. In addition, if the second doc also uploaded, system will create a third blank field for further uploading. Thanks for your assist.
data from form to pages
how to access data from form in pages?
user permission
i maintain a client database. i want to allow uers to edit thier data alone. not others. how to do it/
Show checkbox in view, versus true/false
How do I change the view to show a checkbox instead of true/false for a decision box field? I have a test view that it will work with. But my main form view will only show true/ false.
Issues with Button in stateless Form
After recent changes in creator user interface & modification in application, I am finding that I am unable to pass any value to stateless form field through deluge code written under an action button. Example : I add a field named Message in a stateless form , I also add a button called say " Show message " and under this button i write code Message=" This is test message" When I press the action button, the field does not get the value and does not show on the screen. It use to work well in the
password field
i want to allow password field in my form. how to do it?
location search
I am looking for an app that will allow me to search my database for customers that are located within a 100 mile radius of a zip code that I enter. Please respond if you know of a way to do this using ZOHO.
Attach a document stored on ZOHO Creator to an email
I have a form to upload PDF files to ZOHO Creator I have another form with client name, address and email address I have a 3rd form that does a lookup on the client name to get their email address, and capture further information about that client Is it possile to be able to select a document (from a browse or drop down list) previously uploaded and stored in ZOHO Creator and attach that document to an email to the clients email (from the lookup field) when the SUBMIT button is clicked on the form?
Force Edit in Report?
Hi, I think this has been answered, but I could not find it. I have a field in "FormA" that uses data from "FormB". When I create a new record or edit a current record in FormB, script executes that updates the field in FormA, but it does not show up in the report unless I do a manual edit in the report. Is there a way I can force an edit or otherwise update the report? Bruce "Speedy G" Peaslee The World's Fastest Programmer
HTML in Formula Field
Today I found that my lists which include values with hyperlinks (such as quick reply) are being displayed incorrectly. I have been working on other modules today, but found this specific behaviour to be happening - as of today - to all of my lists displaying formula-based fields. After reading the forum I found that - for security matters - deluge scripts should be used instead of HTML. I have tried to restore a backup from 13 hours ago, but that process threw an error. Could someone please help
Working with multiple applications
If I'm understanding correctly, I can have multiple applications which share and use the same forms (where form is equivalent to a table, or object). This is great, as it helps me organize my thoughts and keep 'modules' of my leggy master application separate and distinct. Is there a way to create a page/screen that links the applications together into a menu? Or is that the generic zoho.creator/home page?
IF Statement in Conditional Formula Expression
I have looked at all the forums and support docs and still am having trouble with this. Currently I have several formula fields that calculate a discount based on the input of the general price. Here is an example of the current working formula expression: ((General_Ticket_Price * 0.1 - General_Ticket_Price) * -1) But now I have a request to have different discounts based on the type of event. For instance IF input.event_type == "workshop" there would a different formula expression than IF input.event_type
Finding all locations that call a function
I think I must be missing something, but I cannot find a way to get a list of all the locations from where a function is called. I used to get this list of locations by changing the name of a function and then saving it - and Zoho would tell me all the places I needed to make the change. But now it automatically changes all the calls to the function - which is good - but I've lost that useful feature. Is there another way to get the information? Thanks Alex
Hide/Show Fields in Stateless Forms
Hello All, Is it possible to hide/show fields on a stateless form based on conditional criteria (user checking a decision box) just as you can on a regular form? Thanks, Adam
Can a form have mutliple related sub-forms?
As the question says - if I have a parent form, such as CITY, and there are related forms (such as Restaurants and Hotels), can the City form have two sub-forms? One for restaurants and one for hotels?
Syncronize fields on multiple forms
I have two forms set up, and I need two of the fields on both forms to always be in sync. For example: Form A: Due date: 1/1/2014 Form B: Due date: 1/1/2014 I need to set it up so that when I put in a due date in Form A, it automatically shows the same data in form B. Thanks
Updating the value of a field in one form, based on the completion of another form
Here’s my scenario and my request; I hope you can help me. My organization does community outreach events, and I’m building an application to track them. When planning the event, we will use an “Add an Event” form, which will record the details onto two reports: a list of events, and a calendar. When the event is over, we will use a “Record an Outcome” form to record what happened at the event. (There is a lookup field in the “Record an Outcome” form, which lets you select any of the events that
Need report to list Table A records with no matching Table B records
Hi I have two tables: Table A (Jobs) has Job Number (Autonumber) and Job Name (single line) Table B (Visits) has: Lookup on Jobs (Job Number) Visit Date/Time I need to create a report that shows all Jobs where there has not yet been a Visit linked to it, but I can't see how to do this in Creator. I can see how to report on visits and link them to Jobs, but cannot see how to reference Visits (or the lack of them) in a report based on Jobs. I have attached a Deluge Script export of a simplified version
Insert an AVERAGE or AGGREGATE Total in a report?
I have a Report Grouped as above by Facility Name Employees enter a STAR RANKING 1 to 5 to rate each facility Is there anyway to show the Average ranking for each facilty in the report as shown above?
Next Page