find duplicates in database
hi i just made one new app in creator only for managing contacts (names, emails, phones, firmname, addresses, etc) and try fill this database with data from excel there is manу excel files in which data can duplicates how can i search in full database duplicates values and (for example) make new view for them? example for search - email, last name
Count boolean values in a column, ["true" only] for use in a report
I need to report on a table that has many columns where the data type is boolean "decision" values of true/false. I only need the "true" to be counted, Example is: EMPLOYEE answers inbound phone call and logs the CALLER name. Each employee gets credit for a call as long as CALLER is not blank & 1 decision field D1,D2, or D3 is true. This pivot reports the totals every week. table data EMPLOYEE CALL D1 D2 D3 EmployeeA Tom FALSE TRUE FALSE EmployeeA Nick FALSE
Problem: Cannot assign a single value to a dataobject
Hi, I'm getting the following error: "Cannot assign a single value to a dataobject" whilst trying to iterate through a list. Could you take a look? The code is at https://creator.zoho.com/ahatton/kidsoccer/htmlview/Viable_coaching_slots/edit/ (edit access provided to support). and pasted here for reference, for other people. lstTimes = list(); ... for each timeSlot in lstTimes { if (timeSlot.startsWith(hour + "-") && timeSlot.contains(day)) { numSlots = numSlots + 1;
Doubleups in fetch records
I am using a fetch records to narrow the output of a lookup picklist, when I reun the fetch records, and then add them to the picklist I am getting multiples of the same, and the sorting doesn't seem to work. When the form loads there aren't doubles, just when you narrow the results. Here is the code to narrow: I put a clear in to ensure that they were clearing before adding... hazards = (Hazard_Register[(Site == input.Location || Site == "All Sites")].Hazard_Name sort by ID).getall(); clear Hazard_Name;
Help updating records on user action inputs
Hello, My team and I were attempting to have one form impact another form's data once it was updated. We wanted to make it so that when a client in the "Client Listings" form checks out a bike on any particular day [Check_OUT_Date], it will then change the status of that bike [ServiceStatus] from "Online" to "In Service" in the "Bike Listings" form. We believe it is possible to do this, and we almost made it there, but we got stuck because when we went in and tried to edit it in the "Actions on
Choose how CRM field fills in Creator application
In my application I have placed a CRM field called Customer Name, which is pulling from Leads in the CRM. When I execute my application, the field is being filled with the Lead Name (John Doe), instead of the Company Name (XYZ Company). Is there a way I can have the field fill with the company name instead? My goal is to select the record from the Leads module in CRM and have all the contact information for that lead populate respective fields on my Creator form. I tried to add the following to "On
Using loops, how can I send e-mail reminders everyday until a certain date has been established?
This is a rental application. I am having trouble setting up a loop to where it keeps on sending the customer an e-mail message reminder of their past due item every day until they have returned their item. I need a loop that runs and executes the code below and stops once the customer's Actual Check In Date is reached (ActualCheckInDate) Here is my function code so far: void emailoverduereminder.EMailOverdueReminder() { // Please write your Form name here, which having record that dues deadline
Default sort order
It seems that over recent times, the order in which records on my main table are being displayed is no longer that in which they were added. I can't quite see whats changed and wondered if you might be able to shed some light on the issue. It is the 'Train2Drive Pupils' application, and the 'Pupils' view. For example, Chloe Buckley was added before Joanne Cook. I have left support access open just in case you need it. Many thanks, Adam Smith
Help with script to create a new record on user action
Can someone help me, I need to create multiple records based on user input (radio button), replicates of original records with only date fields modified. any examples where this is done?
how to apply built in functions to formula fields in forms?
I have 2 time fields: etime and stime I need to calculate number of hours between these times, rounding up, in a formula field. I tried: ((etime - stime) / 3600000).round(); but it wont apply the round() function when I test, and when I go back to editing the application and viewing the formula, it deletes .round() I'm not sure how else to do this, can anyone help?
Paypal Hangs
I have an application that uses the PayPal integration. For most customers it works perfectly. However some after completing the PayPal function they get please wait screen do not close this screen. The transaction is completed but the please wait screen never goes away. I have not been able to find a pattern. I know it has happened with Internet Explorer 8 and Safari and possibly other browsers. Have other people seen similar results? Herb Wexler
Deluge "While" loop?
Hi there, I'm afraid I'm having trouble with something that's probably very basic... I'm writing a function that inserts a given number of records into a form. One of the arguments for the function is "NumberOfRecordsToCreate" (int). In pseudo code, this is what I'd like to do: while Count < NumberOfRecordsToCreate insert into <formname> [ <fieldname> = <expression> ] Count = Count + 1 end I can't figure out how to do this in Deuge script? Many thanks for any help! Cheers, Katie
How To Generate Reports that Records Changes?
Hi, I am trying to generate robust reports. For instance, this database is for a Bike Rental program. I am trying to generate robust reports for each bike (how many times it was check out, who checked it out, when it was checked out, the service status history of each back etc.). I learned that I currently am only able to see the current status of my current bikes and clients. Therefore, in order to see the robust history, I would need a report to generate the history and all the changes. Is there
How to do automatic e-mails for calendar deadlines
Hi, Our team is doing the Zoho creator app, and we got stuck on something. We were trying to make it so that when a bike is due, it will send out an automatic email to them and let them know two days before it is due. We were having a hard time because we're kind of new to this program, and we were confused by you guys' scripting. We weren't sure if it was necessarily a specific kind of language like Visual Basic, java, etc. or not, so we weren't sure where to exactly start. Maybe just knowing that
How to filter dropdown menus/lists?
We have a dropdown list (Bike_Info) that we need to filter out. The dropdown list (Bike_Info) pulls data from the “Bicycle Listings” Form (Bike_Listings) and displays the bike serial (Bike_Serial) of all the bicycle records. We need it to filter out the list to only show Bike Serials with a Service Status (status) that are “online” and not display the bikes that are “in maintenance, checked out, etc.” Is there a way to do this? Thanks!
Zoho Creator API Filter Issues
I am able to do a general call like this: https://creator.zoho.com/api/json/fuelorders-v2/view/Order_History1?authtoken=AUTH_TOKEN&scope=creatorapi&raw=true and get a response: { "DF_Fuel_Order": [ { "Ship_To": "455 Coors", "Product_1_Gallons": 1000, "Terminals": "", "Product_2_Gallons": 7500, "Product1": "Conv 91 Premium with 10% Ethanol", "Product2": "Conv 86 Unleaded Gasoline with 10% Ethanol", "Product_4_Gallons":
Complex List Requirement
This is easy to describe but hard to encode: My client wants to select a start date and end date and then make a list of all dates in between that occur every 7 days. Example: Starts: 27-Jan-13 Ends: 10-Feb-13 The list would then be {"27-Jan-13", "03-Feb-13", "10-Feb-13"} Cheers, John Whitney
Help Needed with "If" Formula
I need the total number of Ads for Conferences, which would be distributed in "Welcome Packets" I have attendance by professions. My formula works by just adding the professions. But I need to implant an "if" formula. My Outreach methods include: Trainings, Booths/Displays, Ads. I need the summing of the attendance "if" Methods_Field == Ads. I've tried MANY formats, the "sumif" function worked in Excel that the db was imported from. Here is what I have now: If(input.Method_Field==input.Ad)
how to copy subform
I have a form (transaction record) with a subform. I want to copy the whole form info. (for the second+ same transaction) with the subform, then I will edit some info necessary, then submit to produce a new transaction record. But I could not find the way to copy the subform correctly, since every transaction with different lines of subform. I set default 1 row for form on load, so every time I could only get one row (last row of the copied transaction) I put the following code in form on load if
How to use values from subform for calculation
Hi there, I am developing a form which contains a sub-form. The sub-form contains a numeric field. I am trying to sum the numeric values from all sub-records and present the result in the header (the main form). Please advise! Thanks, TLV
Linking Zoho Creator with Zoho CRM
Hi I work for a small IT repair business and have recently started using Zoho Creator and CRM. Using Creator i have built an app which acts as a job sheet which i fill in as i am working on a customer's computer, this app includes fields such as what the problem is, the work i have done to solve the problem, costs etc. What i would like to be able to do is have some kind of lookup field in my job sheet app so that i can search for a customer that is stored in Zoho CRM, this meansa that rather than
Trying to link Zoho CRM Record and Zoho Creator App
Good Evening, In short, I am trying to accomplish the following: When in a zoho CRM potential module record, hit a button that will be bring up a creator custom form. this custom form will have CRM fields (auto populated depending on which CRM record they were on) and new fields. When done entering the data, there needs to be an option to print as pdf. This attachment should also save to the crm record of the potential. Is something like this possible using Creator and CRM?
Edit Mode Problems
Recently I've notices some problems with the form edit mode. Highlighting a field and clicking on 'Actions on User Input' takes me to the On Add->On Load section instead of the code section for the field. Also if I highlight text in the Free-Flow scripting and press ctrl-c to copy and then click on the On User Input for another field the text shows without me pasting. This happens in firefox and chrome. Herb Wexler
SumIf assistance needed
I have tried writing this many ways and I'm not getting a good formula.... Can anyone help? I need: If "Method_Field" (which is radio button for 3 options, user must select 1) is "Ad" Then the # of attendees from the RCC-Staff + Law_Enforcement + Legal_System_Prof + Healthcare_Prof + Social_Services + Educational_ Prof + DV_Prof + Disabilities_Specialists + College_University + Multidisciplinary fields Resulting in a cumulative total number of attendees from the training, where the ad was placed
Possible JavaScript / XSS Vulnerability with embedded Google Calendar
I'm attempting to embed a Google Calendar in an HTML view via the Widget (iframe) First I saw this message: Possible JavaScript / XSS Vulnerability Then I saw this (see below) but the calendar is displaying in live mode: http://creator.zoho.com/niskypto/pto/#View:Calendar John M. Whitney Recommend
More Fun with XML and executeXPath
Related post https://help.zoho.com/portal/en/community/topic/help-with-xml Here's the next xml do-dad I need to tackle (yes, it's for my Amazon SES+ZOHO app) <GetSendStatisticsResponse xmlns="http://ses.amazonaws.com/doc/2010-12-01/"> <GetSendStatisticsResult> <SendDataPoints> <member> <DeliveryAttempts>2</DeliveryAttempts> <Timestamp>2011-04-17T12:25:00Z</Timestamp> <Rejects>0</Rejects> <Bounces>0</Bounces> <Complaints>0</Complaints> </member>
Scheduler Email: Data From A Related Table
thoughts.authors.wiki_link As a Zoho Creator newbie, I am attempting to run a schedule that sends a daily email. Simply, it is a database of quotes I like that gets sent to friends and business associates. The quotes are in one table with the intended send date (Thoughts_View) The details about the author are in another table (Authors_View) I have been successful in getting the email to send with data from the primary table (thougths_view) but have not been able to get the date to send inclusive
submit through other email
hi there is some description how to add entry to creator's app via zoho form https://www.zoho.com/creator/help/forms/email-data.html#Adding_form_data_via_e-mail_in_user-defined_format is it possible submit through email from other forms? i need submit next entries: 1) entry of incoming/missing call (online phone system sends me this email with phone number). 2) entry for consultation (from text form via my site) 3) entry for order (from text&file form via my site) can i add entries via REFORMATTING
Birthdate field format
I have a birthdate defined as a date field. People want to type in the date because the calendar icon takes too long to go back decades. The date format for the application is [E,MMM dd,yyyy] because in other parts of teh application showing the day of the week and month are very useful. No matter how much I instruct the users they want to type the date in as mm-dd-yyyy. The problem is that it seems to take 01-02-1980 as Feb 2, 1980. Is Zoho planning on having date formats that are specific to a
Grid views for mobile?
Hi, my client wants to build a mobile friendly attendance tracker app for his soccer club. His vision is for his coaches to be able to access the attendance tracker on their iPhones. I've been playing around with this and have created a basic attendance tracker with the bare minimum of required info. Grid view seemed like the most sensible way to display the tracker because coaches will have 5-10 students per class and this would allow them to quickly tick people off. However, when I try to access
Statements and Invoice
Can anyone advise if they have produced statements and invoices from a Creator application. I am wanting a reasonably formatted document with company logo etc. Please advise. Thanks. Kind Regards, Russell.
Lookup fields Not Sorting
Create two Forms, FORM_A and FORM_B If you create a lookup field (in FORM_B), and within the definition of that lookup, you enable : Display Type = Dropdown Show a link to add new entries in FORM_A and also select : Show choices in alphabetical order When you then use FORM_B, and use the link on the field, to generate a new record in FORM_A, once saved, that entry does not get sorted in alphabetical order in the drop down list. Only by exiting the form and re-selecting the form, does the correct
alert text is double spaced
I'm using an alert box to show several lines of text. The text shows as double spaced. I made sure there are no hidden line breaks or paragraph markers. Is this a function of the browser? I've only tried this in Firefox. Is there a better way to conditionally display a text paragraph? Thanks Herb Wexler
find null values with searchRecords
I wanna find null values and then update it with a new value in my accounts from zoho CRM with this function in zoho creator: zoho.crm.searchRecords("Accounts" "(Field Name|is|null)"), but this don't work i try with is EMPTY too, can i find null values with this function (searchRecords)??
How To Pass ID From One Form To Another Form With Out Using The Querystring Functionality?
Hi, I am using a single "Stateful Form" and "Three Stateless Forms". I am passing the ID Created in the Stateful form to other stateless forms. So that i use the ID passed using query string to stateless forms for updating data to the record in the stateful form. The problem is as the ID is passed as query string, it is stored in browser history. So when anyone logs in they can view the records using those url's since i have written some logic to retrieve data "On Load" based on some things.This
Subform actions
Subform and Form actions options are not in sync. I have a subform and have copied the logic from the Form Comments to the Comment subform. The only logic I can't replicate is the "On Add On Success" and "On Edit On Success". Is there a way for subforms to inherit the Form code so there isn't double entry of code? Or alternately, can you add on add success and edit success actions for subforms to make it consistent with the forms?
Error fetching data from another app
i keep getting this error "Error modifying the page Encountered "[" at line 84" while trying to fetch data from another form. here's the code - input.currency_from_app = app6.form1[Currency==input.Currency].Value; i can't use a lookup field because it requires the user to choose an option (it will be only one option, but still the user will need to mark it). i also tried this code- if (input.Currency=="Euro") { input.currency_from_app = app6.form1[Currency=="Euro"].Value; } but still - the same
openURL is not passing parameter on mobile
I am trying pass an ID from a stateless form which doesn't work when on a mobile. The URL gets altered in a new way. The mobile URL becomes APPNAME/form-mobile/Login#Form:Weekly_Form?ParticipantID=1005& instead of APPNAME/#Form:Weekly_Form?ParticipantID=1005& Relevant script of the Login form: validParticipant = AddParticipants [Participant == input.Participant]; Linkstring_Weekly = "#Form:Weekly_Form?ParticipantID=" + validParticipant.ParticipantID +
XML responseText missing opening tags and other data
for some reason when I get data back from a particular web service, it is missing opening xml tags and a bunch of other XML data. I have removed sensitive data and only included a portion of the response body but you should get the idea. here is what I get in responseText: "Ok<\/resultCode>I00001<\/code>Successful.<\/text><\/message><\/messages>..." here is what I should get: <getTransactionDetailsResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
Create Status for Form Submission
On App form is it zoho best practice to create hidden field and attach a status record on submission? I'm coming from Salesforce, where it was standard to submit the record and on submission new record rule would trigger a status creation to the submitted record. Saw a few things in the help docs, but just wanted to know what most do here. Thanks, Dustin
Next Page