formula field in week
Hi there, I have a field Idate and Fdate which is initial date and final date respectively, I want to calculate Fdate - Idate in order to get the duration in weeks, how can I do this? Thank you very much
How can I set hierarchy based view?
How can I create some auto views based on user roles in creator? I know we can create a view which can be populated against current user id. But when there is multiple roles (not only admin and user) and different hierarchy, how can I set this type of auto view? Otherwise in case of new employee joining, every time I have to edit/create some criteria in a view to get the hierarchy wise view. Can it be possible using collection? Pls help. Sudhakar Saha Technical Consultant GoldenLion Consulting Services
Simple Formula Field Not Working
I have a formula field with it's value set to a decimal field - it doesn't display anything. Here's the details;I have a decimal field which is updated from a drop down field's on input event. I have a formula field which (at this point) should just display the value from decimal field. So it's formula is simply the decimal field name. It doesn't update. In the end I want to display the difference between two decimal fields (i.e. field1-field2) in the formula field. Am I caught in another "Catch-22"?
DateTime Control
Hi, I want to create a simple job time entry form. Job Name Start Time End Time Work Date and show the job hours and minutes on the form. The users would access this from their Android smart phones. This is the rub. The DateTime control is unusable on the smart phone I'm testing on. I can pick a date or click to make hours and minutes increase but decreasing them seems impossible as you can't hold shift and click. (Android 4 device - Note 2). Every way I've tried to do it without the datetime
Changing field type after data import......
I am creating a new form and decided to import the data from an excel spreadsheet since I had over 200 records. During the import the field mapping correctly shows the sheet and the data headers. I can choose the type of field. At first glance it makes sense to choose single line, but the field is for "manufacturer name". When the form is later used to create a new record, I would like the "manufacturer name" field to give the choice of selecting the "manufacturer name" from a list. I have another
Deleting Tabs in a view
From a form I created a view with tabs. How do I delete the tabs, I have gone to the extent of deleting the original form and yet the tabs still remain which seems like a bug to me any advice?
Exporting a view with more than 30 columns
Hello, I know that you cannot view more than 30 columns at a time. I assume that's just a limitation in the web interface, but at the very least, I think I should be able to export more than thirty columns to Excel because Excel doesn't really have a limit on the number of columns it can handle, right? So, do you know if there is a way to export a view with more than 30 columns in a view to Excel?
'On Edit, On Load' script not running
I have been trying to hide fields in a subform 'On Edit, On Load' with no success, while the same code in the 'On Add, On Load' works fine. So I commented the script out and just put the following in 'On Edit, On Load': //hide Action_Items_Subform.Activity_Name; //hide Action_Items_Subform.Activity_ID; //hide Action_Items_Subform.Name_and_Capacity; alert("hi"); Which should display "hi" when clicking the online edit command. Nothing happens. Then I found other scripts not running when online editing the
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
Dynamic pick list not working
Quick question: I've created a dynamic pick-list that updates based on the value of a another field (field_A). The filter criteria for the pick-list was entered during form creation. My problem: the pick-list updates correctly if I manually enter a value into field_A, but not if field_A is updated via a script. Shouldn't it behave the same in either case?. A more detailed description is in an unanswered earlier post. Thanks for you help.
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>
user shared apps list not updating
I have had a couple of users report to me that their shared apps view does not contain an application that I have shared with them. I have tested this and can confirm that on one test account (where I have 3 shared apps), one of the apps no longer exists but there is still a link and the newly shared app does not appear. I deleted the share on the last viewable shared app and the new app and reinstated them and they both now appear. There is however no apparent way of deleting the shared app view
Are you sure you want to navigate away?
How do I script for forms that users have started to complete/modify that prevents them from navigating away to another page and loosing their progress? Something like... "You are about to leave a page; do you want to save changes?"
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
Event attendee database - total attendee tally field needed
I am hosting an event - each RSVP form asks how many people will be in their party in a number field. How do I get a total attendee tally? Any help would be appreciated. Thanks, coachbob21 ______________________________________________________________________________ Update - I figured out how to set up a "Total Attendees" report and it works great.
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)
Get me started Please
Hi, Just set-up Zoho CRM and works great. Now trying to use Creator to solve Quoting system and I don't have any coding experience although fairly intuitive. Can somebody help me solve a script to get me started. I have a form called Materials with a field called Product_Description and Product_Std_Cost In my current Form called Modular Component I have one field called Material_1 which is a lookup of Product_Description field in the Material Form. All fine up to here. In my Modular Form
Fill in parts of a form for the client
Hi, I am new to Zoho, so apologies if this is a basic question... I want to create a feedback / evaluation form that I can email to clients following a product launch or show, but I would like to fill in parts of the form for them, i.e. their name, the dates of the event, the name of the activity and so on - is this possible? And if so, how would I do it? Many thanks in anticipation of your help. Mark
All data is gone
Hi, I changed a field in a form and all data seems to have been deleted from the Creator app. What is the problem and how do I get the data back?
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
Trying to hide a field
I am trying to hide two checklist fields on Load in a stateless form. The code I'm using is : AvailDate = Availability [((Date_field > zoho.currentdate && Number_Available > 0) && Appt_Date_Scroll != "")] sort by Combined_Date_Time ; appt_test:ui.add(AvailDate.Appt_Date_Scroll.getall()); hide Select_Room_s; hide Select_Product_s; When the appt_test field gets the data from the other form, the two checkbox fields appear. Any Idea's? Thanks!
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.
Create customer in Invoice
Hello: I've read https://www.zoho.com/creator/help/script/create-customer.html but can not get the script to work. I' ve created a script on add-on success in the form. The code is: success message "Datos añadidos correctamente"; cliente = zoho.invoice.createcustomer({ "CustomerName" : input.ApNom, "Email" : "", "BillingAddress" : input.Domicilio, "BillingCity" : input.Poblaci_n, "FirstName" : input.Nombre_del_padre }); openUrl(("https://creator.zoho.com/adminpsicotrade/tea-cloud/#Form:Pacientes_Escolares"),
How to duplicate entries?
Hi guys. I'm new using Creator and this is amazing. Right now I need to duplicate last week entries for each person so they don't need to reenter the same information. Can i do this? Thanks in advance Pablo
Typo in the press release notification
Dear zCreator Team, There seems to be a tiny typo in the zCreator press release notification. The word 'co-operation' has been inadvertently mis-spelt. I have enclosed the PR notification along with this note for your kind reference. ---- Deepak Vasudevan http://www.linkedin.com/in/lavanyadeepak
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
Can you update a sub-form without closing main form?
Can you update a sub-form while still in the main form? I what to update a Unique ID number when still in the main form to use in another Sub-form. Mainly just to save time.
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() ?
Leading zero for period
Hi, I have a date field capture posting date. Then, a formula field convert the posting date (2013-02-01) to period (201302). I have applied this formula on the formula field: ((PostDate.getYear()).toString()) + (PostDate.getMonth()).toString() System return 20132 but I need the leading zero for Feb -> 02 instead of 2; otherwise sorting will be a problem. I didn't find a padding function and looks the substring function does not support -2 as starting position. Is there any workaround solution? Quincy
Zoho Beginner Exercises and Tutorials?
Are there any exercises for beginners? I am having trouble with the deluge scripting. I have a little programming (Visual Basic 2010) experience, but I am not sure how to use deluge. So I was wondering if there are any exercises for beginners that can get me familiar with Zoho Creator. I already know the basic drags and drops of the tools. Thanks!
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
Generating a report in ZC
I'm confused as how this works in zoho, is there an example or documentation on how to do something like this? Say I have employees paid by job, where each job is paid by hour. I'm a little lost as to where to create a report like this in Zoho Creator. So I have a form/view like these: Employees --------------- ID Name Hourly Wage Job -------------- Employee (lookup Employee.ID) Time Start Time End Status I need a report like this for each Employee ... where user chooses Month/Year Job TimeStart
Creator stopped sending e-mails?
Hi, I have figured out that creator stopped sending e-mails after the completion of the form that is embedded in my web site? It was running perfectly before 8th Jan. Since 14th it does not work at all. Here is the form https://creator.zoho.com/istanbultangofestival/2013/#Form:Registration_Istanbul_Tango_Festival_2013 Regards... Aydogan
Hide or Show multiple fields
What is the syntax to Hide or Show multiple filed in a form? I would like to hide filed three fields in a form example: hide Service_Type, Street and Notes. Thank you.
Next Page