Import data function in Shared views
Hi, Is there a way to let a user use the Import Data in a shared view ? Thanks, Pascal Veilleux
Contact Management with time\date stamp
I created a form to enter customer information. I have two follow up questions based on that. 1.) Our clients call and give us special instructions for future jobs. What I want to do, is to enter notes when a client calls and have that be date/time stamped. A client eventually will have multiple notes with different date/time stamps. 2.) I am also going to create another form called inventory. All our clients can have inventory with us. I want to include a drop down that has all the clients
Bug: "Access this application" tab in script editor not going to correct destination
I've noticed over the last few days that when I click on the "Access this application" tab inside the free-flow scripting view, it no longer launches the module being scripted, but instead launches the general application, which is not how it use to operate and is obviously an error. EXAMPLE: Clicking the green "Access this application" tab above in the script editor now takes me to: https://creator.zoho.com/w21admin/w21data/# (the general application startup view) instead of https://creator.zoho.com/w21admin/w21data/#Form:Add_an_Event
@Ruben: As you seem to be the one who answers questions:
Could you please give me a hint about my question: http://help.zoho.com/portal/en/community/topic/how-do-i-call-a-function-from-an-expression-with-current-record-as-parameter I just became a paying customer now, so please give me a good start, I would appreciate a lot, thanks!
Expression-Fields: How to call a user defined function?
Inside a Expression Field I would like to call a function I defined. Like this: thisapp.mynamespace.myfunction(currentrecord) My function is defined as: string mynamespace.myfunction(MyRecord loc) { // do something } How do I addess the current record? Or can I only adress the fields of the record and not the record itself? Thanks for helpful answers P.S.: Why I this tagged this as "problem" and not as "question"? Because this is not documented anywhere. I considder that a problem.
Can you add barcodes to your records that once scanned will pull corresponding record?
I want to upload a barcode to each record that I entered, that once the barcode is scanned it will pull up the record corresponding to unique barcode number. Also, once the record is pulled up, it will not allow that barcode number to be scanned multiple times.
Print Forms?
I have made up several forms and want a way to both print out and to send as a file to others so they can make suggestions. I have found no way to do so other than loading up on the web site and I don't want to do so now. I tried to highlight and copy / paste into Word but it loses all formatting. Any suggestions? - jb
Notefield problem
HI Support! I have a funny problem. In a stateless form working OK I have changed a note field to a new text version. The Script is saved OK, but the change is not reflected when the application is used! I still get the old text in the form. The statement used are plain3=""; ..................... some deluge code plain3=("<strong><span style='font-size: small;'><span style='font-family: Verdana;'>A mobile number with the same last 5 digits has previously been recorded as the client turned up and
How to check the XML empty value?
Hi, Can anyone teach me how to check the XML result is empty? I have productRec.open = (r.executeXPath("/record/price/text()")).toDecimal()); Normal the xml will show <price>12.01</price> However, when there is no value sometimes, the xml show <price/> I have try priceChk = r.executeXPath("/quote/price/text()"); if ((priceChk ="")||(priceChk.length()=0)||(priceChk=null)) { productRec.open = 0.0; } But still can't solve the
Add and update a column in the Form_View
Hi everyone, I have created a simple form which contains of 3 fields: Single line: Name Dropdown: Goals Dropdown: AssistsWhen a user fills in his name in the 'name field' he has to select how many goals and assist he registered in a ice hockey game. It is obvious that there are multiple games in a season. The situation is it is now: Every time a player fills in the form a new record is added in the database... Situation as it should be: Every time a player fills in the form the 'goals' and 'assists'
Two instances of datepicker in the same web form
Hello, I am new to the Zoho forum. Just downloaded the code and started testing things around. I had an existing PHP form where I select start and end dates. I modified my code to now use the jquery datepicker function. It seems that I can only use one instance of the datepicker in one form. The datepicker pop-up only works for the first date but does not for the second. Is this how it is suppose to work? Can I not have multiple date pickers in one form? I searched the Zoho Forum for similar topics
Form is set to public but customers cannoti view form
I have a reservation form that is set for an iframe on this site r r s a d d l e c l u b . c o m http:// rrs addle club.w ebs.com/ maker eser vat ions.htm it is set to be viewable by public but customers are unable to view it. Trouble shooting please? Great system, and if this bug is worked out we may consider upgrading. thank you
Customers unable to access our form ----Critical Failure---
https://creator.zoho.com/rrsaddleclub/reserveticket/form-perma/Reserve_Ride/7rFOYP0CO9M 3uv3yVTRvD3w56TZHPbeZXKShQhwuRtuBrfD68gsQN6BG9nn3xKaOEZkq9tFGN88PwxOpgQGrg3TsZ0QghbpvvQZ4/ is supposed to be able to be accessed by customers without login they cannot view I frame or are unable to view the form after clicking on a link. please help form installed at http:// rrsaddleclub. webs.com/ make reservations.htm I can view it just fine and so can a few handful of users that have logged into the
How to copy code from one field to another in Creator?
Hi, I have attached code to a field using the very useful drag & drop. I would now like to copy the code to several other fields, rather than having to recreate the code every time by drag & drop. Maybe I'm being rather dense, but I can't see how to do this - can anyone please tell me if there is a way to do this?
Need Tech Support: Unable to clear "No Duplicate Entries" setting
I originally set a field in a form to "No Duplicate Entries", but now I don't want that condition. When I uncheck the "No Duplicate Entries" checkbox and click Done, it does not take effect. Re-opening the dialog shows it still checked. Then, to try it another way, when I go into Script mode and attempt to remove the "Unique" flag from that field's definition, I get this error message when I try to save the modified script: Error modifying the page Columns participating in the Primary Key Definition
Inventory Management template available?
I am trying to set up a fairly basic inventory management system for a small organization in multiple locations. Are there any existing applications or generic templates that I can use as a starting point? If not, I need to understand how to do receiving and shipping functions that automatically update the warehouse levels.
Emailing Data is Nonfunctional
user: niskypto app: email-test share: public and support I was going to test the new Email Alias ID feature mentioned here https://help.zoho.com/portal/en/community/topic/how-may-set-the-form-email-address-for-adding-form-data-by-email ... but found that any emails sent to the form are not appearing in the view. I have removed the alias and tried again, still no emails are arriving. Any ideas? John M. Whitney Recommend
Field selection lost on saving the record
In On Add/On Load I add the option "[none]" to a lookup picklist with the following code: clear Introducing_Player; Introducing_Player:ui.add("[none]"); colIP = frmPlayers_List [(Name != "Dummy" && !Name.contains(":"))] sort by Name ; Introducing_Player:ui.add(colIP.Name.getall()); Introducing_Player.select("[none]"); This works fine. But when I save the record, the field Introducing_Player reverts back to "-Select-". Saving other selections in the same field works. There is no code that could
BUG - Cannot Pass Boolean Parameters Via URL
The ability to pass boolean parameters via the #hash format URL has suddenly stopped working properly E.g. openUrl("#Form:Task_Update?ID=1234&Return=true&ShowDetail=true&Comment=test ..." The ID & Comment pass correctly, BUT the 'Return' boolean parameter either does not work at all, or, if the 'Return' boolean works, the 'ShowDetail' boolean does not! Furthermore, it depends if the URL is being opened in the 'same window' or a 'popup window' as to which boolean variable will pass and which wont!!
How can i create a VIEW according to my Requirement?
hello zoho I am create an application in which i am use some formula fields based on calculation, now i want to that when USER submit data then USER redirect to the View of that form and the form contain only Formula fields, means USER sees only the formula fields not the input that it is filled. and another Requirement is that USERS sees only its own record in the View means it can't see the previous results which is enter by the another USER. And my last requirement is that the View Formula fields
WON'T LET ME CREATE ANY RECORDS - Error "1 . [t_704788000000012742] Exception occured while..."
Hi, I must admit I'm a little frustrated. I just spent two days setting up this database for my company and then I go to add my first legit record and.......FAIL. When I fill everything in and submit, I get: 1 . [t_704788000000012742] Exception occured while setting value in PreparedStatement for the Column [Notes_704788000000021173] Check whether the datatype for this column is given as specified in the data-dictionary .[t_704788000000012742] Exception occured while setting value in PreparedStatement
Error - Exception occured while setting value in PreparedStatement
When submit form "Novo Imóvel" (form Potencial) message occurs: "Invalid entries found. Please correct and submit again." appears at the bottom of the form: 1 . [t_679162000000105097] Exception occured while setting value in PreparedStatement for the Column [Potencial__679162000000604155] Check whether the datatype for this column is given as specified in the data-dictionary .[t_679162000000105097] Exception occured while setting value in PreparedStatement for the Column [Potencial__679162000000604155]
Help with Script
I need help in script. I want a client to be able to select one of these States and be able to complete the form. If they choose any other State, then they get the url stating we are not able to help them. The following script works with one State however, I need to allow the form to be completed if they choose any of the follwoing States AL,FL,GA,IN,LA,MD,NC,OH,OK,PA,SC,TN,TX,VA. Otherwise, they get the URL Any help is appreciated if ( (input.State != "AL") ) { hide State; disable
Library log
I'm attempting to develop a database for a tool library for our little non-profit following the closure of Dabble. I've tried the library manager application but wish for a somewhat different structure. We have a PEOPLE form (borrowers) and a TOOLS form, each of which track vital information. I would like a LIBRARY_LOG form, where each entry is a borrowing event and easy to fill out by our librarians when they are busy. The log should be related to PEOPLE1 by a one-to-one, but to TOOLS by a one-to-many
Issue while Inserting Currency Field
I am trying to insert one currency field in my existing form (Financial Transaction) in Penta CRM 10 Application but it doesn't appear after which I tried to add Number field which successfully added after which I tried to convert it in currency again it disappear from my form. I have already given read write access to the support team. Thanks.
Script Help
I need help in script. I want a client to be able to select one of these States and be able to complete the form. If they choose any other State, then they get the url stating we are not able to help them. The following script works with one State however, I need to allow the form to be completed if they choose any of the follwoing States AL,FL,GA,IN,LA,MD,NC,OH,OK,PA,SC,TN,TX,VA. Otherwise, they get the URL Any help is appreciated if ( (input.State != "AL") ) { hide State; disable
Delete "Date" field
I tried to make a date field automatically put the days date in but it is not working so I want to delete it. When I try to do so, an error message comes up stating that the "field is referred in . . . Schedules." and to remove them. I can find no way to remove from schedules to then be able to remove the present "date" field and start all over. - jb
Obtaining an existing dropdown list value in a field before it is changed
Hi Maybe simple question, i have a drop down field with Sales1 / Sales2 / Sales3 as the choices if the field is changed i want the existing value to be written to a form "Original Sales Person" and the new selection to be written as "New Sales Person" Basically i am trying to record any changes regarding who is handling the sale The problem is that within a field onupdate script only the new value is available I tried to get the original value when the form loads or at another stage but then i have
Ready to put form on web site
Can you point me in the right direction to do this? Tks - jb
Remember radio button selection
Hi, Is it possible to make radio buttons that remember your last selection? For example I make a new entry filling some fields and choosing a radio button selection. So when the entry is added the page refreshes and remembers my last radio button selection. Thanks
Login issue when embedding in other sites
I am facing an issue. I had created the form in the Zoho creator and it is in private Access. Once i embed the form in my webpage, It will ask for Login for the form. It was shown in the attached screenshot. [File name: beforeSignIn.png] After i logged in, The form is embedding in the same iframe. Refer to afterSignedIn.png. But i want to redirect my webpage to another page, which contains the form of my application created using zoho, once it is Logged in. Is there is any other options to use
Zoho Login
I need a Zoho login alone in one page of my website. Once it is logged in it need to redirect to the another page of my website which contains the form's created using zoho creator. So please tell me how to do it,
Report Top 10 sorting
I created a report using the Top 10 filter. The top 10 refers to the number of (in this case) Donations (represented by field <Amount-count>). Is there a way to automatically sort the report on this Amount-count column (descending)? It looks like I can sort on all fields except the data-fields. please advise Henk
Allow clients to create a Sales Order From Inventory
As a wholesaler/distributor this functionality is vital. I ran across Order-Slip which presents a generic form and allows the client to enter in a textarea field their order in free text which allows room for error... I wonder if there is anything in Zoho Market place or possibly on the works to allow a client to: 1- Login 2- Create a sales order from inventory 3- View previous sales orders 4- When loging back on ability to start a new order from the previous one This would be just AWESOME. Something
Add Record to View - Pop Up Form Position
When displaying a View that has a link to "add" records, is it possible to specify the position on the screen that the data entry form opens? I would like it to open immediately below the view header not randomly lower on the page requireing the user to scroll down the page for each entry/edit, etc.?
Open "Other" option in addition to pre-defined options
In my form I have a choices for my user in the form of radio buttons. I would like to add a "other" -choice, where users could input another value than the ones represented by the radio buttons. And then of course have all of these in the same report. Is this possible and what would be the best way?
Data removal
Ive added data in a report in a creator application that I now want to revove and cant..Any ideas
How can I view Multiple List Values (selected via Checkbox) as individual records?
When I select multiple list items on a check box list (EMPLOYEE NAME) I want to be able to view each item on a separate line/in a separate view record. Because each 'EMPLOYEE' selected from the list went to the same 'TRAINING SESSION' each one has in common all the other details entered in the fields of that form. So, where I can now view this: EMPLOYEE DATE ST TIME ED TIME SESSION LOCATION NOTES Name 1, 1/1/11 11:00 12:00 Safety conf rm misc
Check of fields between forms
Hello, I am starting with Zoho and I'm having great time. I have created two forms. One is for contacts with several fields including Name and Company. Second is for event with several fields including Name and Company. The user must fill first the Contact form (no problem with this). Then each time he fills the Event form with a new event, I want to check that the couple (Name, Company) is existing in the Contact form. How do I do that? Thanks Jean
Lexical error , help
I have two forms that we use for booking rides Form 1 Add_New_Ticket one has the list of tickets that can be reserved, with two fields, one is a formula (Choose_Date_and Time) that has the date, time, details, the other has the date (Confirm Date) that zoho recognizes and can be put to use on a calendar. Form 2 is the Reserve_Ride form that customers go to to reserve a ride. Now when they choose a ride from the lookup field that references Add_New_Ticket. Confirm_Date_and_Time (formula), the information/same
Next Page