Create a table form to insert data (two-ways table)
Thanks in advance to everyone that will response to my question. I have to create a form with a two-ways table layout to insert data in a project, like the attached image. In which way can I solve it? Any idea is really indispensable for me, because my project has stopped because of this problem. I can't solve it with API because I have a lot of entries in that table, and it's not really simple writing a line for each entry. Thank you very much, Dr. Marco Tironi
Changing the value of zoho.loginuser
For testing purposes, it would be great if a developer of an app could change the value of zoho.loginuser. I've written an app that behaves differently depending upon who the user is. For testing, I have to login as each person to verify their roles. It would be better if I could simply change the value of zoho.loginuser and effectively become that other user without logging out and back in so frequently.
Adding Sum of fields
I am trying to track some payroll information I have used drop down menus: (supervisor, driver, parts employee, Crew Member 4, Crew member 5) that, when selected, automatically input each employees wages (martha mae wages, marcia troyer wages etc) by using formula of calculating the "Clean Time" field * whatever I input for each employee hourly rate. For example, we input 1.25 in the "Clean Time" field, and drop down select "Marcia Troyer" under Supervisor field, the number 13.75 automatically shows
Returning String field to Null
Can anybody tell me how to updating a single-select picklist string field to null? This portion of my application is an html view with three embedded forms and one embedded view User Navigation From Administrator Navigation From Chart Search Form Found Charts View When the Chart Search Form is submitted, the record is saved in Zoho and the html view is refreshed with a session paramater which causes the Chart Search form to reload for Add. [There isn't anyway to get it to reload for edit and
On Delete, On Validate
I would need a new Form Action: "on delete, on validate"; so I can prevent users to delete a record if certain conditions are meet (cancel submit).
Supply an "id" attribute to the "label" tag on Forms
The following HTML View htmlpage HTML_Test() <%{%> <div elName='zc-component' formLinkName='Test' params='zc_Header=false&zc_SuccMsg=Data Added Sucessfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset'>Loading Form...</div> <%}%> embeds an existing form named "Test" which generates the following HTML for use by the web browser: <input id="checkboxEl_Test_1" class="zc-checkbox" type="checkbox" onchangeexists="true" formcompid="159527000002624612" delugetype="BOOLEAN" style="" fieldtype="9" name="Test" value="Test" tagfor="formComp" title="" autocomplete="off"/><label class="zc-checkboxlabel" for="checkboxEl_Test_1" style="">Test</label>
Grouping of fields
I find myself needing to hide/show multiple fields of a form quite frequently throughout the user experience in a form. Instead of this: hide Field1; hide Field2; hide Field3; Can I do this: hide Field1, Field2, Field3; Or, better yet, perhaps something like this: Group1 = group("Field1", "Field2", "Field3"); hide Group1; show Group1; Thanks! Stefan
Map funtion argument testing
Support, Might I make a suggestion...... If someone is passing a map variable to a function and this user wants to test his map input he HAS TO RE-FORMAT his map variable to comply with your proprietary format.. Example.. A default ZC map funtion outputted to string is valid JSON.. {"key1 : "value1","key2" : "value2", "key3" : "value3"} BUT if I want to test my map argument I have to reformat my map to be like this. {"key1","value1"},{"key2","value2"},{"key3","value3"} My thought is that you were
Header Column Width
Reviewed the new info that was added in the ZC app section (nice job) but can't find the answer. * I see where I can adjust column width, however, I need the header name to wrap so that column width can be narrowed. Is there a way to narrow the column and wrap (break) the header name within its own field so that the column width can be narrowed? I played with it but couldn't get it to work properly. Many thanks...
The server encountered an unexpected condition which prevented it from fulfilling the request
I am getting the above error when i am trying to access zohocrm api through a creator application. Can anybody say why i am getting this error? I am attaching the screen-shot of the error here too. Thanks in advance for the reply.
Edit Mode Issues ...
Now that ZOHO Creator has finally (a year after the initial suggestion; but better late than never) implemented the productivity-enhancing feature where Developers can have the scripting IDE start in Freeflow Mode (i.e. whatever was used last) ... there are a few other such productivity-sapping issues that were reported on this Forum before, but don't seem to be recorded on the Issues List ... a) When you make a change to some script and click on a button to navigate away from the updated (but not
Update Syntax
I have a look up field to a table that stores the agent name and commission rate. On returning the agent name from a drop down list id like to place the commission percentage into another field can someone point me to an example. Thanks.
Setting Value to "" in the OnLoad Portion of a Stateless Form WAS Working but Isn't Now
I have a set value script in the OnLoad trigger of a stateless form that was working last week but is not working now. I need the value of a 2 radio button field to be set to "" nothing (whatever you want to call it) so that the user must select something which futher triggers updates to dropdown list lower in the form. input.Report_Type = ""; hide Class; hide Region; hide Planting_Type; hide Report_Filter; hide plain2; Was there a change made that may have affected this recently?
Tracking
I want to track the source of a new completed form (using creator) to see if it came from google adwords. Is this possible, and if so an someone give me the steps or point me to a doc, couldnt find anything through searching. Thanks JK
Saving Records
I have a multichoice field. I make changes to the field in a grid view and click save. Zoho says it is "saving records..." but never stops. When I stop it by changing to another view or hitting add, the changes I made are not saved. I have the view down as being editable by users, and have tried using both a checkbox and a multilist field. How do I fix this? Or is Zoho really this slow and I have to wait minutes for it to save?
Lookup disappears after adding criteria
I add a Lookup field. Sometime later I go to the form and edit the lookup field and add a criteria. On save the lookup field disappears. If I then go back to the form in editor mode the lookup is back. BUT, the criteria is not saved. I cannot add a criteria to a lookup with this behavior. My application is shared to support. please advise tt
Permalink of view's search result in iframe
Hi, I understand that we can pass open url commands in form submit to make then open in an iframe (when the form & iframe exist in same HTML view) - Ref http://help.creator.zoho.com/Open-URL.html However, i am trying to do a search form (stateless form) , which looks for company names that contain the search term(s). The search part if working fine. But when i try to display the search result, I am unable to use the View-Permalink of company ( separate view that has only company names, and record
Multi select names to email
I need to have a multi select box with a list of names for an email form. I would like the names to be listed as a name rather than an email address like so: Bob Frank Nancy Tom but once the form is submitted the emails would be directed to bob@domain.com frank@domain2.com nancy@domain3.com tom@domain.com The user would be able to select one or more of the names in the list to send the email to. How do I write something that can send out the email to the appropriate people that were chosen when the
not all my fields are showing. Why is this?
not all my fields are showing in a creator app in the table view. When I export I still don't get these fields but when I select "edit" and go to edit an entry its all in there. Why is this? How can it be fixed?
expand the record summary to include all fields
Hi, I am compiling a course database for our organisation. I would like to display 5 fields in the view form but allow the user to view all fields when the they click on the record summary, can this be done? and is there an option to print this selection if required. Cheers
Unselected ListBox field is displayed as -Select- in List View ...
@ZOHO Creator Team: One of my Clients notified me that a column in his List View is now showing -Select- This is a ListBox field in the Form ... and its contents are dynamically loaded in the on Load section of the Form. When the user elects not to select any of the valuesin this field, the rendering in the corresponding column of the List View is -Select- ... the user believes it used to show a blank before ... I think that is also my recollection. Has this been caused by a recent change to the
Question about limits of e-mail sent in a shared applicaitons
Hi, I have question about limits of e-mail sent in a shared applicaitons: When I shared my apps to the users "toto", and in my apps i have sent 500 e-mails today (the limits of the apps), so does my friend "toto" can use this app to send also e-mail? Thanks for your help!
One of my forms is extremly slow when adding
One of my forms is extremly slow when adding, any help? That form is specially slow in one view. Then, when I want to add a new concept in that view and I click on "Add", It takes around 20-30 seconds to open the Add Form. Please, I need any help about that. I tried deleting all the "On load" code and it still remains in the same way. Any more ideas? Thanks a lot. Sergio Galiano
I'd like to be able to import from Groove Forms
I have developed some 20 internal apps for our company using Groove Forms because it was, a few years ago, the easiest way to develop shareable applications. Microsoft has failed to grasp the beauty of Groove and is now making it just an extension of SharePoint, a product I don't want to use. I have played around with Zoho Creator and am reasonably convinced it could do everything we need. I would like to migrate my apps to Zoho Creator but I dread the thought of re-creating so many forms and
recurring service in zoho creator?
I have contacts all set up as database in my zoho creator. I need to set recurring appointments for our weekly, every other week, and every four week clients. How can I do this? I want the view to be calendar view (which it is already, but not sure how to create recurring services for each client). SOS
Checkbox alignment
Is there a way to align the check boxes and radio buttons to the left side of the form, directly under the question? I've searched the fourms and can't seem to find anything...
Complete loss of access after application name change.
This problem was very serious (from my perspective) but was fixed by eliminating "quote" characters from form and field titles! Note to all Zoho creators: DON'T USE QUOTE CHARACTERS IN FIELD TITLES!! ----------------------------------------------------------------------------------------------------------------------- I had several lists under the application title: "My Movie and Shopping Lists" so I changed the title to "My Lists". After that I now have no access at all to the forms, or the views,
Self-Customized Layout
Hello; I love Creator to bits, I just started using it lastnight, I just have one, take note ONE problem: As this is a Database, I need to customize a view with personal layout preferences so that I can print a form based on Relational data. My application needs to have a "Order Form" and an "Invoice Form" with a specific layout as per the Invoices that the company uses now. How do I do this pleeeease, or is there a 3rd party tool that can access the data and records on ZOHO, then create a "Report"
date stamp records
How do I add a Date stamp to data entered from a web form? I want to have it so the date that the web form is filled out gets recorded in the database.
Quickbooks Integration
When will quickbooks integration be available for zoho creator?
Viewing Images not working
When I go to view the images uploaded with the form in my application in Zoho Creator, the view is completely messed up. Not to mention the fact that no images showed up in the first place. I need the images to display in the views. Help please
create a PDF of completed form
Hi; i'm not a developer but i have been able to create an application that suits my needs, just have one last problem. i have created a stateless form that auto-populates data from another record within the application, but is there a way to print the form once the user has completed it? ...or even better yet, to create a pdf of the form, say by clicking one of the form buttons at bottom of form? alternatively i could redesign the form so that it is not stateless if that makes it easier. mike
Url Submit Form Questions
I want all links to show up in a new page. How do I set that to be an option that is automatically checked and cannot be changed? Also, can I propagate the "Link Name" field automatically and make that unchangeable as well? I would like it to say Visit Our Website by default.
current date and time
Hi. I am pretty new to this. I am exploring as much as i can and I am very bad in programming. I am trying to create a form whereby the first line on the form needs to indicate the current date or time as long a user wants to enter a field. But I am not sure to go about doin' that? any experts here could lend me a hand?
There is no good way to print from Zoho Creator
Is there a way to print from the "View as Summary" view? This is the ideal layout for printing. I would like a way to print data that is aesthetically pleasing and also contains the information from all 17 of my column -- one ONE page. If I choose the Print option, I am only able to print a portion of my data, and the rest is cut off. There is a HUGE need for this in my organization as we use the database in relation to clients and would like to provide them with a print-out of the data we queried.
Why can't we print View Summary from Zoho Creator?!
Is there a way to print from the "View as Summary" view? This is the ideal layout for printing. I would like a way to print data that is aesthetically pleasing and also contains the information from all 17 of my column -- one ONE page. If I choose the Print option, I am only able to print a portion of my data, and the rest is cut off. There is a HUGE need for this in my organization as we use the database in relation to clients and would like to provide them with a print-out of the data we queried.
Custom Size MultiLine (textarea)
Is there any way to specify a size for a multiline text box? I want some to only have 2 lines worth of text space used in the form, and I would like others to be a very large area for writing a whole email in the form. Any help is greatly appreciated!
Vendor "fixes" e-mail and breaks the Zoho Email Data into form functionality - Can anyone help?
All, We have a process that has worked like a charm for nearly 2 years. From a vendors site an e-mail is generated with dynamic info that is e-mailed into our Zoho Database. The vendor has modified their code and placed a "<BR>" at the end of each line. The vendor is currently not motivated to change their code back. Is there any way from a Zoho perspective that I can work around this? Zoho will import properly up to the first <BR>... I have tried stringing the source onto one line to avoid the
Count laboral days
Hi, I want to know how can I count laboral days between two data. Any Idea? Sergio Galiano
How to let my users use my forms/views as templates and save in a different file name
I'm trying to find a neat way to all a group of users to create, manage, duplicate and share multiple 'spreadsheet' style documents based upon a pre-defined template that I create, so that the data is always in a standard form. Creator seems to get partly there but I can't find a way for users to use my forms/views as templates or for them to be able to save the data under a different file name. A simple example of what I'm talking about is quotations - multiple rows of information in a standard
Next Page