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":
Create a weekly stock report
I'm using creator to manage the product stock. I would like to make a report that shows how many a certain product are in stock. For example, on week 2 we have purchased 30 hard disk and under week 2 we have sold 5 hard disk and week 3 we have sold 6 and so on, while on week 4 we purchased more hard disks to fill the stock. I recorded the date for each purchase (positive record) and sales (negative record). So in my database it will look like this: Name of product Qt Date Hard disk
Required field only if other field is empty
Hi there, I am trying to add a check on validation of my form. The form enables users to input size and price of products. For the size I have a picklist (dropdown) of available fluid measures (25 ml, 50 ml, 75 ml etc.). This field is called 'Size'. Sometimes, however, the user might not know the actual size of the product in fluid measurements. In that case I would like them to provide a description of the size in a single line field (Operator_Name_for_Size). This is the code that I am using,
Remove shared application which user is closed
Hi, I changed my email and closed my account with the old email. However I have a shared application now it is in my other account. How can I removed this application? Thanks!
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
What happens when I reach my record count limit in Zoho Creator?
I use the Standard Plan in Zoho Creator. Can you tell me what happens when I reach my record count limit? Will I be unable to create new records? Or will I be charged for records over my limit? I have several people adding records to the database, so I want to know what to expect. Thank you.
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
Button to cycle trough records in a table
I have uploaded my access application and need to be able to cycle through records in a table using 2 buttons one for next record and one for previous record. Please can someone inform me how this can be accomplished?
Custom search creator database
I am using the it asset manager and I would like to create a custom search on the home landing page. I am able to create a search for a single view but what I really need is to search the enitre database (all views). Is this possible?
Downgrading Link for ZOHO Creator does not work
Hi, I want to downgrade my Zoho Creator from Basic to free, but the Link "Downgrade to the free plan" is not working, its not a real link at all! When I copy it and paste it, it gives me "javascript:;" and no Link. Can you please downgrade it manually for me? And do I need to pay this mnths fee even if I haven't used it at all? Regards, Atia Ahmed from gestaltungsWerk, Germany
Add to existing record based on email unique ID via web form.
Hi All. I'm completely new to Creator and loving it! I'm trying to use Creator to build a very simple CRM and recruitment solution (I've already checked out Recruit). My scenario is as follows 1. User submits registration form on website where their email address should be treated as the unique id (I have step this working no problem) 2. User comes back to website and expresses an interest in a job, Creator should add this expression of interest against the person's record based on identifying them
User built in functions
It would be nice if there were build in user functions that could Let you know which groups a user belongs to What the user email is if passed a user login (not just current user) Get a list of all users Get a list of all groups Get all the groups a user is assigned to when passed in the user login Get all the users assigned to a group when passed a group name Please add user functions to Zoho. Is it part of the roadmap for future Zoho releases?
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
Task Assignment Emails Include Hyperlink
Is there any way to include the hyperlink to the task page in the notification email the assigned person receives?
Special characters
When I do export to pdf file, the data do not write characters č, ć, ž etc.. How can I fix this??
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
API for searching user details
I have a search form along with First Name, Last Name, Email Address and Phone number fields.How to fetch the records according to the searched string in the form? Also all the fields are not mandatory. Thanks.
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.
Creating an event in Google Calendar
Hi, I have listed below the deluge code snippet for creating an event to GoogleCalendar. The script uses the PostUrl function to send header parameters and write XML Data in the request body. Function for generating authoization header string getGoogleAuthToken(string email, string passwd, string GoogleService) { accountType = "HOSTED_OR_GOOGLE"; url = "https://www.google.com/accounts/ClientLogin?accountType=" + accountType + "&Email=" + email + "&Passwd=" + passwd + "&service=" + input.GoogleService;
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
Global Variable
Hi, Is it possible to have a global variable in Creator? i.e. If I am in "form A" and I say that X = 5 and then I goto "Form b" and say input.number = x, how can I make this work? Nigel
entering data into forms
Hi there- when I upload an access database into Zoho it creates a corresponding form for a corresponding table in access. I only want users to be able to enter into 3 forms and populate 3 tables-how does 1 do this?
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?
Align right only numeric fields
Hello. My default align in my form are left and this is good for string fields. I also have some numeric fields. How can i align only this fields to the right? Regards.
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
How to set a field to a given value when a record is duplicated
Hi. I have a form in my application which has a field called Status. Status can be "Draft" [Edited - original post said "New", which was wrong], "In Progress" or "Closed". When an existing record is duplicated via the Edit/Duplicate function in the list view, I want all the data to be copied to the new record, except the Status field which I always want set to "Draft" [Edited - original post said "New", which was wrong]. I have achieved this using the script input.Status = "Draft"; under Form Actions
how to assign the value
how to assign the value for the field?
Next Page