Scheduler Scripting Question
Hi I have a Daycare application and I want to charge tuition dues every Monday for Cash paying parents. I know how to set the scheduler but I need help creating a script that does the following: Find the kids who pay "cash" from the payment_type field in the add_kids _form For each kid who pays "cash", select the child's name (ID) and weekly_tuition_amount from that kids record Then create a new entry in add_bill_form with the child's name (ID from add_kids_form) and weekly_tuition_amount amount
Incorrect columns
All of a sudden, I am unable to correctly IMPORT records into http://tinyurl.com/Ind-Vets - A database of Indiana Veteran Graves. This just began a couple of days ago. I high-light and copy info from an XLS table, IMPORT & PASTE into the CREATOR database. I am positive an equal number of columns are in each. But when finished, the first column (NAME) is missing and all other columns are shifted one to the left. In the PREVIEW all looks okay, with info in correct columns. I must load each individual
Please help me implement Global Filter
Hi there I want to filter all views according to a value in a field called Client in a table called GlobalFilter. So, I want each view to show only values where Client == GlobalFilter.Client I'm guessing this won't work because the LHS of that formula is a string and the RHS is an array. Please advise how to achieve this. For the record, I am preventing the user from entering duplicate Clients into the GlobalFilter table. Justin
Custom Printing (Such as Checks) ?
I have an application which I wrote many years ago. I am new to ZOHO but so far what I have seen I think is possible to reporduce with my old program with Create. In my program I have an 8/12" X 11 (perferated into three equal parts) receipt. In my old program I print a three part receipt (All three sections print the same thing). I also print checks. Is it possible to create a report that would allow for custom placement of fields so it could print such a receipt or checks ? Thank you for your
Dropdowns not working?
When I try to use the dropdowns on my form, accessing it from an outside computer and not logged into the site, as any third-party user would do, they scroll in the window, rather than dropping down. Is there a glitch or some change in the way these are working. Since my mouse scrolls three lines at a time, I can't even see all of the options.
Can I set a default value for a field in a view (not in a form)?
Hi folks - I've just started using Zoho Creator, and I'm hugely impressed. I have one general transactions table ('activity') with an 'ActivityType' field to identify different activities. I'm setting up a view for data entry of one of the activities - in this case, 'Swimming'. How can I set a default value of 'Swimming' for the activitytype field in this view only? Many thanks in advance Shane
If, then formula
I am trying to create a formula - (I am a novice for clarification) - I am creating a project database and I have one field labeled Invoice Paid that is a drop down Yes or No. When this is clicked YES, i want another field labeled Project Complete to Yes. Is that possible?
Registration system
I embedded a form in a website with signin required. The signin screen shows as expected but there is no option for a new user to sign up. The application does not have to be very secure but I do need to know if they are a returning user or a new user. Should I build a form to gather the persons email so I can direct them to one page if they are a new user and a different page if they are an existing user? If I ask for an email then I should also have a text field called a User ID. Both the email
Lookup to set a variable
How can I use Lookup to set a variable? I have two forms. Form one has two two inputs, Name and type of participating (Dinner, after-party or btw) Here I have registered all invited guest for a wedding. The other form is for the guests. Here the select the name from form one, using Lookup. How can I copy the participating value from form one, for the selected name, to a hidden variable in form two?
Update existing records using "Import Data" option
My app references records that change daily. A raw report can be generated to show these changes, but I can't import these reports into my app and update the older records with the changes. To be able to do this would be HUGE. If there were a work around (perhaps using the OnChange script) please let me know.
User Authentication
I had developed an app in zoho crm. In that application i made 4 forms. What i want is that only 20 user can see one form with there own records(No other person can see others records). And there is 1 group which can see only 1 form which nobody can see other than people in that group.
Create an Proposal (Estimate) Form
I am a contractor who visits client's home to provide them estimates for their swimming pool remodel project. I would like to create a "form" that I can use to enter the various things the client wants, along with measurements - and this will generate an estimate to give to the customer. for example, I can input the lineal feet of their pool, and Creator will calculate a price (based on the standard pricing I entered into a table). Can someone please help? thanks!
Cannot Create Report
When I try to create a report I get this message " You can only have a maximum of 2 reports under this account. Kindly upgrade to a suitable plan to create more." The thing is-I have no reports at all. Any ideas? Thanks.
does a zoho form have an email address and can I send an email to it
so that the form fileds are filled with appropriate content? would be awesome. what API do you offer for integration with a third party tool, so the form can be filled with information from that tool?
browser based inconsistencies using zc_LoadIn=dialog&zc_NextUrl=
I have recently built an HTML view which works very well. From this view I have two main options. I can either select a listed record for editing or choose to add a new record. Either option loads the appropriate form as a popup in Chrome. As far as I can tell, choosing to edit an existing record works reliably across Chrome, Firefox, and Explorer. However, choosing to add a new record is very inconsistent. In Chrome, when trying to add a new record, the correct Form opens as a popup but with
After linking with Google apps, no users can see Creator app
I can still access my Creator application here: https://creator.zoho.com/justinroffmarsh/engagement-update However, the application is not visible to ANY user via Google Apps (or via any other means, other than that URL). My domain is .ballistix.com My ZoHo username is justinroffmarsh and my e-mail address is justin.roffmarsh@ ... How do I reassociate my app with my Google user account (I am super-admin). I've checked admin/email and the only listed email is my Google one. Justin
select And Deselect
Here my application (this is look up filed) Real Property Titled Property Untitled Property Digital Assets Custodial Accounts All Categories If i select All category .. every category has to select . if i deselect that will not select .for that i write code like this if (input.Choose_property.contains("All Categories")) { Choose_property.selectall(); } else if (!input.Choose_property.contains("All Categories")) { Choose_property.deselectall();
Changing Single line to Drop Down
I am not able to change a field from single line to drop down. I tried to delete the field and re create however it keep giving me a script line I need to change.
select and deselect application
Here my application (this is look up filed) Real Property Titled Property Untitled Property Digital Assets Custodial Accounts All Categories If i select All category .. every category has to select . if i deselect that will not select .for that i write code like this if (input.Choose_property.contains("All Categories")) { Choose_property.selectall(); } else if (!input.Choose_property.contains("All Categories")) { Choose_property.deselectall(); } But if
Use data from a view
I am wanting to have a button on a view that is next to every entry. When I click the button I have a form that pops open in a new window. That part works fine, but what I am having trouble with is that I have a cell called company and companyCode that I would like to pass from the view to the form and have that populate the form in the correct fields. Is that possible?
How to get form data inside an HTML view??
Very simple app. Enter a repair in the form, hit submit and the data just entered should automatically show in a custom html view that then can be printed as a receipt. I am at a loss on how to get the html thing to work with the data in there among the html. This is my script from the form 'on success': openUrl((((("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/Print_Reparation_Custom?ID=") + input.ID,"Same window"); And here is the content of the HTML view
location of 'custom filters' in the filter list
could you move the location of 'custom filters' in the filter list from the bottom of the list to the top of the list? thx. hughes
Delete information
Delete Here delete is a radio button ------> while clicking on Delete one popup( or alert) as to show " Are you really want to delete the information " with "yes" and "no" options -----> If "yes" then the information has to delete from database , If " No" the information won't be delete and the alert(or popup ) as to close .. please help me out with this application Thank you
On Success Clear Form
After the user clicks on the Submit button, I need the form to reset itself to the default values. How do I accomplish this? Thanks
Delete information
Hi Delete (radio button) While Clicking on this , Property Name and Property Type fields will show Then on clicking on Continue button alert has to come ALERT " Are you sure you want to delete this asset and all related data? If Yes = delete are data records pertaining to this asset else Go to other page Will you please help me out with this application thank you
Help with views please
Could you point me in the right direction please I have a form with a dropdown field that has 18 choices In the view for that form I want to set the criteria based on that dropdown form do I need to create 18 seperate views with the criteria set on each view or can I create one view and select the criteria each time before the view appears?
open to URL on edit
Hi, would you mind leting me know why when I use this instruction in an "on edit/success" does not work even thouh it does work fine when using it in the same form in the "on add/success" case? in the on edit case, it can't fetch the data as if it did not recognize the ID parameter... openUrl("#View:F1_Detalle?F1_IDstring=" + input.F1_ID, "same window"); The form is called creator/yaxche/sistema de operacion yaxche/Archivos thanks Luis
Integration with Zoho Support
Do you have plan to make the same integration like zoho invoice or zoho crm but with zoho support ? Zoho Support does not support business logic for each field of the request form (on user input or on update). It would be helpful to create widget in the customer portal home page of Zoho Support with Zoho Creator (same as using zoho creator inside zoho crm). Otherwise, another idea, be able to schedule a script in zoho creator to retrieve all close tickets of the last week inside zoho support in
order management view part
Hi I integrated order management application in my form my application like this property name : ---------------- Any other copies property (add + ) person name phone email ------------------- ------------------ ------------------ ------------------ ------------------ ------------------ adding the number of persons information .this one is working fine But Now i need the view part in my
order management integration
Hi I integrated order management application in my form my application like this property name : ---------------- Any other copies property (add + ) person name phone email ------------------- ------------------ ------------------ ------------------ ------------------ ------------------ adding the number of persons information .this one is working fine But Now i need the view part in my
Related Forms
I have a parent form which is a company. It has a T-E-N-S number. Then I have children forms which are Mobile websites and Apps. These all have T-E-N-S numbers too. T-E-N-S numbers are a 10 digit ID which represents online assets owned by companies. I want to click on a company, and see which apps and mobile websites it has. In salesforce, this is a related object, and a related list. Here is an example Company Form: T-E-N-S Company Name Phone 1000022222 Microsoft
hi im trying to send emails from a chech bo
Hi im trying to send emails from a list of 7 check boxes. i have inputted this code suggested by zoho but i cant get it functioning the form is here at this link. https://creator.zoho.com/timgarrett111/project-charter/form-perma/Projects_Tasks/ help would be very much appreciated. on success if (Do_you_want_to_email_this_to_members.contains("x")) { sendmail ( To : "x" From : zoho.adminuserid Subject : "Subject of the email" Message : "Your message"
bigint error using USD currency columns on stateless form
I am trying to capture changes to a currency (USD) data type column on a stateless form and get the following error when trying to save the script with this statement (x.Pay_1_Amt=input.Pay_1_Amt;). Both columns are USD currency data type columns as near as I can tell...... Error in statement at line number 6 The field x.Pay_1_Amt is of type BIGINT. But you are trying to update it with data of type DECIMAL Any suggestions are much appreciated. Thanks.
How do I Copy Fields from One Form to Another
This is probably a stupid question, but I am very new to database creation and have no experience with scripts or anything; but I am trying to learn. I have two forms: Existing_Activities_University and Contact. They are both Subforms to University_Data. In the Contact form, I have a checkbox field that I would like to have show up in Existing_Activities_University. I would like for this to be dynamic, i.e. if I add or change fields in the checkbox in Contact, I would like the field in Existing_Activities_University
Order Management application
In Order management application can i reset Submit and Reset Buttons - > Continue and Back i.e Submit -> Continue Reset - > Back Thank you
On Success print Print_rep view
On Success script: openurl (((("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/Print_Reparation/ID=") + input.ID,"same window"); ID is checked in column properties - works great Now I tried to create a HTML view so I could format the output. I get the message that the ID variable is not defined. There is no 'column properties' - so how do I define this variable that contains the last or active record ID? (I just started with zoho and find it completely awsome although
Data Validation Before Sending to Email
Hello, I am a newbie and I have created a form that my colleagues can add information like -- email, contact name etc. After adding the information, I wanted to validate the data entry and send a custom email to that email generated by my team mates. I hope you could help me figure it out. Many thanks. Cathy
Ordermangement Validation
In order management application , If i select any order item twice or thrice that should give a alert that "You already selected it ". i. e order item should not be repeats , is their any code for this . Please help me out Thank you
Delete information
Hi Delete (radio button) While Clicking on this , Property Name and Property Type fields will show Then on clicking on Continue button alert has to come ALERT " Are you sure you want to delete this asset and all related data? If Yes = delete are data records pertaining to this asset else Go to other page Will you please help me out with this application thank you
Backup
How to backup to my hard drive, all of a database ?
Next Page