"Add record" to form does fill in its subforms
Good Morning Zoho! I have a main form with 3 subforms. I've managed (thanks Damien!) to auto-fill a few fields in the subforms based on entries on the main form. BUT- When I add an entry to the main form using "add record" on an "On Success" of a third form (hope I'm clear on this) - the subforms are not filled in - even though on the main form their default entries are set for "1" so at least one entry should be added.... Another thing - even a field in the main form that should be filled based
Script link subform back to form prior to saving record
Hi, I have a form with a subform, linked via bidirectional lookup so I can see or modify the associated ID's. i.e. The Form is for each Contact, with a Subform listing Phone Numbers associated with that Contact. Each Phone Number has a field showing the ID(s) of the Contact(s) associated with that phone number, so I can lookup both ways. This works fine. Now, I want to create a new Contact, and script to add a link back to a default Phone Number (i.e. all colleagues in the office have at least by
Set variable for a subform does not work?
Hi Zoho, I have a form with 3 subforms in it. I need the subforms to take values from the main form. When scripting with "set variable" under "on user input", setting the variable for one of the subforms' value (Subform.ValueToUpdate) , when trying to submit the form I get an error "unable to execute update record task". Off course, when loading the form the subforms are all empty. How can I fix this? Thanks Ravid
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?
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
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
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,
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
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
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
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 ==
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
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
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)?
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?
User Access Control
I have a user for my accouting person on my order management app. I'm using Standard Plan and only shared the reports to this user under "Settings->Share" She is able to edit "Orders" form in one report but not the other. See two screen shots. I don't see any setting in the two reports that control a record's editibility. Please help!
"Null" cannot be used in the criteria for a rule!!!
Hi, I would like to create a rule that if a value of a lookup field has not been selected then it will hide add entries of a subform. When I try to create the rule I get this error "Null can not be used in the criteria for a rule." Please explain how to create a rule for an empty value of a lookup field if criteria cannot be "Null"??? Thanks, Damien Cregan Hire an Expert
Return row number in table
Hi Zoho, I have an HTML page with a table. I need to get the row number in every row. How can I do this? is there a built in function or should I build on based on the number of <tr> in the syntax? and if so, how can I write it? Thanks!
How to make the values of a list wrap in reports (change value seperator used when rendering list)
In a Zoho Creator form, I have a value list (check box field) containing the days of the week (in French). When a record for that field contains a few or all of the 7 values, it looks like this : Lundi,Mardi,Mercredi,Jeudi,Vendredi,Samedi,Dimanche This rendering does not allow the content to wrap. How can I make this content wrap without having to include as space in the form before each value (not even sure that would work, but anyway it would be a silly solution). Basically, I would like the list
Question Bank application - randomise records
I'm setting up a database to use as a training question bank and want to be able to print out a report which chooses a random selection of questions from the database. Does anyone know if this is possible and how it might be achieved?
Zoho creator - add record api - permission error
I am trying to insert a record to a form. I am getting the error. Permission Denied To Add Record(s). - 2899. I am the owner of the application and I have generated auth token with my account. Any help?
list urls and href
Hi, I've created a map, with 1 value for each entry - a name Now i'd like to add for each entry on the map a URL - which will be "http://" followed by the entry's value under "name" Than I'd like to show on my page a list of hyperlinks: the text will be the name, and the hyperlink will be the URL attached to it on the map. Another option - to create to lists, one with the names and one with the urls Can you please suggest a syntax I can use? Thanks!
Understanding error log
Hi, What is the best way in understand error log such as the fllowing Error details: Error in executing ABclose workflow. Error. Error in executing IF rule : Error in executing If block. Error in executing IF rule : Error in executing If condition. Error evaluating Boolean expression : Error evaluating BOOLEAN expression : Error evaluating BOOLEAN expression : Error evaluating BOOLEAN expression : Accessing the value Finalise_actions.{1}.
embeded map variables from zohobooks
Hi, next is the style of response I get from zohobooks if for instance I look for contacts. {"name":"George", "Balance":"10.50"}, {"name":"Mike", "Balance":"5.00"} I understand this as embeded map variables (?).... My question is: how can I extract data from this data format. For example, how can I generate a list containing the names of each contact, in this case (George, Mike)? thanks Luis
URL in an email
Hello I am trying to send an email with an order to a supplier. I ad text end variables and it works great. But now I want him to confirm my e-mail. So I want him to click on a link in the email and end up on a page where he can confirm, decline in a drop down field with out being logged in to soho creator. Is this possible and how do I do this? Would be great to get some help! Best regards JB
Zoho Creator - Production Management
Hi, I am trying to use Zoho Creator for Production Management for a well known Material Processing Plant. In that plant, production moves in Phases and the materials are processed in Batches. For example, Phase - 1: Material is Issued for Production Here, I would like the Material Issuer to Record the Lot No and the Quantity Issued Phase - 2: Prcessing Here, I would like the Processing Manager to receive the Lot and Process it, and Record its completion Phase - 3: Finishing Here, the Final Aesthetic
Chain of Lookup Fields
Hi everyone, I am trying to make a chain of lookup fields across multiple forms. In other words: Form 1 = Company Names Field = Company Form 2 = New Leads Lookup Field to Company in Form 1 Form 3 = Work in Progress Lookup Field to Company in Form 2 The idea is that we collect as many company names as possible and make a database in Form 1 = Company Names. As the names are qualified they will get entered into the New Leads (Form 2), the company name being selected by a Lookup field
sum of variables inside "rowspan"?
Hi Zoho, In a table in an HTML page, I'm trying to merge a few cells (span on a few rows, depending on a previously-defined variable plus 10 extra). When I use <th rowspan=10+<%=entries_count%>>CELLTEXT</th> I get it to span on 10 rows (without the variable count). if I use <th rowspan=<%=entries_count%>+10>CELLTEXT</th> it spans on the number defined by the entries_count variable (not adding the 10) How can I sum the two inside the "rowspan" command? Adding () got me nowhere. (WITHOUT setting a
Subform lookup to main form?
Hi, I have a form with several subforms in it. I need the subforms to be connected to the main form when looking at the reports later on, so I've created a distinct variable for all the subforms to have (same as the main form). I wish this will be done automatically - the variable will not be visible to the users in the subform, but will take the variable value using lookup from the main menu. How this can be done? Thanks Ravid P.S - the option on having a subform within a subform could really help
Next Page