Fetch Record using Auto Number Field
Hi there I am new to Zoho and have successfully used the 'fetch record' to get fields from one form into another using Set Variable BUT, I am trying to populate a form using the AUTO Number field in the Fetch Record script., but it won't work,. I have made it work by using the ZohoID, but this is a big number, and would rather use the auto number which starts at 2014 here is the script that doesn't work (where incident ID is the auto number field ) IncID = Report_Incident_or_Serious_Harm[Incident_ID
API Criteria &&
I am trying to view & update through the API. It states that I may use criteria. I can get it working fine provided there is only a single criteria required, however I am trying to do this with 2 & 3 crtieria that must be met prior to the activity being undertaken. Specifically the API documentation states for multiple criteria - Example : (Name == "Jean" && DOB == "20-Jul-1981") So I have built this into the JSON array I send. It appears to be reading it and trying to act upon it but is returning
creating a summary field from another form in a report
not sure how to explain this, but here goes: I have a form called Items. Items contains two fields: item_name and item_price. I have another form called Master List. Master List contains a number of fields, one of them is a lookup to a third form called Room. Master List also contains a lookup field to the Item form, retrieving the item_name. I wish to create a report on Master List, grouped by Room, that shows the individual rows and gives me a total of item_price. However,when creating the report,
Conditional form feeding web-to-lead
I have a web form that walks users through a series of questions and essentially records the answers in their web session. Once they have finished, if they pass all the criteria, they are presented with a form that allows them to input name, email, phone and submit. The submitted form comes with the answers to the questions in the form of an email. Is there a way of doing this with zoho creator, or other means of doing a more conditional web-to-lead form?
Added_User not returning a name but a "numeric string"
I have several portal users who are inserting records into a table. I need, for an email, to list the users along with the records they have entered. I am trying to find the users with the following statement (or nearly). UserList = Table[TableReference ==SearchReference].distinct(Added_User); I have also tried UserList =( Table[TableReference == SearchReference].Added_User).getall(); with the same result. What I get in UserList is a 'numeric string' - looks a lot like a row reference ID to a table
Can not delete field / form.
The function getUsersTeam did once exists, but was deleted long ago. I continue to receive this error.
Publish URL?
All, I have a free Zoho account and have created a one-form application and would like to make it available publicly. According to this help page, https://www.zoho.com/creator/help/forms/publish.html, the Publish URL button should be available for me app. However, it is not - neither it nor the Embed URL buttons are available. Would you please help me figure out how to publish this app? Thx.
href help
Hi, I am trying to hyperlink a text "Website" with the URL . But something is wrong with my script so I am getting below result. Script : input.UPM_links = "<a href=" + TV_Station [ID == input.TV_Station].TV_Website + ">" + "website" + "</a>" ; could any please help me Thanks Arfater
Mandatory Field
Hi, I generated ID field is in Single Line so set as a Mandatory field.Its working no pblm but i want change that error line For Ex: Duplicate value found for "ID" how can i change this text .Its possible or not Please reply me immediately. Thank You.
Question share from list / consulta compartir desde lista
Español: Buenas me gustaría saber si existe la Posibilidad de compartir por medio de una lista armada . Espero se comprenda la inquietud y disculpen la traducción. Ingles: Good I wonder if there is a possibility of sharing through an armed list. I hope the concern is understood and excuse the translation recordUsers { email={user1@tes.com, user2@test.com........} (String) } recordItemShare { type = {"section, form, view, page"} (String) nameObject = {"form1, form2, section3, list1......"}
subform suddenly broken, need help please!
Hello! I’m having a problem with a subform in my application that suddenly started behaving strangely. There are four fields in the subform that are not working now. 1. 1. Event Name is a text field that pulls from the master form in which the subform is embedded. 2. Event Date is a date field that pulls from the master form in which the subform is embedded. 3. Event Type is a dropdown that pulls from the master form in which the subform is embedded. 4. Site ID
Url Image Field Deluge Update
Good day, I have a product catalogue, each item have a Url Image, I want to update the Url Value with Deluge when every new product is created, I use the same syntax to feed a url on a plain field but in the Url Image field nothing happens. iniciolink = "<a href="; mediolink = (" target=_blank>"); finallink = "</a>"; thumblink1 = "http://www.zhingenieros.com/zoho/productthumbnails/"; thumblink2 = ".jpg"; thumblink = thumblink1 + "1" + thumblink2; input.Image = iniciolink + thumblink + mediolink +
How to create a report that shows items with zero dependencies?
I am trying to create a report that has two tables (forms as they're called in Zoho), one table is Stores, the other is Accounts. The Accounts form has a field has a foreign key from the Stores table. How do I create a report that shows me how many Stores do not have a foreign key associated with data in the Accounts table? The MS-SQL equivalent of the results I would like to see in the report would be: SELECT s.Store_Name FROM Stores s WHERE s.Store_Name NOT IN ( SELECT
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
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.
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.?
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.
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
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
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
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 />"
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