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.
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!
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
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();
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
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
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
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
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.
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
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
Private App + embeded HTML view + no-login-needed-code = images wont render.
On my website I have an HTML view, when the app is public, images render fine. But when my app is private, and I add the no-login-needed-code. Images wont render properly.
Training Application Help
Currently we have an application that is used for training purposes. There are (2) main forms and (2) views: Forms Add Courses Course Registration Views View Available Courses (includes a custom action to register for course that is sent to the course registration form) View My Courses (based on course registration form, but filtered by status == "registered" and zoho.loginuserid) I think this is a simple problem, but we are trying to get the View Available Courses to only show the courses which
Masked Password Field Support
I'd like to create a newsletter registration process that includes the creation of a password for every user but I want the password field masked. It doesn't appear that this is supported? Please confirm and provide an alternative solution if possible.
Adding user to Zoho Discussions
I have a screen "User" in my Zoho Creator app. when new user is being added, I have a code to automatically share screens with that user and so, Zoho will automatically invites that user to the account. I need to automatically add this user to Zoho Discussions as well. Idea is that these users should be able participate in future discussions. Can it be done programmatically?
Get CRM ID for further fetching and update
Hi, I'm trying to get Campaign ID for CRM. What is the correct way to write Campaign Id to get ID for further update ? It's working with all fields but not ID... Thanks. crmResp = zoho.crm.searchRecordsByPDC("Campaigns", "campaignname", input.Campagnes_Promotions); for each r in crmResp { Budgeted = r.get(("Budgeted Cost")); Actual = r.get("Actual Cost"); input.CampaignID = r.get("Campaign Id"); }
sort() function is case-sensitive
The sort function is case-sensitive, which is really problematic for me. My list is being sort as Aaa Bbb Ccc aba When I would prefer it sort as Aaa aba Bbb Ccc
Button positioning
Hi , Is there any possible to Move my Continue and back buttons to left side or right side . Thank you
Parent child - Form/subform question
Hello Zoho, I am looking into using Zoho to create a database for a newly formed non-profit. I want to track the relationship between donors and donations given. I want to be able to pull up a contact and see all of their donations on the same screen. Is this type of thing possible? I have looked at some of the apps in the Marketplace, and while I see that it is possible to link a payment to a contact, I don't see a way to roll up that donation information on the Contacts form. I used to work with
Application creation help
I am planning to upgrade to a paid version. I see that there is an annual payment option where I can get email assistance. My question is as to what extent the assistance is given? If I am planning to build an elaborate application, will I get help all the way through?? Also, what's the response time?? etc. On a sidenote, I will be integrating it with Zoho CRM which will be integrated with Quickbooks. Thanks in advance.
Problem creator-invoice integration
I have difficulties with the integration of zoho creator and zoho invoice. I copy the example provide in another thread without any luck. the application is already share for support. https://creator.zoho.com/septa/copy-of-crm-creator-invoice-integration/#Form:Create_Invoice1 The createinvoice or createdraft always failed. I also try to create a customer and it's returning a null map. super_client = zoho.invoice.createcustomer({ "CustomerName" : "test2", "CurrencyCode" : "CAD" }); info super_client.isEmpty();
Function to display multiple fields
Hi Here my application Any other Copies Yes No ,If i Click Yes -Name Field -Email Field -Phone number Fields The number of times i click Yes , that number of name, email , phone number fields has to display . Please help me out . Thank you
Order management validation
Hi , In our order management application ,The Total field value Must be 100 ,when i submit a form If the Total value is more than or less than 100 the alert has to display i.e " Total should 100 " , where can i write the validation code in order management application . Please Help me out . Thank you
function calls openurl then wait for form submission can this be done
Hi I open a form from a function using openURL and the function keeps executing can the function be made to wait for a return submission notice from the form which has been called ? So like this If a=b openurl form form has been submitted does a=c basically checking what the user has submitted, i guess if the form submission passed back the newly created ID i could go and query the record ===== Bump =====
Need to define multiple primary email addresses
Hi there - We have purchased Zoho, and plan to use it for multiple applications. The confirmation email sent on success for each of those applications needs to come from a different individual, not just the "primary email address" for the account. Is there a way to do this, or do we need to open multiple accounts? Thanks! Jess Weiss
Rest API Add record does it get processed via the forms on success logic
Hi For a form i have some Deluge script logic which i process in the "on success" section, i now want to replace this form and send the data via the Rest Api. Question when i add the record will the "on success" deluge script still be processed ? thanks
Validation of a File upload field ?
Hi, I'd like to limit the extension of the uploaded files in a form. I've written a script in the On add > Validation to check the filename. That's works correctly : if (input.FileUploadField.endsWith(".jpg")) { show or hide some fields; } Now, I'd like to check the filename before submiting the form, using a script in the "On User Input" of my FileUploadField, but the filename seems to be stay == "" and don't read the selected filename. Have you a suggestion for that please
Form is not loading in Edit Application mode
Something is corruped in my application try to Edit form in Edit application mode: ito_mu account - > EP_Attestation program, Select Systems form Form is not loading I cannot even delete this form I cannot create deluge script now for this application, and also when I try to view form definition from script mode, I get "Loading" forever. Please help me out here
problem with order management edit option
Hi we are getting problem with order management application which is in our shared apps. we are unable to access the edit application option, could you please suggest how to get edit application option for my shared order management application. seeking you kind suggestion and solution Thanks regards
Simple Redirect Question
Hello There, What I need to do is: after save data on Form ("on success"), redirect the user to View instead of Form. Seems that the default Form ("on success") behaviour after you save data on a Form, is to be redirect to same Form, but instead of this, I would like to redirect it to View of that Form. I am new on Zoho Creator, but before I make this question here, I tried to find out the solution (without succeed). Thanks in advance Juliano.
Next Page