Actions for each new row/record in Subform.
I want to send an email to each new email address added in a subform. Is there a way?
ZC - ZInvoice integration questions, Autoemail for customer && Set default payment gateway
Hi there A couple of questions when zinvoice is generated via zc integration tasks 1. When an invoice is generated via ZC (& status set to open), does that automatically mail the customer with invoice attachment and payment details? 2. my client tends to use STRIPE for payment, Can this be set up as default @ ZInvoice,.. or via ZCIntegration task? -Deepa Govind http://homepreneur-online.com/
Only allow user to access records based on specified field value.
Hello, I am using Hariharan's CRM. Each store has a unique Zoho login. In the New User form I have a field named STORE. (There may be 2 or 3 users per store) Also every record in a form called LEADS there is a field called STORE. I need to ensure that when a store logs in. They can only view their own records and not the records from other stores. Can anyone please help?
File upload - box.net?
Hi, The file upload only has the following options Local Computer Google Docs Is there a way to integrate Box.Net files? My client keeps all their files on box.net and wants to select and upload files from the one location.
Can we control the way ZC generates ID for data?
Generating ID fields seems completely random, is there any way to control sequencing, particularly on imported data?
Filtering picklist with another list
Hi, I want to filter a lookup list in this way: 1) I have three forms, Categories, Subcategories and Products 2) Everyone of these forms have a multiple look up field to the other two forms 3) When entering a new product, the user selects as many categories as he/she wants, no problem here, no filtering, all Categories show up 4) When selecting Subcategories, I want this list to be filtered in a way that only those Subcategories belonging to the Categories already selected by the user show up.
Deleting multiply subforms
Hi, I have a form that has say two subforms in it [form1 and form2]. When deleting a record of type form I should manually delete the relevant records typed form1 and form2. I have bidirectional links of course. The on delete script allows only one delete statement. What can be done? [my form actually has 4 subform ...] Many thanks for your assistance, Regards,
Register Without Email
Here's a new one! A client of mine has a few patrons that apparently do not have or want to share an email address. Can you believe it? Yet, they have online access, presumably at a library or work computer. The client wants the patrons to manage their contact data online. I'm at a loss how to create an app that requires sign-in but does not use email (zoho accounts)... I know it's not allowed to create a custom authentication system so what's the workaround here?
How can I change the display type of a look up field from multiple select list to checkboxes when this option is grayed out?
Hi, How can I change the display type of a look up field from multiple select list to checkboxes when this option is grayed out? i.e. when the field had already been created as multiple checklist? Rgds Luis
Parent, Child and Grand-Child Relationship
Hi All, I have a scenario like Parent Form - Business_Date (This form had "Customer" as subform) (Bi-directional Field - Bdate) Child Form - Customer (This form had "Business_Points" as subform) (Bi-directional Field - Cname) Grand-Child Form - Business_Points So, coming to the issue i'm facing is that, when i simply update the Business_Date form, all the existing
Complex Form - Need Assistance
Hi I need to create a form based on the below requirement, any assistance is greatly appreciated As you can see from the below image i have all the customers stored using Customer Form, i need to create a new form where i pickup the customer from the customer table and have the action fields with radio buttons or checkboxs. i can create a lookup field and individual action fields and the user can select individual customer and select the action fields, but its too cumbersome to do it for tens of
toTime() seems to be broken
Hi, I'm trying to allow users to enter time in 24hr format into a text box. I get errors as shown in the attached screenshot when I use the following code: alert("test start time: " + row.Start_Time + "..." + start_time.toTime("K:mm")); Note I am using an acceptable format for 24 hour time as per this page.
XML RPC - Add Records using VB.Net
I am struggling trying to use the above. Have you got any code snippets or documentation that may help with this. Thank You.
Formula field issues + Drop down list question.
Hello, I am developing an app to find the average score among 4 scores the user inputs in a form. However, the field does not appear on the form (even when I check the box), AND it doesn't show up in the view. Here is the function I am using: (Work_Quality_Score + Work_Habits_Score + Job_Knowledge_Score + Behavior_Score)/4 Also, I have a lookup field to select the employee being evaluated. Is there a way to have it look up First name and Last name? These are two separate fields in another form.
Gird View Permission?
Hello, how can get this Code: if(!(input.IATA_No.toString().matches("^\d{8}$"))) { alert "The IATA Number should be 8 digits long!"; // replace 3 and 5 with min and max digits.. cancel submit; } into the views? Thanks Carsten
Can Zoho Creator work with Apps in Marketplace
Is it possible to linking Zoho Creator App with a existing App in Marketplace? Such as "Zoho Projects"? Say I want to have extended functionality that "Zoho Projects" doesn't. Also, is "Zoho Projects" created with "Zoho Creator"? Thanks again for the response.
Matching payments to orders: can someone point me in the right direction?
Hi, I work as a manufacturer's rep in the theatrical lighting industry. I've successfully set up a Zoho database to handle the "front end" of my business, i.e. the constant stream of purchase orders in my territory (all identified by a unique order #). Once a month, I get an Excel file of commission payments for that month (which also references the order #) I'd like to be able to import the monthly report and have it automatically reconcile payments with orders, but I'm really lost as to the first
How do you sync info from a form into sub forms in individual records?
I have created a form where I can keep track of individual client records, their contact information, etc. I have also created a separate form where I can input client hours and services each time they visit the office. I would like to add this second form into each clients personal record form. I added it as a subform however this doesn't' sync the information added to this new form. Each time an existing client comes into the office I want to be able to add their name, the date, and the services
Auto Population of values in Plain Text Field
We are familiar with doing auto generation in drop down fields in Zoho Creator using Deluge Scripting We need to auto populate the values in "Plain Text" field type instead of a Drop Down. Look up is being applicable only for "Drop Down" type. How can this be done?
URL parameters for Calendar view?
Hi, I'd like to display a calendar view in week mode showing a specific date range. Is there a way to do this? As an example, I'd like to be able to show only the week 6/1/2013 - 12/1/2013. It would be good if I could do something like: https://creator.zoho.com/ahatton/kidsoccer/#View:Coach_Availability_Slot_View?mode=week&start_date=6/1/2013&end_date=12/1/2013
Action on Add Row for a sub form
Hi, When adding a row to a sub form, how can I asign a value to one of its fields using information in the curent form? There is an option to do actions "on Add Row" but the problem I have is that it only changes the first row rather than the row being added. Below is the code I am using, which results in updating allways the first record of the subform.. input.SKU_Ultimo = (input.SKU_Ultimo + 1); SKU.SKU = input.Numero + "." + input.SKU_Ultimo; thanks for your support...
is it possible to create a dynamic "price engine" in Zoho Creatotr?
Hello all, I would like to know if it is possible to create a dynamic "price engine" in Zoho. I have a list of prices that we use in our company and I would like my users to be able to find the most suitable price based on 4 criterias, namely: Location, Type of Product, Age and Product Extras. I have all these information stored in a view and would like to have a search form that lists the products based on their prices. Is this possible in Zoho creator? and if so would some one kindly let me know
I want to disable the add / delete items in a subform. How I could do it?
I am charging the information into an specific sub-form in advance, since the date is already uploaded I want to disable or hide the posibility of add items or delete items into the subform. How could I do it?
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
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
'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
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() ?
Next Page