Relate a dropdown and several subforms
Hi! I am creating a form which has one dropdown and 5 subforms. On load the 5 subforms are hidden. what I would like to do is that when the user select a choice from the dropdown,the respective subform shows up. How can I do this?
USERS CANNOT ATTACH FILES - AGAIN AND AGAIN
AGAIN - MY USERS ARE HAVING DIFFICULTY TO ATTACH FILES IT IS THE THIRD TIME THIS HAPPENS ZOHO IS SUPPOSED TO OFFER ME A PLATFORM FREE OF THESE PROBLEMS
Copy Fields, Forms, Reports, Pages?
Is it possible to duplicate or copy fields, forms, reports, or pages? I can't seem to find this function, and I will admit that for "serious" app development, it seems like a must-have feature. If I would like to create numerous fields with similar properties, making small tweaks to extensive programming, then I have no way to accomplish this. (Likewise, for forms, reports, and pages.) If this functionality does not exist--as it does for essentially every other survey/database tool--then I must
how do I add ddrop down field to a number
Hi, I am trying to use a drop down to select the hour for a scheduling app. I don't want to have 24 values because that is way too many so I want to use an am/pm radio button to create a calculation that will give me a 24 hour clock. There is also a minutes drop down that is included in the calculation so that the final result should say 13:25 when the user puts 1 in the hour, 25 in the minute and selects PM for the radio selection I have an if statement that captures for the am/pm not being checked,
Delete record from html view, possible?
Is there a way one could delete a record from an html view? I currently have a loop that displays a list of records in a table in an html view. I have an edit link to edit particular records. I want to also add an html link that would delete a particular record. Is this possible? To edit a record I use the following: /<%=zoho.adminuser%>/<%=zoho.appname%>/Form_Name/record-edit/Quotes_Report/<%=main_record.ID%> Is there a URL I could use like this for deleting a record? Thanks, Matthew
Redirecting from one form to another in ZC mobile application
Hello I designed an application which is made of two forms, In first form a customer enters his personal details, and a zoho crm contact is generated for him. when first form is completed, user is redirected to a second form using OpneUrl his Zoho CRM Contact ID when customer has completed the second form the data from is appended to the correct customer Contact in zoho CRM. the forms are published in a web site so all is done via browser. Now, i want to let customers fill the form within the ZC
Column Width - both in report and in a page
Hi Zoho, In my reports, if I try to limit the column width using the Column Properties -> Change Column Width under the report settings, if the text in the column is longer than the width I've set the column width is changed to fit the text, instead of wrapping the text inside the column. Why? and how can I change this? Another thing - how can I set a specific column width in a table inside an html page? Thanks! Ravid
Pivot Table / Chart Not Showing Correct Record Count
I've been trying to work out this problem by myself for a while but can't seem to solve it. When I create a basic List report, I can see that the total record count is 2213 (which is correct). Although when I try to visualise this same data as a Pivot Table / Chart, the total record count is only 2000. For some reason the Pivot Table / Chart is not showing records for the last 2 months or so, as I don't have any filters to restrict the data that's being displayed. I've also opened a support ticket
How do I write the value of the autonumber field to a single line data field?
Hi everyone, I'm new to Creator, so please excuse the dumb questions... I have two forms, Person and Cases. Each form has two fields - Name and Client_ID. Person.Client_ID is an auto number field, but Cases.Client_ID is a single line data field. Cases.Name is a lookup based on Person.Name. I'm trying to update Cases.Client_ID on input with the value in Person.Client_ID, based on the looked up value in Cases.Name. When I compile the script I get the following error message : "Variable 'Client_ID'
postUrl not working
I am trying to post some data when the status field in my form is updated. I am using this code: result = postUrl("http://www.reviewill.com/zoho/ccnow.php", input.Price); In the ccnow.php: if($_SERVER['REQUEST_METHOD'] === 'POST'){ $req_dump = print_r($_REQUEST, TRUE); $fp = fopen('request.log', 'a'); fwrite($fp, $req_dump); fclose($fp);But when i update status field in my form, The post array in the request.log file is empty. I think zoho is not posting anything.
Creating a page "on add"
Hi Zoho, is it possible to create a new page through script? (I'd like to have a new page created through the "On add" - after adding a project, to have a new page created with the new project name on it) Thanks! Ravid
Stateless form read only field
Using a stateless form, how can a readonly field be displayed? I'd like users to be able to see a numeric field and a rich text field but not modify them. If I put the information in a Notes field, it can't be modified but it doesn't line up like the rest of the fields. This is for a survey. The numeric field contains the question number and the rich text field contains the question text. Thanks,
Convert JSON to XML for Related List?
Does anyone have a script example of converting a JSON string to an XML that is usable in a Related List custom function? Basically I want to display a list of cases from an external system as a simple table of 4-5 columns, ideally with a link. I can't even get the sample static XML (from the documentation above)to work -- the script editor just won't save it, maybe because of the quotes. Any help would be greatly appreciated. JSON snippet below (retrieved using getURL function): -- { "total_entries":
Using Or in searching
I have a table with a field called Fruit. I want to filter the report to show just records that contain Apples or Oranges. I am using a stateless form for the user to select the fruits from a list. Then an openurl statement is used to open the report. I know openurl does not support different values for the same field. Does anyone have suggestion on how to achieve this? I've thought about adding a special field to indicate the records that match the criteria and then displaying the records with a
Change font on sendmail?
Is there anyway to change the font used in a sendmail function? I am using sendmail to send out form entry summaries of single line text and date field on success. Currently the default font is pretty ugly, would like to change it to something more modern
FX formula
Hello (again)!! I got stuck trying to calculate a FX formula. The thing is I don't now how to make the proper expression. This is how I want to calculate ((Strecka1 + Strecka2 + Strecka3) * Perkm ) + (PALL * Antal_pall) + (Antal_kartonger * KARTONG)+ (Startkostnad ) How can I write the proper expression for this) Another question, is it possible to use defined variabels in FX formula? I make a variabel named rec12 and give it a value but I can't use it in FX formula expression? Its
Sendmail with PDF attachment not working today?
I have been using a sendmail task to attach a record summary as a PDF attachment for a long time, but all of a sudden it has started failing. Remove the attachment and it all works fine change the attachment command to 'as Inline' instead of 'as PDF' and it also works fine. The thing is this script has been working for nearly a year and has't been changed at all. And the record summary template being attached also hasn't changed. About 7 or 8 months ago I had exactly the same problem and Zoho support
Formatting error ? 'If' statement
I have Three Forms -Material_Type_Form -Material_02_Form -Material_Out_Form - Stateless there is a look-up field Material_Type_Field in form Material_02_Form, which gets its list from the form Material_Type_Form. The form Material_02_Form does calculations for material in, on hold and out and displays the total on hand in a formula field named On_Hand_Field, for convience there is a hidden field, OHH, which is a copy of the output of On_Hand_Field but in string format. On Material_Out_Form, the
Web Page Refresh Causing Problems
Hi, I have a HTML page, in which I have included a 60 second refresh (as a dashboard) <META HTTP-EQUIV="refresh" CONTENT="60"> But when I click on other views within the APP, within 60 seconds, the refresh kick in, takes me out of the view I was using and displays my dashboard ? Is this expected behavior ? Thanks Neil
how to add pictures to apps?
hi! how to add custom picture for each app?
Where is the ERROR?!
if (Passaporte_Diplomatico[BI == input.N_De_Bilhete_de_Identidade1].BI()!"0") { busca = (Passaporte_Diplomatico[BI==input.N_De_Bilhete_de_Identidade1]); } Please help me!!!
Sort a subfield
Hi, I want to be able to sort a sub field but there seems to be no options to do this, if I create a sort in the original report will the sub field also sort by the same criteria? Basically I want to be able to create a call sheet that list times that people do various things in a day. The order of things might change and I don't want the user to have to delete rows in order to insert information. Basically the call sheet form holds multiple subforms with different information. The shoot schedule
Best Practice for creating relationship between multiple forms
So this is what I am trying to do. I have a form: Modalities, that is just a list of names basically, Modality_Names. i.e. Massage, Acupuncture, Personal Training, Rolfing, etc. Second form: Company, in which there is a lookup field (Modalities_Selected) linked to Modalities and allows multi select. i.e. Company.Modalities_Selected would be a list like Acupuncture,Rolfing My third form: Service_Providers, needs a field so they can only choose from the subsection specified by the Company.Modalities_Selected.
Using "Yes" in a String
I want to have 3 conditions, most important is the "Yes" condition. Line 1 or 2don't work, but 3 does, but I don't have the "Yes" condition in example 3. How do I write the string? 1. if (((input.Billed != 0.0) && (input.Invoice_Email != null)) && (input.Resend_Invoice_Email == "Yes"))) 2. if ((input.Billed != 0.0) && (input.Resend_Invoice_Email == "Yes")) 3. if ((input.Billed != 0.0) && (input.Invoice_Email != null))
How to change web address path-name to reflect my updated username?
I created the zoho account with myname as superadmin username, I notice that the pathname is always show myname as part of the address path for zoho products even though I change/updated my super admin name from myname to othername. https://creator.zoho.com/myname/products-listing/ How can I change the path to reflect my updated username.
Help with Getting Data from Form/Report
I have the following in a POST action that works just fine .. <input type="hidden" name="criteria" value="ID=2907418000008392079"> .. and returns the following record/json response .. {"Form_Users":[{"Name":"Smith, John","Customers":"[Cafe]","Email":"me@me.com","ID":"2907418000008392079","Customers.Cust_ExtId":"[1187]"}]} My question is, how do I format my criteria parameter to return the record where Cust_ExtId = 1187 ? These are not working : <input type="hidden" name="criteria" value="Customers.Cust_ExtId=1187">
Using content of a record as deluge command/instruction
Hi all, I am using a Stateless Form trying to update the value of a record that has the same name in different Forms within my application. As my application will grow I want to make this process as simple as possible so I created a Form called "CatForms" (with only one field called "FormName") that holds the name of the Forms that eventually need to be updated.: The name of the field to be updated on each form is "recordtochange" I want to know if there is a way in deluge to do the following: for
Listen for changes to Zoho Creator remotely?
Hi, I would like to listen for changes to fields in Zoho Creator and execute an API call to get new records that were added after a certain date or time. Say, my program checks every 5 minutes for something new in Zoho creator and gets new records if any were added. Is this possible?
Return field name and/or value as lists
Hi Zoho, Can I create a list returning a form's list of field names, and another list with their values? for example, I have the following form: First Name David Last Name Jones Birthday 11 March 1986 Gender F Employee no. 12254 I'd like to return two lists: Field_Name === populated with: {"First Name", "Last Name", "Birthday", "Gender", "Employee no."} Field_Value === populated with: {"David","Jones","11
How do I Fix this "Error at line number : 0 Mismatch data type for function 'GetType' at argument index 1 expected data type BIGINT found data type STRING"
Good Day, I am trying to return a result from Credit field and I keep getting this message: Error at line number : 0 Mismatch data type for function 'GetType' at argument index 1 expected data type BIGINT found data type STRING I Don't understand because everything seems correct. Function: string externalapps.GetType(int name) { //GetType is the name of the function if (Add_Rep[ID == input.name].count() > 0) { //"Add_Rep" is the form link name return Add_Rep[ID ==
Member account can't read/write or see files in CRM
I have set up a second account in both CRM and Creator to test my combined applications. The second account (Victoria Joe) has standard permissions in CRM and in her profile is a member, but the software ays this is disabled. Basically my user can't access any records in the CRM, they don't exist in any way even though I have assigned contacts to her and while she can read creator records in both the native app and CRM she can not edit them. What am I missing?
Count the number of times a record has been used in a lookup
Hi, Is there a formula that I could use that would allow me to see how many times a record is used via the lookup field? Below is what I'm trying to create in each view. View 1 Task # | Issue Type Task 1 | issueA Task 2 | issueB Task 3 | issueA Task 4 | issueA *Issue Type is a lookup field where I select the type of issue from another view. View 2 Issue Type | Description | Count issueA | Broken Pipe | 3 issueB | Leaky faucet | 1
Error in dynamic pick list script
I was hoping someone could help debug this for me. I have used a dynamic pick list a couple of times now and it has worked but this one won't - it gives me an 'error occurred while executing on user input script'. So I have a parent form (Equipment1) that has Equipment in it - Type: Cameras, sound gear and lighting. I also have a name for each one Name: Michael's Z1p (which is a type of camera) in a radio button field. In the child table (Equipment_Link) I want to select the type: "camera" in a drop
Combining forms
Hello, could anyone help me? I need to make a report combining many forms (more than 10). How can I do this with Zoho? Thanks
create subfield picklist from data in a third form
Hi, I have managed to create a dynamic pick list from one form to another The form is a Crew booking form that is linked to a crew form that contains the contacts details including the roles they are skilled to perform. The script is on the crew lookup on user input //create a picklist based on related crewmember's skills rolepicklist = Crew[ID = input.Crew].Roles_Available; Role:ui.add(rolepicklist); it creates a list of roles available based on the crew persons skills. My problem is I don't use
zc_LoadIn not working for view-perma/view embed
Hi, I'm trying to open an edit form in a popup from an embedded page. It all exists in the same application, but the form will not open when I embed the page into another page using the "view-perma" to remove unnecessary menus and headings. Is there another solution for this? Thanks, Damien Cregan Hire an Expert
Merging Apps
Good day, I have a several apps within creator. I'd like to merge and/or use data from multiple apps, to create a data hub for my payroll department (meaning a centralized app). I would need certain fields from each in order to do this. What would be the process to achieve such an issue?
How to Group and Sort a report using parameters?
I have a page with a report on it. In the report I am using Grouping and Sorting from the Report options. My question is if there is any way to pass this 'Grouping and Sorting options' as parameters in the links. To make it clear, if there is any way to make Group and Sorting using parameters in the link (and not from the report options)?
Response field for records to be filled by a different user
How do I design this form / report scenario in Zoho Creator: I've created a form where User1 submits work requests. I can see the corresponding report. User2 is the one who is supposed to deal with these work requests so I want to create a way for him to tag every request as pending / complete etc. and also to add his comments if any. What's the best way to design for this workflow?
Newbie Question about Relationships
I have a table called “Students” and a table called “Class Instances” and want to create a table called Enrollments to marry up the students enrolled in the class. A class instance can have many students and students can be enrolled in many class instances. The "Enrollments" table would show those students enrolled in each scheduled class instance. How should I go about doing that?
Next Page