Tab Filtering
Hello, I would like to know if there is any way of filtering on a tab level (rather than view level) I have 23 tabs each for a separate country. Under each tab I have a set of views with data from my forms. There are 10 views in total (eg. General Country Information, Key Economic Information, Key Demographic Information etc.). I might change things on one of the views (to exclude or include certain fields). When I do that I would like this to apply to all my tabs at once - so that I don't have
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?
Zoho Creator as document assembly app
Hi I want to simplify the creation of contracts for prospective clients. I use Zoho CRM to capture the lead/account/contact etc I use a linked Zoho Creator app to capture the technical specifications of their requirements. Some requirements would be a simple merge field - data captured goes into contract as is. Other fields may be conditional. If one option is selected, then add a block of text to the output (e.g. terms or conditions). Some fields may be dependent (can't choose option 7 if you didn't
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
Is there a problem with creator today?
Is there a problem with creator today? I cannot add extra records? Urgent
Form Duplication on the Fly
Can I duplicate a form using only deluge script or am I forced to manually navigate the creator menus to do so? I want to use a sinlge form as a template and then duplicate it on the fly with code and then populate the fields with data from other records. How is this done? Can it be done?
Question about for each loop
I have a database with following structure: Form1 Name Quantity Flag Name1 30 True Name2 14 False ... The Flag Field will be True if the Quantity is the largest. When I add a new incident the script should check the Quantity if the new one is larger than the previous, then the previous Flag should be False while the new one will be True. In this case a "for loop" with index should be convenient. Please any one give me a hint! Thanks!
Render image in form
Is there any way to render an uploaded image in a form? I'd like for the users of my application to be able to see the photo they have uploaded right in the form, rather than have to submit the record and then go to a view to check if they selected the right photo. One workaround is to use the Rich Text field to show the image, but that looks fairly ugly. Thanks!
Cannot save deluge script
I have previously been able to save Deluge scripts as backups for my application. However, it is not working now for some reason. Can you please resolve the issue? I have tried with both Chrome and Safari web browsers.
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!
Where is the Access Application Button in Creator?
I looked at your guide where you explain to click on that button to start to input data, but neither with Google Chrome nor with Opera I can find that button! The only way I found to access the application to input new data is to refresh the page, return to the dashboard, click on the link to creator and then select the application I want to use. Is there any chance to get that button? Is it caused by an extention? I know it is odd that it happens with both the browsers. Thx.
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.
Next Page