Public App Login Screen
Hi guys, I have a question that I know has been asked in one way or another before in this forum. However, I have not found answer that satisfies my needs so I thought I would ask the question again. When I develop a Web app for one of my clients using the Java platform, one of the first things I do is to make sure that only authorize users can access this app. So, A simple algorithm of how this would work would be as follows: 1. User accesses login screen and enters credentials 2. The user
HTML view as popup
Hello all, I'd like to popup an html view I've created upon the user making a selection from a radio button. I have used the OpenURL function on the "On User Input" event for that radio button. The popup displays fine but the html view doesn't display properly. Static text is displayed properly but the embedded view below the text doesn't show and instead says "Loading" indefinately. The html view is a simple combination of basic text and an embedded view in list mode. Any ideas why this is happening?
Need help with permissions for public app- confused...
I have a public app: http://creator.zoho.com/redatomnetworks/sportspenguin . The app will allow someone to list a good to be donated so others can get it. e.g. donate a chair for free and others can see the chair listed and contact the person to get it. I want to open it up for anyone to use without logging into Zoho. They need to be able to submit and edit their own forms. I dont want them to be able to delete forms at all once submitted. I also want to hide or prevent access to the Admin views
Two or More forms Insert to one Table
Is it possible to create multiple forms then insert the records on one table (or form table)?
scripting reference to bi-directional field
Hi, I've consistently had the problem I'm about to lay out in my application and thought it was a limitation of Zoho. However, I don't see it listed anywhere else as a complaint so maybe it's just our application and someone can fix it? The problem stems from bi-directional fields and trying to reference those in scripts. For a specific example, we have a Monthly Meeting form. We use this form to do multiple things, including track attendance at our monthly meeting. The Attendance field is an import
Viewing a Zoho Doc uploaded to a creator form
I attached a Zoho Doc to a creator form using the file upload field. In the view when I click on the link it asks if I want to download the file. I was expecting it to open Zoho Writer and show the document. Is there a setting to get it to open in Writer? Thanks Herb Wexler
Calculating Last Month
I have a view with a date field called Date1. I'm trying to set criteria to show only records where Date1 is last month. . If today's date is any day in October then the view will show all records with a date from September 1st to September 30. Herb Wexler
Effective input view
How can i tell a view that only un-touched form fields should be shown in that view? thanks
Filtering my drawing numbers
Hello, At the moment I have 3 forms: Drawing Customers Works order When you add a drawing number, I use a "look up" to select the customer name from the Customers form. So the creator knows that a specific drawing number is tied to a customer. In the Works order form, the user will select a customer from a drop down box, they then need to select a drawing number but at the moment it shows all the drawing numbers available. Is it possible to filter the drawing numbers that are associated with the
Go to URL & Permalink
Hi there, hope someone can help. I have a form which goes to a Thank You page (another form) when submitted. But, when I access the form via a permalink it won't go to the Thank You page. Anyone know why? Here's an example permalink: https://creator.zoho.com/activeimpact/of-course-we-can/form-perma/Event_Finance/dwWCpEGNk6HCHHugXrfnuDJk8EZbMq5PvPFewTUPgPu89VgDCz23rM62krhOUJnk09CPRgKFMBTU91GnjMmfThessn64VHe8VBZy/
Zoho Challenge API Integration
Would it be possible to get the results of a test completed in Zoho Challenge and use the result in Zoho Creator to verify a passing score? I have built a training application and certain courses would require passing a quiz before they can be marked as completed. Can anyone suggest a solution? The goal would be to get the quiz results via Zoho API and emailid (zoho.loginuserid) of user. Then when the user clicks the custom action to complete the course, it will verify that the quiz has been passed.
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
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.
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
Next Page