HTML page...can one view force a refresh of another view
Title speaks for itself. I have an HTML page with multiple views incorporated into it. If a record is changed in one view, can I force a refresh of another view?
Example of validating log in
Hello How can I use log in form to open specific page for user, I know there is using for in success and rest of script, but need example, Thanks ?
Email Notification Sent on specific date
Can i send email notification to user exactly the date he/she inputs in the date field when submitting the form? I need to make a reminder form to remind user to do something in organization. please advise.
Problem with getting SalesOrder ID BUG??
Hello I am trying to access Product Details in the Sales Order form and trying to do it through Sales Order ID. I put a Zoho CRM field on my form called SalesOrder Name and I was expecting to have a SalesOrder_Name_ID provided to me in the Deluge "Refer Fields" list but all I get is a field called Zoho_CRM_ID. So I tried it: crmresp = zoho.crm.getRecordById("SalesOrders", input.Zoho_CRM_ID); input.SO_ID = input.Zoho_CRM_ID; Nothing shows up in SO_ID field on my form. Can you help my understanding
Employees to access Lead From
Hi All, Currently we are developing Application in Zoho Creator with Free version. We have one form, through which we want all our employees, to enter Leads information. When i created a Lead form and share the form with all employee id (10 emps, with their email id), the Zoho Creator considers it as User. The employee should login with given username and password and then enter the lead information. Is there any way, we can retrict users in Zoho Creator, but give access to this functionality to
how to add my form in wordpress page
I am using wordpress.so i have this form, how do i put or add my form in my wordpress page?please
Grand Summary Formula Column
Hello. I want to put a formula in a summary row, and have no formula elsewhere. Specifically I want something that does this. See how the Three-Day Average Column has 350 in the "My Movie" Summary line, and is determined by dividing 3-Day Gross / Screens. I've tried everything I can figure out to try. I won't bore you with what I have tried. What works? Title Venue Three-Day Average Screens 3-Day Gross My Movie Astor Theatre 1 567 Average Theatre 1 133 My Movie 350 2 700 Grand Summary: 2 700
Currency Decimal on Edit
Hi, i put a currency field with 2 decimals, like 0.00 When i am in the report, and edit the value of the field, like 8.45 it will not update, but if i edit and fill with 8.00, it will update. There is a problem with updating fields with currency type?
Live updates to a form
Hello, I am creating a form for our team members to access. I was just curious if one of our team members updates something in the form will it update live to the other members in the form at the same time? I tried testing it but relaized it will only show the update if you refresh the browser page. Thanks, Darren
Can't edit Message field when setting up a "send mail" function
Setting up a "send mail" function on a form, I click Edit to edit the From, To, Subject, and Message. I can edit the first 3 fields fine, but cannot edit the Message field. Clicking on the text box does not show the "xxx Mode" tabs and does not allow changing of the text. This happens to be for the Form Action "On Edit" | "On Success". I did just now try the Free Flowing Script option, and that does allow me to change the script, so that is a work-around. So this problem is just in the Script Builder.
Lookup Setfilter based on another field on the form
Hello, I came across your tool just today. Seems interesting but i would expect a lot of improvments before i spend money to buy it. Please help me with this situation. I have 2 field for names on the form. I get to choose a name from the lookup of Names for the first field. For the second one i will want the same look up minus the name on the field field. 1) My thoughts. I should be able to filter it out 2) I should be able to create a list after the first name is entered ( Everything
What are some options for other Custom Reports
I want to be able to use data from my Zoho Creator database to generate custom reports that are formatted in a particular way that is not supported in the reports feature of Zoho Creator. Does anyone know of some other options for creating custom reports with the data from Zoho Creator? For example, is there a way to link to data in Zoho Creator from Microsoft Access so that you can use Microsoft Access's reporting features? Or is there an on-line report generating tool that can pull data from
insert/add a record
How can I add a new record to a 2nd form when using deluge scripting When I add a record to table 1 (detailed data not suitable for display) , I want to add a record to Table 2 (presentation information). ramona
warehouse development
Hi guys, nice to meet you. I'm finishing the development of a company application to manage our warehouse. To create a selected list for product, i've arranged following script: lisart = List:Int(); for each y in magazzinos [(((stock_colli > 0 && deposito == doc.deposito2) && data_scadenza_lotto >= zoho.currentdate) && (protocollo_magazzino is not null))] sort by articolo { if (!lisart.contains(y.articolo)) { lisart.add(y.articolo); } } The problem is that "magazzinos" table
I want to map all CRM Leads into an Array in Deluge
I want to map all CRM Leads into an Array in Deluge so that I can access each record (lead) in a FOR loop. Any suggestions? Looks like so far I can only get records by ID.
Access to report - User specific.
Hi All, We are developing our CRM using Zoho Creator. We are basically Pharma company. We have created a form called "Leads". This forms as all required fields along with MR Number. All Medical Representatives (MRs) should log into system and enter Leads information. The Drop down menu in Leads form will show MR number, so that they can choose his/her ID while submitting Leads information. Later Business user can see, who has submitted how many Leads on a given day/week etc.,.. The Issue is with
Currency Symbol in Reports
Hi Sorry if this is a silly question - I am a newbie user. I have created currency fields in my database to be shown as GBP. The £ symbol shows fine in Forms but default sback to $ (USD) in reports, Is this a bug or sonething I am doing wrong? Many thanks Mike
creating application
i'm making an inventory system.. is it correct to make separate one application for the entries/forms database, and another application for the reports?
Simple Currency Related Formula Not Working
I seem to be missing something with currency related formulas - I'm trying to do the following: "input.Assessed_Land + input.Assessed_Structure" Both fields are currency - it gives me the following error: "com.adventnet.ds.query.QueryConstructionException: Datatype [CHAR] of the column [t_693811000000018081.Formula_693811000000025013] can " The error is cut off in the window - I cannot see the rest. What am I missing? Thx
Merge 2 fields
I have two basic forms .... one one (Contacts) I have the basic Contact Info and on the second (Opp's) I have the opportunities that have been identified for each contact. On the Contact Form are two fields ... First Name and Surname ... on the Opp's form I have a look-up to pull in the business name from the Contact form. Is it possible, and if yes, how do can I based on selecting a business from the Contact form pull in and merge the First Name and Surname from the Contact to the Opp's form.
Creator App Duplication Failed
Hi Zoho Teams, We are a IT consultancy team and zoho creator paid users. We aim to promote zoho to our local SME as it's a wonderful tool. This is our app: https://creator.zoho.com/luyiheng/ucdemo It's a demo for our client. However, when we want to deploy this to our client, we could NOT DUPLICATE this app. After click "duplicate", nothing happens. Also, we could NOT EXPORT this app. Please Help! Thank you very much! Best, Yiheng
Is it posible get data from IMDB to creat a Zoho creator database?
Hi everybody: I am a new member of Zoho comunity. I would like to create a database for my movies and wondering if there is any way to automatically extract data from imdb to complete my own database. Another way of asking the question is: Can I create a script that extracts data from IMDB to complete my own database?. Thank you very much.
Access Request/Zoho Privacy Policy
When accessed using the URL http://creator.zoho.com/[USERNAME]/[APPNAME], the user is not presented with an warning. But then, we've converted the primary account to a domain account, added a sub-domain to point to ZC. So when I use the URL http://[MYSUBDOMAIN].[MYDOMAIN].COM/[USERNAME]/[APPNAME], the user is presented with a warning that reads like below: --- By clicking 'Grant Access', you give Zoho permission to enable [MYSUBDOMAIN].[MYDOMAIN].COM to access all your user data available with Zoho
Can I make a app in Zoho Creator for my database in Zoho Reports???
I want a quick way to make apps for my database that I have created in Zoho Reports. Would like to use Zoho Creator, but cant see anyway of doing it?
Tips on how to embed a mp3 player for a uploaded file
Hi, I'd want to embed a mp3 player in a HTML view based on a Upload file. I've tried couple things (simple and complicated) without success. Anyone has a tip on that ? Thanks, Pascal
Enabling public access disabled for Trial and Free Edition users
Dear Users, Due to security reasons, we have disabled enabling public access of form and application for the Trial and Free Edition users. Regards, Karuppuchamy
permalink in iframe
hi guys, i have this problem. I have created a permalink of an html view with a zoho table inside. The table allow users only to view and print records, not to edit or delete. When i check the permalink in browser everithing works good. But when i check permalink in iframe, the table allow users to edit and delete records. Why? Someone knows how i can solve this? Please help me bye
Add records by status in ZohoCreator Reports
Some example function that adds record status by the creator of Zoho Reports? I want to add up all the forms that are as "Approved". Thank you.
Check for a null date in a formula field.
In my application, I would like to create a custom field that would perform the following actions If (initial_date and clear_date are BOTH NOT null/empty) - display "Complete" else if (initial_date is NOT null/empty but clear_date IS empty) - display "Pending" else - display "Incomplete" For some reason, even when I try to check if a date is NULL in a simple formula, nothing will show up e.g. if((initial_date ==null),"Test1","Test2") Any help would be appreciated!
Custom summary view to be shared among all users
Let's say the app owner has created a personalised summary view which applies everytime he access the app and clicks on view the record (or record summary). This custom summary view does not apply to other users (whether they are developpers or regular users). Is it a way to share custom summary views with other users? Do you think in any other way around to do this? Thanks in advance.
catch post rest api response
Hello, I am using rest api to add new records to my form from my external php/javascript application: https://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html The records are successfuly added, but the response is automatically downloaded to the client machine, the customer doesn't understand xml/json/csv formats, so this causes a problem. Second, I want to use that response (the ID) to add other records that have lookup to that first added record. Can anyone help me?? Thank you
Duplicating applications
Does anyone have problems with duplicating applications. I submitted a service request but can't get any answer. I asked for an urgent status update, still no answer. Generally, I get answers and resolutions on my requests fairly quickly; however, this one is worrying me because I am not able to get any communications back from Zoho technical support. A lot is riding on this for me!! Can anyone shed some lights on this issue? Any fundamental problem with duplicating an app? Thanks
Scrolling in Sections
When rearranging sections and components in a very long list, it would be much easier if Creator scrolled up or down when an item is dragged beyond the boundaries of the Sections window.
Looking-up a record from another site or location
Hello, I need help on how to connect and retrieve a record from another file that is located externally, on some website or network drive, without having to load the entire file into a table in my application? Is it using API? examples would be very helpful. I read the guide with GetUrl, etc. and that was somewhat confusing. I would really appreciate some help on this. Thanks
Adding Custom Button to View
I need to add a button to a view. I know that I can do this by writing a function and then calling that function via custom action. My problem is that I want it to work like a static button. I doesn't have anything to do with the below records and the custom action forces me to attach the button to a record or set of records to iterate over. I want to add a simple button to a view that calls a function (function that does not reference a record) but I do not want to have to build and entire html
A question about fetching sorted records
http://kbase.creator.zoho.com/records/fetch-records-within-a-range in the above document, this: rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; so, my question is, if I do a for each r in rec { list.add (r.Name); }Will it add Names from the records to the list in sorted order of Added_Time?
Mobile linking in HTML view
Hi, I'm adding some dashboards to my application, from where the users are being linked to specific views and forms. This is quite simple, linking to #View:<view name>. The problem is with mobile viewers. Since Zoho Creator doesnt support Javascript (why is that anyway?!) I can't change it depending on user agent or whatsoever. How do I solve this? Thanks in advance for your help.
How can I use a sequential number for each form?
Hi, I'm creating a form like invoice and need to add a sequential number jump automatically with each entry. How can I do it? Thanks!
HTML in Variable
I am trying to create a variable for use in an email that contains HTML (for a dynamic link). The issues I am having is with the quote signs in the HTML. I cannot seem to get the variable to save with the quotes: agreementlink = ("Please sign your rental agreement by clicking the following link:<a href=\ "http://creator.zoho.com/carlgifford/vacation-rental/Rental_Agreement/record-edit/Rental_Agreement_View/" + input.RentalAgreementID + "\ ">Rental Agreement</a>"); Is there a way to do this? Thanks
Moving from GoDaddy Easydata Base to Zoho
I am NOT a programmer. I have emailed you several times, spent hours researching your site following the links I get in response to my emails (which usually do not come within 24 hours), reading forums, all sorts of instructions and suggestions, user guides,get started guides, and FAQ sections - all to no avail. I have been told I can hire someone to customize this for me, but I think I shouldn't have to pay to understand how to create something that should be very basic. The only GoDaddy customer
Next Page