Getting login prompt on published page with embedded report
I have a page with a report embedded in it using the "Embded Form/Report" option in script builder. When I publish the page and access it using the permalink, I can see all the page contents but the report area prompts for login. Is there a way to avoid this login prompt? I do not want to use the widget option as it will create an iframe on the page, I prefer embedding it as a div using embed report option. Any pointers on this will be of tremendous help. Thanks
Error: You are not allowed to access this application
Shared users with Zoho accounts cannot access my application (forms/views). Only the admin account can access applications. Users show up under Account Settings - Manage Users. Accounts are active, and set as users. (Setting to Developer had no affect) Under Edit This Application - Share Tab - Users have All Forms and Views. Green checks on all forms/views when clicked. Under Edit This Application - Views Tab - xxxxx View - Actions/Set Permissions - users have Add/Edit rights. I have seen that
Calendar View Display
Hi, Is possible display 2 fields from one record in Calendar View? Is possible sum two column total?
Which Subscription or PlanLevel
Hello and thanks in advance for answering my post. I'm a little confused by the different subscription levels. I am currently a under the enterprise level. It includes 4 users at $15 per month. I am creating a prototype lead manager for my networking group. We have 40 people in the group who will be users. $15 per month will be too expensive for them. My group is part of a much larger group that could include hundreds or even thousands of users, but I need to get started with the lower numbers.
Object-linked Custom actions
Hello! I'm trying to implement in my application the following conception - using of standart Object-linked Custom-actions: You can check here (click on Client name): https://creator.zoho.com/smt_online/custom-actions-test/#View:Projects1 For example, I have Forms: Clients, Orders, Projects and so on Each Form (or Object) has accosiated standart custom Actions, which are used very often, and you need to do these actions from different places of your App: Clients: rename, block, check_status, send_notifiction
Join us for Zoholics Developers 2015!
Hello everyone, Save the dates for Zoholics Developers conference. Yes, we are happy to announce this year's developers conference to be held on February 25 - 26, 2015 at Pleasanton, CA. Zoholics Developers is an exclusive event for Zoho Creator users, developers and partners to come together and share their experiences of Zoho Creator. Come join us for the event and get a chance to meet the Zoho Creator team and the experts from our developer community. Also, we have plans to host a dedicated
Inserting invoice to Zoho CRM via Zoho Creator methods
Hi guys, I can't find any documentation on adding product details to an invoice via Zoho Creator. Here's what I've tried so far based on this forum post for the XML API. In that post, it seemed that you needed to nest <productDetails> within the invoice payload. That doesn't seem to work for Zoho Creator. Am trying to import invoice data from InfusionSoft and this is the stumbling block. void add_invoice_to_CRM(Invoice_Forecast_from_InfusionSoft forecast) { //create the CRM vs Creator fields
Insert into another form "On Success" action
HI, I have two form FormA and FormB . Where in the FormA there is a String field "TV station" and this "TV station" field is used as a lookup field of FormB. What I would like to do is when user adds a new TV Station in the FormA and will it automatically insert a Records in the FormB Since in the formA TV station is the string field and in the FormB "TV Station" is a lookup field so I am getting error, Could any one please help me ? FormA: FornB:
Sat. - Fri Custom Report Filter
Is it possible to create a report filter that will only display records from the current week, and to define the current week as Sat. - Fri.?
Organize app menu by dragging menu items in live mode
Hello, Is't possible to allow to Administration users to change menuitems order by dragging them in Live mode (in same Section or move to another Section) - now it's very slow to do (in my App - I have 24 Sections and 476 Menu items - so it's a big job to reorganize it - and also you need always to switch to live mode or refresh page to take a best position of item)
using a variable throughout a form
I am having trouble figuring out how to use a variable throughout a form. On Edit/On Load, I am trying to store a field to a variable that can be compared to the same field/input On User Input further down the form.
Question about Pivot Charts
Hello, I want to create a custom action to show data with Pivot Charts. How do I create pivot chart for selected record use custom action in header?
Admin only fields in subform do not get updated in script
I've identified a serious defect with admin only fields. I have created s simple order app to demonstrate this defect. An Order record has a subform of Order Items with a quantity, unit price and total. Please see app: https://creator.zoho.com/didgenero/bug-reports# (Support access is enabled) As admin user: 1. Click on Order Item Report and edit a record. Change quantity or price and note that the Total updates as expected. 2. Click on Order Report and edit a record. Change quantity or price and
Need to publish page with embedded report
I am trying to publish of page that can work without a zoho creator login. I published the page and got a permalink which works fine. But, I have a report embedded in this page using "embed report" feature in script builder. This report is throwing a login page when I try to access this published page without login. Any ideas on how to embed a report using permalink in a page as a div? I do not want to embed it as a widget resulting in an iframe.
Seriously STUMPED
I have an inventory form and I'm working on an auto order process. Any part that falls below the users preset levels is displayed when the user clicks on the button [Auto Order]. I populate the items to a checkbox list to allow the user to select which items they may want to order. I just discovered zoho does not place any value on a loop "do, for, while" which is the part that really has me "CONFUSED". Using a loop it would be an easy process to extract the quantity, part number and description
Button that convert all fields to Null
Hi, I have a form like below which has around 40 lookup fields so sometimes I need to have to all fields to null (means "-Select-" ) , at this time I need to go through all fields to set them as null . So I would like to have a button or something like that so it converts all fields to Null . Could anyone please help me how to do that Thanks Arfater.
Noobie Question
HI There, I am brand spanking new to Zoho, but from what I see, it seems to be the best solution to my business needs.We are a niche medical Human resources firm that places doctors in clinics for relief work. I wanted to know that if I host my business site with zoho, would I have he ability to create have my customers log into their account and view their account information and request new positions available/pending requests/transactions/account balance/ etc . . uing the various tools available
zoho.currenttime - why no milliseconds?
Some time ago I wrote a pseudo random number generator that relied on the following statement to return a long value representation of the current time : zoho.currenttime.toLong() This no longer returns millisecond values. Why is this and when did this change?
Creator calling a function in order to display records in a report / list
I have been trying to accomplish this for a long time as well, but no luck yet. Could someone assist me? I want to display a list that queries all assets that are associated with the current user's (zoho.loginuserid) company. In our scenario licenses should be available to our customers companywide instead of associated to a specific user. list My_Licenses { displayname = "My Licenses" show all rows from Add_Asset [(Company == helpdesk.getRequesterCompanyName())] ( Asset_Name
specialized list
I have a database with one report (list) - I/m not sure what to call it. It has 18 columns and many rows. I want to create from that list, a new list that I only would use to update info, and it would look the same, but only 4-5 columns. The other columns still there just not displayed. Columns I'm not interested in updating would not show. Thanks
Auto populate field from lookup
How auto populate one field when the user select the drop down lookup. I have this code for normal drop down: if (((input.Arbitros == "Juan") || (input.Arbitros == "Jose")) || (input.Arbitros == "Miguel")) { input.Porciento_de_Descuento = 0; } else if ((input.Arbitros == "Richard") || (input.Arbitros == "Michael")) { input.Porciento_de_Descuento = 5; But I need this same result with drop down lookup field.
how to run scheduler every 30 min?
hi need to run internal scheduler every 30 minutes. how to make it? complex workaround - make 48 same half-hour schedulers. need simple solution.
Re Subform :Check box to be chenged Multi select ?
Hi Anbu I I have a Check box field in a form,but when as a Subform into other form the Check box has changed a the Multi select ,could you please let me know what's happed, By the way after selected a or more value in the Multi select and then Cause the other script can not run,it's bug?or cause of the check box is replaced by multi select? New problem :if selected a value in Multi select and then can't submit like bellow screencap looks like the problem for that if Multi selec dynamic filtering
Display text based on dropdown choice
Hi there, I have a form called "Attempt" that has a drop down menu that is a task number that is a lookup from a "task view" I have. Based on the number selected I'd like to display another field from the "task view" for that record along side the number. I'd be happy for this to be uneditable text as it's only for display purposes, I don't even need it to write to the view for the form in question. Any ideas? Hope I'm explaining this ok. Another way to look at this... Imagine a set of questions
Relationship between databases
I have a database with details of all my clients (about 20 in total) I have another form which my clients use to book an appointment and I need to know who is making the booking. I want the client name entered on the booking form to equal the client name in the client list and I do not want the client to use a drop down box as I do not want clients to know who my other clients are ... Is there a way for creator to ensure fields match without disclosing the options
Configure Formula Field
Hi. I have the following formula: "((today - PlantDate) / (60 * 60 * 24 * 1000 * 365.25)).round(1)" The number is rounded to one decimal but still two decimals are shown, the second being a 0. I wish only one decimal to be shown. Where or how can I set this. I cannot find a method or area to set this. Many thanks.
How do I allow an override
I want to make an entry mandatory, but allow a manager to override it (with a password), is there a way to do it? if there is, can I leave a note only when I override
Send email with record summary attached when record inserted via deluge
Hiya I have a course management system and when I add a record to my Enrolments table I'd like to add the invoice details to my Invoices table, which will then send off an automated email with the record summary (made up to look like an invoice) attached. I've configured the Invoices form so that when a record is added manually it sends the email with invoice attached. I've also coded the Enrolments table so when a record is added it automatically adds it to the invoices table. Only problem is when
Hide Fields from a form
I have created a form with Zoho creator. Users are able to access a form and a report from that form. However, I want to include certain fields in the report that will only be editable by the admin, but the users can have a view of these fields. How can I create these fields without including them on the form?
Design Template
What are the best practices with Zoho for development workflow? Is there the concept of a design template where I can make changes to a test version of the app and then apply those design changes to the live app?
Zoho Creator API json format not working? xml OK
https://creator.zoho.com/api/json/student-record/view/Invoice_Extraction_Report?scope=creatorapi&authtoken=mytoken&zc_ownername=ricwilson returns a 500 error but https://creator.zoho.com/api/xml/student-record/view/Invoice_Extraction_Report?scope=creatorapi&authtoken=mytoken&zc_ownername=ricwilson works. This was all fine a few days ago. Please advise if this is a current issue. Rewriting interfacing to process xml instead of json is not an option.
when i provide a user with a permalink they cannot see images
When I provide my users with a permalink they are unable to see images.
Record Summary As PDF on Email for lookup record
Is it possible to include a Record Summary as a PDF in an email if the Record Summary is from a lookup field? Perhaps by fetching the record and then qualifying the record summary in the email. Lookup_Record = Student_Record [ID = Iinput.Lookup_Field]; sendmail ( To : input.Send_To From : zoho.adminuserid Reply to : zoho.loginuserid Subject : Subject Message : Email_Body + "<br />\n<br />"
Create a Report with Criteria calling a function
Is possible creat a View, in creator, with a criteria calling a function? Like: branch==thisapp.return_branch(zoho.loginuserid) See the attached image
Export Invoice as PDF on Mobile Phone
Is there a way to make a custom action that will export an invoice as a PDF (or JPEG) from my report onto a mobile phone? I would like the delivery driver to be able to print receipts using a smart phone and a mobile blue-tooth printer.
Livedesk chat window customization
Hi, I have a developer access for one application. But i am not able to customize livedesk chat window. i have attached the screenshot for your reference. Kindly assist me. Thanks Satya NHM
zoho send email
I have created a reservation report. I have customized to send mail notifications with cc and Bcc recipients. 1.But the problem is the mail is sent only if all the recipeients field are filled. The mail is not sent if there is only mail recipient. 2. Company Name Guest Name Room Name Check in Check out 3ds Mr. kkk SD45 - R1 null 17-Nov-2014 26-Nov-2014 In the column "RoomName", notice the 'NULL' . RomName has fot two options in the form and only one could be selected. This null
Zoho Creator Signature Field
Hello, it looks like You added a signature field to zoho creator. Will you update the mobile apps soon? They are crashing as soon as I enter the layout that contains new signature field.
Android subform display issue
I have a sub-form in my invoice form which only displays correctly when I access the invoice form. When I am in the invoice report, and access the subform, it displays incorrectly. This is the correct display, which displays the fields "Crops" and "Variety" first. When accessed through the invoice report, the display becomes like this, which makes the sub-form basically useless:
different logo for defferent app?
hi there is description how to change logo for all apps in account https://www.zoho.com/creator/help/account-settings/customize-logo-and-links.html#Steps_to_upload_your_logo but how can i set different logo for different app in my account? app1 - logo1 app2 - logo2 and so on..
Next Page