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
Mobile datepicker won't select February dates
I have a datefield in a form that has a problem selecting a February date on a mobile device. It automatically moves the date to the same day in March. Selecting a date in January or March does not show this behavior. There is very little code in the 'on user input' that just updates another date field: // update the end date row.End_Date_Time = thisapp.com.addDuration(row.Start_Date_Time, row.Duration) ; row.edited = true ; Selecting a February date using a PC does not have this problem either.
How to use api response string
How do you go about reformatting or getting values from an api response value? I used the Lead Convert method to convert a crm lead to a potential and create a contact. I get the following response: {"responseCode":"200","responseText":" \n710378000007272009<\/Contact>710378000007272011<\/Potential><\/success>\n"} How can I use this response? I know that 710378000007272009 is the contact ID I know that 710378000007272011 is the potential ID But im not sure how to get these values out of the
How to import data in a blank subform?
I would like to ask you if there is any way to import data in a blank subform. I have the following excel file I created a form with a blank subform like the following (with exactly same field names) then I clicked the Import data (it shows that everything is ok) but in the report shows me 3 empty records. Why this happens? How can I add these 3 records in a blank subform and to show them in a single record in the report (as we know, whatever we add in a blank subform it keeps it as a single record)?
Notifications from form entries not being sent
I set up the contact form to email me and it does not.
Scheduler substituting variable for Added_User
When I run the below code from the scheduler, it ignores the value for UserName and inserts the UserName for the Admin user. I should point out that this is part of a function that I am calling from the schedule. Is this a known limitation of the Scheduler or is it a defect? insert into My_Form [ Added_User = input.UserName Email_Address = input.Email_Address StartDate = tempStartDate EndDate = tempEndDate Status = input_Status
Calling up a form in Edit mode via Deluge
I am hoping that This might save someone from the hours I wasted yesterday Zoho Creator team might enhance the documentation to make the following more clear! The Creator help files at https://www.zoho.com/creator/help/views/editing-records-via-record-id.html#Invoking_the_url_from_Deluge_Script tell us that the syntax is: openurl("http://creator.zoho.com/"+zoho.adminuser+"/"+zoho.appname+"/add_contact/record-edit/contact_view/" + input.ID + "/","same window"); However, there are traps for the unwary!
Calculate Current Balance
I am woring on an application that is an accounting ledger for a bank account. I would like to calculate a running balance based on the date of the transaction for the individual. Does anyone have any thoughts on how I can accomplish this? Here are some details: I am uploading the following data: - Account Number - Posting Date - Transaction Amount I will also put in a beginning balance for each individual as a starting point called: - Beginning Balance Any help would be greatly appreciated..
Specific number of digits in number field
Hi, I'm trying to set a number field to only accept a specific number of digits. I wanted the field to accept 10 digits but give an error message if more or less are entered. I would also maybe like the form to return an error if they try to submit it without ensuring the correct amount of digits. Thanks in advance for any help.
iOS and Android - Subform With Image Workaround??
I have a big problem with my application when it comes down to accessing it from tablets and smartphones. I undertand (I guess) Zoho Creator's current inability to serve up subform data (child records data) to small device users where an image field exists in child subform. Frankly I don't like dealing with subforms anyway, which is why all subforms are disabled and hidden on main form add/edit load and I never add/edit child records via subforms from the main form. Question: Why, if a subform
input data into url field
Hello. I want to add a url link to a record so my clients can click and open another webpage and view relevant data. The webpage I want to direct them to has the same basic url with a unique 4 digit file number for each set of records. So let say the url to be used is "www.myrecords.com/file=". I then need to add "#3245" as the unique file# to give a link of www.myrecords.com/file=#3245" and add the url link name "Click for records". So I add a url field with link name option selected. I add a second
Fields with dynamic lookups not working in reports
I have a simple Region - Country lookup working in forms, whereby the selected Geographic region filters down the list of Countries. This works fine in forms, but not in reports. If a report is displayed in List View, everything is fine. However, in Spreadsheet or Grid view, the Country field is blank. The dynamic lookup also does not work there. The list of Countries is empty.
Calendar Month View Display the time of an event.
Is there an option in the Calendar view to show the time of each event? I just checked with Google Calendar and the Outlook Calendar and both show the event time when using the month view.
Set a variable from a multiline Field
Hi, I creat a form with a multiline field (Notes) Form 1 Name: bert Notes: visit new customer I'm trying to imported the Notes, selecting the name of the person in a new Form (Form 2). I defined this xpression in the user input of the customer name in the Form 2 Activity_notes = Activities(Form 1)[ID == input.Customer_Name].Activity_Notes; But when i access to the app and select the name the notes are not imported. Some body Can help me.
Next Page