How to restrict repeated values in a lookfield of subform
Hi, I have a subform with 2 fields "Color" and "Thickness"(These 2 are lookup to fields in other form say F1). Now if i select one Color, all corresponding Thickness to that Color has to be displayed for 1 time. Say like, if you have records like Black - 3cm Black - 3cm Black - 3cm White - 2cm
You have been marked inactive by the administrator of this application
Hi, We just want to ask for help on how can we resolve this? We cannot see the details of zoho ticketing due to this issue. Please advise.
emailing records
Thanks for the awesome product! I've been learning as I go and am still getting hung up on some of the basics. I have a scheduled task, to send an email based on a date field in my new_purchase form. I would like to include the record with the date field that I am evaluating as a part of the body of the email. I have successfully sent the email, but do not understand how to get the record and place it into the body of the email. Also, is there a place in the documentation that defines all deluge
Track changes to a specific record type - Audit Trail
I am looking for a way to track changes to a specific record type. I have a shared task list where I want to have change-log/audit-trail of "Who changes What and When" This should work for: 1. single record edits 2. bulk edits Can anyone point me to a solution for this? Jaco
Problem with XML to add a record to a table I have created in Creator
Can you please tell me if there is anything obviously wrong wit the xml below. <form method="POST" action="https://creator.zoho.com/api/xml/write" > <input type="hidden" name ="authtoken" value="**********************************"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <textarea name="XMLString" > <ZohoCreator> <applicationlist> <application name='moreland-umbrella'> <formlist> <form name='Workers'> <add>
Working with subforms and related main form field
Hello. I'm new in Zoo Creator and i need help. I would like to write a Deluge Script and i have doubts. In order to track the daily tasks from every employee on my applications I´ve got a registration form called "Daily Report". This registration form has got a "DailyTasks" sub form from which every employee must specify the developed tasks (spend time, description of the work,...., and a last field where the employee can say if this task is a part of an open project). Daily Report Employee String
Error: Variable 'thisapp' is not declared
Hi, I'm getting a weird error message when trying to use a custom function in the OnLoad script of a stateless form: "Variable 'thisapp' is not declared". The form is https://creator.zoho.com/ahatton/form/278/3/scriptbuilder/# and I have allowed edit access to support. The code I'm using is (and I generated this using the script build to make sure): prefix_str=thisapp.child_registration.getPrefix(input.child_number); and the function declaration is: string child_registration.getPrefix(int child_num)
Using Lookup but eliminating entries from new list
I have an app which my sales team logs their sales into. Their is a field named "Order #" on this form which is a unique number. I have a follow up group of employees who follows up on sales from the previous week. I have created a second app for this group and am using the lookup field to import the "Order #" from app 1. I am able to use deluge to filter out all sales older than a week old, and to select based on the country. But once the customer is contacted and the form is filled out (by
Autofill an Add Lookup Link
Is there a way to autofill an add lookup field before it is submitted? For example, I have a Task form and on that task there is a project lookup field and beneath that a component lookup field. The component lookup field is a dynamic picklist based on the component form that associates the components only that correspond with the project selected. All of that works fine. My question is, when I click on the Add Component if I need to add one not in the list, it takes me to the popup of the Component
Zoho Creator & Quick Books
Hi, I need to integrate Zoho creator with quick-books. Is the integration possible or their is a alternative way. Do you have a Creator and Quick book integration.
Any way to Allow Customers to Submit, Store, and Search Records without having to Create a Zoho Account??
Please bear with me as I give some background on my organization so I can set the stage for the issue I am having. My organization is completely run from a website. It is somewhat of a subscription-based search service where parents and babysitters can locate each other. I will have thousands of users that will come to my website, fill out a seperate registration form AND questionnaire form/profile (will be rather lengthy) pay for level of service they want, and then perform searches and other functions
Auto fill a sub form
I am new to ZC, and pretty sure this should be simple, but cannot get it to work. I have a Main form "Customers" with field "Company". Then I have a sub-form "Invoice", and when I create a new invoice for each company, I want the "Company" field in the "Invoice" form to populate. Thanks
Is it possible to call zoho variables in a column heading?
Is it possible to set a column heading to zoho.currentdate.getMonth() ?
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
Next Page