Creating a professional-looking PDF catalog from an HTML view
Hello there! I am currently experimenting with the PDF exportation of an HTML view I created. I would like this PDF export file to look as 'professional' as possible, meaning I would like to be able to print it out or mail it to clients 'out of the box'. This html view displays the result from a search query within the records stored in my form: it shows a list of project references, each one complete with a couple pictures, and a definite set of information. Right now, I am still encountering some
Using year (yyyy) from date field
Hi everyone, I want to know if possible from a date field to take only the yyyy portion and store that into another filed, let say a number field. I have a form with Invoice Date (i.e. 30 April 2011) and want to store 2011 into other field, can someone tell me how to do that? Thanks a lot.
Default entry in field
I created a form in Zoho Creator and imported a .xls spreadsheet with the following fields: telephone number name address city state All of these records are empty with the exception of telephone number. I would like to know how to show the telephone number in the form by default.
Fetching the NEXT record
Can someone explain to me how to do what must be a common requirement (I'm New ) . . . I have a form & View (let's call them the original Form) and want to create a new form that I can 'page' through the records in Original form. So I guess I need a Next & Previous button on a 'Stateless?' form. Then how do I get the buttons to get the Next or Previous records?
Express Editions
Interesting... John M. Whitney
Allowing customers access to read only databases
Hi Please see below, can Zoho Creator do this and what version would cater for it. Also which version would we have to buy while we only have 5 customers One of my web design clients wants to give their customers the ability to log on and view a specific access database in a read only format. They currently have 5 clients that they want to do this for with plans for this to expand to 20 in the coming year. The databases are large up to 1 gb including associated folders . Obviously each client is
Create record from html view
Hello, I would like to know if it's possible (and how ) to add records using a html view as if it was a custom made form using html input elements. Thanks!
Question About Functionality
Hello, My company would like to implement the following idea and I wanted to see if your platform is built for it. The idea: Friday Focus. What it is: A tool that forces people to start thinking about what they need/want to accomplish the following week. Every Friday people spend a few minutes filling out an online form, and on the following Monday morning they receive a copy of it in their inbox. This helps kickstart the week. How we want it to work: - Every Friday an email goes out reminding the
How can you remove only certain items from a dynamic picklist?
Hi, this is driving me nuts and I'm wondering if someone can help me figure out how to make this work. I'm a newbie to Deluge and Zoho. I belong to an organization that provides teams of mentors to mentees. I've created an application with the following forms: Contacts - where the Role can be defined as a Mentor, Mentee or several other fields Mentorship Teams - where you can associate contacts based on their role on the team Mentorship Team Meetings - where we track who attended and what happened
Show .xls data in a form
I need to know how to show .xls data in a form.
Is it Safe to change the "Field name" for a lookup via the form definition
I have a fair amount of info in Zhoho at the moment so thought i would ask I want to change the Field name (refer to another field) on an existing lookup in one of my forms There does not seem to an option via the Edit Field properties but i can see how it is declared in the form definition Has anyone ever edited this directly ? So far i have been creating a new lookup with the new field and deleting the old existing, however as the existing lookup is tied to Deluge actions it can be a pain as you
Customize Forms
Hello, How can I customize the following form? https://creator.zoho.com/gnachtwey/friday-focus-application/# I would like to add my company logo to it and adjust some of the spacing. Is this possible to do?
Zoho Creator is DOWN
Can fellow users confirm with me that their Creator applications are down right now? Thanks!
reports not showing all records in table
Hi, For some reason, looking at a view of one of my tables (MyResponse View) displays "x" number of records. When I access the table via either of two reports (My Studies - Diet Type Frequency or My Studies - Exercise Type Frequency), most records are not displayed. The discrepancy between records displayed when using MyResponse_View and either report is significant. I have deleted any filters the reports were using without success. I have regenerated the reports without success. I have deleted
Cannot see my post about ASP.NET
Hi, I added a new post yesterday and I cannot see it... I am very new to Zoho (6hrs old). My problem is I have to add records to zoho through my ASP.NET application. My Questions are: 1. I don't understand about the ticket... it expires every 7 days? meaning I have to generate the ticket every 7 days with in my app 2. Any sample will greatly help Thanks
Fetch records WILL not fetch Rich text and WILL not fetch URL fields?
It records these but WILL not fetch them back? My form fetches everything but these? Anyone? Please?
The NO - REASON SALE
It's none of the holidays nor is it an occasion to celebrate. But we thought, we didn't need such special occasions to express our gratitude to our loyal old timers.. Presenting the NO REASON SALE at Zoho Creator. Get upto 20% off on plan upgrades to longer cycles. And if you still haven't upgraded your Zoho Creator account.. Now would be a great time to do it. Offer valid till 5th September 2011. Head over here for more details. Its time to ... Up.. Up .. and away Upgrade... Thanks Aparna
Limitations on HTTP Post?
I tested my AWS-SES/ZC app this weekend by attempting to send 200 test emails. After about 90 I got an exception violation as the http response from the post. Querying my Amazon account, I did not see any issues. I'm assuming the fault was on ZC's side. So I'm wondering if I've run-up against some limitation with http post? When I post to my PHP api, the deluge statement is AWS_POST={ "FROM" : input.FROM, "SUBJECT" : input.SUBJECT_field, "BODY" : BODY, "SUBSCRIBERS" : SUBSCRIBERS }; From, subject,
Newbie Question: conditional expressions in zoho creator forms
I am trying to build a form in Zoho Creator that firsts asks the user to choose one of three options from a drop-down menu, then assigns a value to that entry based on what the user chose from the drop-down menu. I am currently using a conditional expression that looks like this: if((DropDown == "Option 1"),10,0) The problem is that if the user picks anything but "Option 1" from the drop-down menu, the value assigned to that entry will be 0. I cannot find out how to use the "if, else if, else"
Script reformatted to single line
I've written a script and it looks fine initially when I paste it into the Zoho scripting tool. However, when I save, leave and come back, the script has been reformatted to be on a single line. This makes it impossible to edit in the scripting tool. Is there a way to prevent it from reformatting the script? Thanks!
How to delete a Form and a View
Hi guys, The title says it all actually. I have one application that contains two Forms and two Views. I wish to delete only one of the forms and ones of the views. Thanks
How do I update a date field within a form when a user modifies another field (example approves the form request)
Totally confused! I'm trying to declare a variable and fetch the most recent record when field is updated. I don't know the fetch arguments in order to update the particular field. (My application has a form to request $ for loans...I need a date stamp when the user approves or rejects it.)
Form validation on edit not working?
I don't think it's me, but knowing me it probably is. The field validation that was working before just stopped, seemingly out of nowhere. When I found it not working I then tried to get just a basic (if this input doesn't equal this number then alert and cancel submit) and still no go. Here's what I am trying to get working: if ((input.Status == "Repair") && ((input.Repair != "Sanding") && (input.Repair != "Lamination"))) { alert "Don't forget to mark who's repairing it above";
Order management
Hello! We have online store and I need online management software. I know that it is possible to do but all solutions are very simple. I need to: 1. make a new order 2. attach new or existing customer 3. add MULTIPLE goods to one order, NOT ONE. There is no problem to add one good to order. How could I add multiple goods to one order? There is lookup form but it's not convenient to manage and edit orders. Are there any ideas or solutions? Zoho CRM is very complicated, Zoho Creator should solve
Creating a "table" form input
Hi, Is there a way to create a table that a user would fill out? For context, I'm trying to create a table that has "Cost Center", "Cost" and "Tactic ID" as the column headers and would like the user to be able to enter multiple lines (i.e. split the cost of a project across several cost centers. Is there a way to do this? Thanks!
Referencing a formula field from another formula field
I am new to Zoho, and building my first app to calculate sales commissions. I understand from other posts and the user guide that you can't reference a formula field in another formula field. However, I need a way to do the following, which I'm sure there is a script or other work-around to do: Revenue (Currency Field) Overhead % (Percent Field) Overhead Rate (Formula Field) = Revenue * Overhead % All of the above works fine. However, I can't figure out how to do the following: Net Margin = Revenue
Very Confused Newbie re: Public Forms...
Ok - I have spent far too many hours creating a multi-page form, but everything is essentially working except - I have spent hours trying to figure out how to allow my customer to fill out the form. If I make the application public, then the customer sees all of the application, views, etc., which is not good. If I make the application private, then the customer needs a login, which they won't have. I tried using the permalink code without login, but then I haven't been able to pass the record id
Type mismatch seems bogus
Problem: I built a multi-page stateless form, following the excellent example of the Summer Camp Registration. The pages 1 & 2 both store fields in the master form, as expected. When attempting to follow the same process on page 3, I cannot add the code to the form definition, because I keep getting an error modifying the page, as follows: The field rec.TargetRevenue1 is of type BIGINT. But you are trying to update it with data of type DECIMAL However, the fields TargetRevenue1 and the corresponding
Internet Explorer 9 support
ZC Team, Internet Explorer 9 was launched a few months ago and it is already delivered to Windows Vista and Windows 7 users by OS automatic updates. Have you plans to include it soon in the list of supported browsers? Regards, George
HTML view has lost all formatting.
I have created a couple of HTML views, which display as brochures, with the required property information as entered into my database. Everything was working correctly, until an hour ago, and now the CSS formatting which was being applied appears to be ignored, and all elements are simply listed one after the other on the page, in plain text. Here is the link to the view: https://creator.zoho.com/4732209/propertyprosperity/view-perma/Standard_Brochure/PyRNmxShbOzrD941hzp2uYY4YqASNa0Jy6COSTdAVhuQq9OmC3bddFTzAB3176VZSsCRxGzdmOYg3SqhWgSOV8KP5dCvEksDvCUC/?recID=623880000001192015
2 Views - Different User Restrictions - Photo shows for one user but not another
Hello, I have a membership application that contains member information. Since there is no way to control access permissions between various users I have done the suggestion of creating 2 different views All_Members and All_Members_Restricted. I share All_Members to users that I want the Edit and Delete links to appear and for the users I don't want to give edit and delete capabilities to I share the All_Members_Restricted. This works fine except for one major problem. I have a photo upload and a
Can ID be used on multiple forms?
Since ID is unique for each record, I guess I can't set the ID of a record in another form, is that correct? Since I have a record that's starting on one form, and transitioning to a separate form, in order to keep a link to the original record, I assume I must create a third id type field for the two records on the separate forms to share - is this correct thinking? Thanks! Kenny
Can the Add/Edit form for a View be made to contain only the fields in that view?
I had assumed that, when I have a view with a subset of the fields in the main view, the Add/Edit form would only show the fields in that subset. That does not seem to be the case. Is there a way to make this work?
Dynamic Picklist - retaining field values on edit/update
Zoho Support, I am using dynamic picklists in an application and adding records works as advertised. When editing the record, however, I am using an "on load" script to re-populate the picklist values. This re-load of the picklist values is causing the original entry to be removed. Is there a way to keep the original field value intact, while re-loading the picklist with new values?
Send email task with embed HTML view
Hi, I create a html view in Creator. I would like to embed this html view in message field of sendmail task. The embed url is a Functional-based URL. I try to put iFrame code in the message field, and the html can display in the message box, however, after send the email to my mailbox, I can't see it in Gmail or Outlook. How can I embed the html view in sendmail task? The url look like this https://creator.zoho.com/123/salesforce/view-embed/Enhtml/JjZSkMMXHUVmSwWjvHRNf6n6/code=123 Thank you.
Fetch Records Based on Two Conditions
Hi: I am trying to Fetch Records based on two conditions. This is the general idea of what I am trying to do, and I realize the syntax is not correct: statelist = Grove[Field_Name == input.Field] sort by Grove_Name && statelist = Grove[Scout_Check == "Grove Check"] sort by Grove_Name; Does anyone have a suggestion on how to make this work? I am new to Deluge. Thanks!
Create List , List String Syntax Clarification
Hi, Need some clarification on using List String The developer Docs here says https://help.creator.zoho.com/Create-List.html list4 = List:String(input.Country + ", " + input.Name); For me this gives a deluge error "Invalid argument. List expression is expected as argument." Not until i insert another pair of { } of braces can i get it to work list4 = List:String({input.Country + ", " + input.Name}); Either there is a bug in the statement or an error in the docs, Can someone please clarify Regards
can't open any View with type "HTML Page" in my app
I can't open any View with type "HTML Page" in my app in Zoho.Creator. Yesterday everithing was ok. Nothing was changed. But now it's not work.
Calendar view bug - View, Edit, Cancel loop
In a Calendar view, my users get stuck in loop of modal boxes when they: click a record to view details click Edit click Cancel click Close click Cancel click Close repeats...Of course, the trick to closing these modal windows it to click the "Close" button in the top-right corner. Please make the "Cancel" button close the Edit modal window. "Cancel" functions as expected when in a List view.
Can´t save view
Hi Zoho I have a problem with saving a view. I wish to remove "entre" + "billetpris" from: https://creator.zoho.com/runehagel/events-cafezusammen/#Page:Informationer_til_kommunikation I however get the following error when trying: "FAILURE:Error occured while saving the view. Kindly refresh the page and try again later". I have read in other topics on this forum, that this should be a problem on the serverside. Can you please help me ? Regards Rune
Next Page