copying the field from a different form
Hi all, I somehow have troubles with finding the answer to this simple question. I have two forms: -Companies -People Form Companies has 3 fields: -company name -telephone -address Form People has 4 fields: -first name -last name -company name (a lookup field) -telephone (I want the field to be automatically filled) How to set the field “telephone” so it automatically copies data from the field in form Companies ?
zc_ variable for private key
Anyone knows the zc_ name that we have to use to pass the secure key when we to insert view in html view without user login ? The insert view in html view is better than the regular IFRAME. <div elName='zc-component' viewLinkName='Rapport_des_rdv_View' params='zc_XXXXX=CM53WNP4jg8Bvt4pOKYAjeB78hSAeX99C86uBwAwUM3HkygeX1N9787f48EqkRTTBthhdKM9g5gwBxFBNPz8vVG2VPQXRK2pE&zc_Header=false&zc_AddRec=false&zc_EditRec=false&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_RecLimit=false&zc_SumRow=false&zc_Summary=false&zc_RecSelect=false'>Loading
HTML view + css: Chrome [blocked] The page at ... ran insecure content from
Hi everyone, I'm using a couple HTML views to display some contents on my website. The css formatting for the view is processed through a link to a css stylesheet on my server. Everything works fine on Firefox (see for ex. http://www.meridian-online.com/about-us/ -- scroll down), but I discovered Chrome blocks the loading of the CSS stylesheet... According to the developer tools, Chrome detects that this is 'insecure content.' Any way to circumvent this issue? Without the CSS, these views are rather
Show record data in form - but not allow edit
I have a function which brings up a stateless form and populates it with the current record information. The user then will edit some fields and click submit to update the record. I would like to make certain fields like redord ID, Name, etc, show up as plain text rather than in a editable textbox -- in order to show the user which record they are working on, but not be able to edit the information. Is this possible?
Search and Auto Complete
We are experiencing a problem with the Search and Auto Complete feature on some pick list fields. Our users love that the forms load faster in the case of very long lists and love that the search feature in addition to 'starts with' handles 'contains'. But, the pick list does not always populate with all the available selections. We understand that with the Search and Auto Complete option selected, by design the pick list only partially populates until the user requests additional items via search
creator custom domain for app
hi how can i share my app with custom domain name? for example appname.mydomain.com or custom-domain.zoho.com
Focus Traversal in forms seems to be vertical only
I've created a simple two column form like this: But I find that when I use / preview the form, the "focus traversal" is not horizontal but vertical. When using the form, after I fill the value for the left field of the first row, and I hit the tab key, the focus goes to the left field on the second row, instead of the right field of the first row. I think this is not intuitive, and I can't seem to find a way to make focus traversal be horizontal rather than vertica. ¿What can I do about this?
Has JSON Changed?
The url for viewing JSON data https://creatorexport.zoho.com/adminname/appname/json/viewname/ Used to display the feed data in the browser. Now it wants to download it as a file. I think this may have messed-up my application. Cheers, John Whitney
JSON feed does not display all fields in combined view
If we have a combined view and it happens that a field from the related form has the same script name with another field displayed in the view, the JSON feed does not display both fields, but only one. For example, let's say that we have a view based on Kids form The form contains the fields Name , FatherID (lookup field to Fathers form, which also contains Name field) , MotherID (lookup field to Mothers form, which also contains Name field). If in the view I display Name, Father Name (FatherID.Name),
Connect to an existing SQL database/server
Hello Guys, Apologies if the same question has already been asked, but i am having trouble understanding how to connect an existing SQL database to Zoho applications or if it's even possible to do that? Our current system is currently using an SQL database, so we would like to use the existing SQL database with Zoho creator applications. Any advice would be truly appreciated.
Invoking user input within a custom action
Hi, I'm a newbie and am struggling with how to approach this. I have two custom actions in a view - Pass and Fail. An example of pass is as follows: void test.PassTest(int id) { rec = Testing [ID == input.id]; rec.Outcome = "Pass"; } What I would like to do is when this button is pressed in the view the function prompts the user for one or more additional fields. I have created a stateless form but cannot see how to invoke it or pass the values from the form back. Is anyone able to provide
Edit data directly
In addition clicking on the 'Edit' icon to edit existing data, I would like an additional quicker way of editing data. Specifically, I would like the ability to double-click directly on any of the data fields of a 'View' which would open the field up for editing. Thanks.
forms and permissions - is it possible
Hi all, I have a question regarding forms and permissions. I have two forms:- People - Project The User inputs data in the form Project. Fields also include fields from the form “People”. When User inputs data in the Field “Name” in Project, he firstly is able to check whether certain person is already present in the database, if yes he can simply add this person to the project. If no he inputs new record, which is automatically copied to the Form “People” User does not have access to People View:
Internationalizing an application
Hi, I am building an app for a recruiting company that takes applications in four different languages (English, Spanish, Tagalog and Hungarian). Is there an easy way to 'internationalize' the app? By this I mean I want to be able to re-label all of the text fields in the appropriate language. My initial thought was to use stateless forms to populate the main form. However, this won't work because I am using sub-forms. The only other option I can think of is to just duplicate the form and change the
Free Flow Script - Chrome visibility
The problem occurs in the Chrome browser. When I view script via "Free Flow Script", I do not see and cannot edit anything. When I change to "Script Builder", I can see and edit the code. It was working fine yesterday but I cannot edit my views, forms or functions using the free flow script editors. Can someone please investigate? I have tested it with IE and Safari and it appears fine.
SQL statements in Zoho
I am now beginning to understand Zoho a little better. Obviously there is some sort of database in the background that is at work when we use a Zoho app we have created. 1) Is there any way to have access to the database for my app through SQL statements either to execute some sort of transactional statement or statements? Ex. "Update mytable join mytable2 on . . . set myfield=1, myfield2 = 2 . . . where . . ." "Create table . . . " Etc. In some of these cases we would need to know to to access
I need a piece of code to clear certain fields on user edit.
Alright, Basically, I have a form (current form). Once I add/update a certain field, the records of that row of that field is copied to archives. So I need it to clear certain fields (on the current form and not the archive form) once I update this certain piece of information. For example, (This is a bike application) Customer checks out bike 1, once the customer brings the bike back (actual check in date), that row of records will be moved to archives. i need it to where i can clear certain records
openURL - popup window works but same window and parent window do not
I have multiple stateless forms embedded in my website. When the first form is completed the user presses a button which is supposed to load the next form. I am using - openUrl("#Form:Client_Information_SL?Client=" + input.Client_search, "same window"); behind the button. When I click the button which runs the openURL command nothing happens. If I change "same window" to "popup window", the correct form is loaded as a popup and overlays the previous form. In other words, the "popup window" parameter
sharing form with public
I cannot seem to understand how to allow the public to access an online form I create ... I simply want to create a registration form, then send out a link to the form ... how can I do this ? I am a free member -- does this functionality require upgrade ? I am missing something here, I think :) Thank You Bill Clark kappclark@yahoo.com
Criteria in a view of a form with a subform
Hi all I have a form (treatments) with a subform (payment cards). In the subform I store each card payment. One of the fields is the due date of this card payment. I want to show in a view treatments that have their overdue payment last letter (dated before today). The problem is that it shows all the treatments that have some payment card with the date before today, instead of displaying only those with the date of last treatment before today.
Bug: Red line covering on-click
This is under my other account: sigroup/si-ni-chemical-inventory using IE 9.0.8112.16421 The red line prevents me form editing the code. Also this form is not working. Shared with support.... Cheers, John Whitney
Can't edit our apps - Enterprise user - Urgent!
The Zoho Creator app editor appears to be broken for our main enterprise account. The main account holder is Danny Quarrell, dannyquarrell@altaplanning.com. Neither Quarrell or any of our assigned developers can access the app editor for any of our shared apps. URLs such as https://creator.zoho.com/dannyquarrell/form/286/edit/ load blank screens. The editor appears to work fine for personal apps in other accounts (e.g. https://creator.zoho.com/dmoskovitz/form/14/edit/). I tried different browsers
Any tips to show embedded slideshows?
I'm looking for a way to build a small knowledge base that will include Zoho Presentations. 1. User opens the KB view to see all the articles. 2. User clicks a custom action (button) on one of the rows to display the record. 3. The record pops up in VIEW mode and has some descriptive text along with an embeded Zoho Presentation. Is something like this possible? Thanks, Jeff
Need to Setup Schedule for Jobs 2 Months Out
I'm trying to use the Zoho scheduler to remind employees of jobs that are 2 months out (from current date). I'm using the custom schedule option. So, I'm trying to first fetch records with the following criteria (in the fetch records GUI): zoho.currentdate.addMonth(2) >= Job_Date1 Job_Date1 is the date field in my Jobs form. It's listed as a "Criteria Fields" in the fetch record GUI, but its not in the "Variables" area of the GUI. I assume that it needs to be in the Variables area which is why
Remove "null" values from email
Hi Is it possible to remove the fields with the value "null" on the email notification that Zoho sent out? BR Dennis
How do I split up applications?
I was just wondering how specific I make an application. For example let's say I have 3 clients. Do I make a single application for each of them them put their appropriate forms in that application? Right now I have different applications for each appropriate "table" and then for each client. So I have applications for "Company 1 Clients" , "Company 1 Staff" and "Company 1 Jobs". Then "Company 2 Clients" etc. Should I just make 1 application called Company 1, then make a form called clients, staff,
Subform Edit Bug: Can't add a new record through subform link
Greetings! I have three forms: 1. Enter Class/Event/Task (parent form) 2. Attendance (subform) 3. Add Clients Attendance has a lookup field that pulls from Add Clients, and "show a link to add entries to Add Clients" is checked. For the parent form, everything works smoothly when adding new records. However, when I go to edit that parent form, and I click on the link in the subform that is supposed to let me "add entries to Add Clients", the LOADING indicator appears and never stops. It keeps spinning
send mail to all email address from a specific database
Hi , what i want is to automatically send an email after a specific field had been completed by 10 users ( a form that contain a email address ),after the after the tenth user has completed that specific field , to all 10 users email address that completed the form . something that collect all email addres that had been submited ( like a address book ).
Missing field names
I have a form that loads data using several lookup fields. This works fine until in another form I use a lookup field over the first table of data. When I go to the display options to choose the data the fields in the table that were lookup fields in the original form are not in the list even though they appear in the table view of the first form. Why can't I access these fields?
How do I enable the 'Import' functionality on a View for a non-developer/admin user?
I can't seem to figure out how to enable the 'Import' functionality on a View for a non-developer/administration user. Is it possible to allow regular users to do this?
blank edit page
Hi, I don't know what I have done but now when I click on the edit of a record the page appears blank Please help
Disappearing data
I have a form that has several lookup fields. When I enter data into the form and execute the dropdowns to choose the data for these fields all goes well until I look at the view for that table. In two of the lookup fields the data only appears in one record of the several records in the table. Then if I create a new record the data in the record that shows data in the two lookup fields actually moves to the new record and leaves the other record blank in those two fields. What is going on?
User Input wiht NULL
Hello, i have this script on Validate: if ((input.Office_ID).length() != 9) { alert ("Office ID Amadeus must be a length of 9!"); cancel submit;} how can i change the script, when the user dosen't input any value? this field has don't be a required field. thanks Carsten
Medical Encounter Form
I apologize if this is a repeat, but this is my first time using the forum.I need to create a form to document patient data,but one patient at a time. I do not need to create a database. I need to view the form in an easily readable document, like Word or PDF. I then need to email the document to be included in an Electronic Medical Record. I also want to export it to be included in Zoho Creator or Projects. Thank you
Evaluation: If I can't do this, Need go no Further....
We are still evaluation Creator and have begun to make some basic forms and views and reports. I have been very impressed with the power of the app and very excited to move forward. But the following is the main requirement, and if we can't do this I cant see any need for going further. We create a recipe and add ingredients. we know the percentage that ingredient represents. We know the cost per lb of the ingredient. We know how much the total recipe represents and therefore we can calculate the
Mission Critical - need to send a digital product on payment of invoice.
Hi Team My company sends out building inspection reports to clients. These reports are only released on payment of the invoice. Often the report is uploaded to the system before the invoice has been paid. In this case we desperately need to have an action triggered when payment is made in zoho invoice, so that our creator app knows to release the report. Ideally this should be instantaneous. At this stage the only way I can think of is to have a scheduled event within creator check the payment status
Send email from different user (not adminuserid or loginuserid)
Hi Team I have a scenario where I need emails to go out from a specific users email address on submission of a form that has been embedded on a website (to an email address entered on the form). This user is not an administrator, nor does the published form require anyone to be logged in. If I try to specify an email address in the "from" field it tells me that the "to" field can only be set to an adminuserid. Is there any way to have emails originating from regular users on submission of a form
History for an form?
Hello Guys, i'm very new to Zoho Creator it's an very useful Database Software. How can i add an History to my forms? that i can see which data has change? would it be possible to see all changes in an grid view? Thanks Carsten
Medical Report
I need to create a one monthly report for each patient, then email it (or print it) to a referring doctor. The report has multiple fields, which I created. How do I create a full 1 or 2 page, easily read report for EACH form submission, and export it?
Calender help
Expert help please... Fields Name John Smith Place At the office Time and date 15/03/2013 14:25:00 How do I send this data to my zoho calender Thanks
Next Page