Error- Stateless form submit auto populate
Error details: Error in executing On Click script of the Submit button. Error. Error in executing Add Record task. insert into Bay_Booking [ BB_First_Name = input.BK1_First_Name BB_Last_Name = input.BK1_Last_Name BB_Customer_ID = input.BK1_Customer_Information BB_Models = input.BK1_Models BB_Make = input.BK1_Models BB_Date_Time = input.BK1_Time_In null = zoho.loginuser ] openUrl("#Form:Bay_Booking", "same window"); Have a stateless form that i am wanting to enter details
Import data via email
I have a public form where I have shared the form to various email addresses, still these addresses when submitting data via email received the error message: Denied to add Data. It was my understanding, then when a public form is shared to a given email address, it would be possible to send data to same form?
Button width cannot be set?
Hi Zoho, In my html I have a button. I am trying to set its width to be 150px. the following script is not working (all other attributives are working great - just the width is not working)... will appriciate assistence: <style> .ProjectButton { background-color: #748772; width:150px; font-size: 18px; padding: 15px 15px; vertical-align: middle; white-space: nowrap; border-radius: 10px; cursor: pointer;} </style> <a class='ProjectButton' href=<%=CurrentLink%> target="_blank" ><font color=#f0f0f0><%=CurrentName%></font></a>
Calculate First Sunday of the Month
Our TimeSheets run Sunday through Saturday. Certain compensation changes have an effective date of the first Sunday in the month following the approved changes. I'm struggling with calculating the first Sunday of the month following the change. What I'm working with right now which is not working: monthstart = toStartOfMonth(input.Date_Change_Requested); firstmonth = monthstart.addMonth(1); firstsunday = firstmonth.getDayOfWeek(0); input.Effective_Date_of_Change = firstsunday; Thank you! Jesse
Login Problem
When I try to login to Zoho Creator, it seems like it is stuck in a loop. If I go to other Zoho applications, I am logged in, but when I go to Creator, it keeps refreshing my screen without going into Creator. We have business data that is needed for daily operations. Please help!
creator aerospace background developers wanted
need skilled aviation background developer to create a marketplace for business jet transportation hub. like Uber of the skies. contact me if you are at the genius level with this package
Bi-directional explanation
I am a novice, so this is probably a basic question - what does a bi-directional relationship do? I have read the materials & asked zoho (who directed me back to the materials) but i still do not understand what it does.
Duplication records on demand
Hi Zoho, I have a form ("Mainform"), that takes data for different projects (project name is in "Project_Name" field). I have a second form ("Importform"), that allows me to "import data" from one project to another - meaning, on the ImportForm I have "Import_From" field and "Import_To" field - both state project names for the data to be fetched from / added to. On the ImportForm on add -> on success, I have a veryyy long list of updateing a record in Mainform, that fetch for every field its data
lookup field displaying ID instead of value
Hello all, I have searched the forums but I can't seem to apply it to my problem below. The input.First_Name is retrieved from a lookup field. I know it is in numerical ID form, but how can I edit it to retrieve the actual value? sendmail [ from:zoho.adminuserid to:"jli@asiajet.com" subject:"Crew Visa expiry alert (30 Days Notice)" message:input.First_Name + "'s " + input.Visa_Country + " visa will expire on " + input.Visa_Expiry_Date + "." content type:HTML ] Thanks!
Fill dropdown with google sheet
Hallo, is it possible to fill a dropdown field with data from a google sheet ? Thank you
cannot import 2 apps
I recieve an error when i try to import the apps that i created
Form image not show in views
Hi, On our Zoho Creator system we get candidates to upload a photo to their registration form. Originally I set it up so that on views, we could see the images. It worked with this formula: (("<img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/" + My_Pic + "&sharedBy=" + zoho.adminuser) + "&fieldLinkName=My_Pic") + "'/>" For some reason along the way it stopped working. Please help me get the images showing on my views again. One example is the 'CURRENT CANDIDATES' view. We
How to REMOVE a RELATIONSHIP (values in a LOOKUP field) using a STATELESS FORM
I have a stateless form to add records to "Tasks" form and a separate stateless form to edit records in "Tasks" form I do not want to allow users to have edit access to the actual "Tasks" table, so all edits must be done via the stateless form. "Tasks" form has lookup field Contact_ID which links to "Contact" Form. IF a contact has been added into a record in "Tasks", i.e Tasks.Contact_ID has a link to Contacts.Contact_ID, how can I remove this relationship on edit, using a stateless form? None of
Update the value of a subform a modification in the form.
Hi I have a form with a subform inside. I want when data is changed in a subform, automatically change some values. input.Status is a value in a original Form Registro_Mercancia Is a Subform Status_pruebas is the value I need to be modified within the subform. if (input.Status != null) { if (input.Registro_Mercancia.Status_pruebas != null) { Status_pruebas = input.Status; } } Thanks!
add criteria for view filter dropdown
View(report) - filter -> auto filter I need to limit the dropdown values of an automatic filter based on a field. The drop down does not list out all of the values if there are too many. Any idea? thanks
Can't find the organization contacts
I think my account is totally out of wack. I tried to add users to to Groups and manage sharing using Groups. The screenshot shows I have 14 contacts in my organization but none is shown. This is not the only thing wrong with my account. I submitted multiple posts this afternoon about various inconsistency across the board. Also, how do I change the organization ID? right now, it's using "lexshan1" as organization ID, which looks like a personal ID. Very confusing again.
I can´t share an app
I have created an app, I have bought another user and I can´t share it with them, where is the problem?
Can a Zoho developer create a customer portal for me?
I am looking to create a customer portal that has the following: Client's past invoices from Zoho Books, see remaining balance on invoice, pay with credit card (already configured in Zoho books) Client can upload their multi-media assets (this could be tied into my dropbox or another storage program) Submit support ticket (could be linked to Facebook chat) See available product upgrades and request account manager to contact them See available promotions See news and updates Written instructions
OpenURL not working "On Add - On Validate"?
Hi Zoho, I have the following script on the "On Add -> On Validate" of a form: Current_Ins_Amount = (Insurance_Insured_Amounts[(Project_Name = input.Project_Name && Ship_Name == input.Ship_Name)].Insurance_Type).getall(); if (!Current_Ins_Amount.contains(input.Insurance_Type)) { alert "There is no amount entered for this insurance type. Please update the amount in the following dialog box"; openUrl("#Form:Insurance_Insured_Amounts?Project_Name=" + input.Project_Name + "&Ship_Name=" + input.Ship_Name
Edit Record from Search Interface HTML Page
I am essentially building a html search interface similar to the one here: https://www.zoho.com/creator/help/tutorials/advanced-app-building.html However, I would like to be able to select the records displayed in the results table to edit. So in the example, I would like to be able to click on the email address for Tina and be able to edit this record. I have almost managed to do this by using <a href="<thiscode>"> where thiscode = http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname>
Accessing Multiselect Field from another Form?
I have a user information record (setup by Form A) that has a multiselect field (Fielda) that is set by doing a lookup to another form (Form B) Now i need to access my user information from Form C to verify correct access. So, i can easily access the Form A information that is "native" to Form A - but how do i access the multi-select field in Form A that was set by the lookup field from Form B. (they were string fields originally setup in Form B) hope that makes sense thanks
Having Reports embedded in email to send out to clients
I want to be able to send certain records out to our clients in an email (embedded in the email) It must look nice. How can I do this?
Google Earth, GPS coordinates in Creator App
Hi all I have created a report that our managers must fill in when they respond to incidents (crime and investigations) I want to have a Google Earth map embedded, i.e if there is coordinates that they supply, for it to be pinned onto a map. Then at the end of the month I want to be able to see all the incidents that occurred in that area and if you click on each pin, it should bring up the record for that incident (the report) Is this a possibility with creator? How can I do this, or is there someone
Access Creator Table
I am trying to define a workflow in CRM that needs to lookup a table (to get the approving manager). I would like to use a simple lookup table in Creator which I would access from a deluge script in CRM. But I have having trouble accessing the Creator table from the API - it returns "permission denied." I have a subscription to CRM but not to creator. Will the free account work for what I want to do?
List of records in Multiline field
Hi, Say that I have several records that complies with the same selection criteria. The content of these records I would like to show them in a Multiline field. Example: The table have the following entries Company1, Name1, surname1, age1 Company2, Name2, surname2, age2 Company1, Name3, surname3, age3 Company3, Name4, surname4, age4 Company2, Name5, surname5, age5 Company1, Name6, surname6, age6 In the Multiline field when selected Company2 I would like to be able to display; Name2, age2; Name5,
setting <style> for all html pages from one spot?
Hi, Is it possible to define a style in Zoho that will effect every html page I write? In a function maybe? or anywhere else? Thanks! Ravid
Push and pull data between Zoho and FileMaker
Hi There, I need to find out how I would go about setting up a push/pull environment between a Zoho Form and a FileMaker Pro database. I have had a look at the integration tool, but I see that it is only for Windows, so I can't test it as I am currently on a Mac and I don't have access to a Windows machine. I would like to use Zoho Forms for my users to enter in data, and then be able to query my FileMaker database to either create/update/delete records. Is this possible?
Cross table pivot chart
Hi, I have a table of Orders and each Order has multiple Task and a Order_Total currency field. each Task is assigned to one Staff. How can i create a chart like the following X-axis: different Staff Y-axis: the Order_Total of all Orders of the Staff on x-axis. My difficulty is, when I create a chart base on Task, i can't reference the Order's Order_Total field. If i create a chart based on Order, i can't set the x-axis to Staff.
General and Specific Terms of Use
Hi I just wanted to check whether it's an acceptable use of Zoho Creator to create one or more apps, find clients for them and let the clients use the app(s) through Customer Portal, which means I or my company shall be the 'Administrator'. Clients would pay me an agreed monthly fee. I don't want to take the Zoho Marketplace route because that makes the entire pitch to the prospective clients so bumpy. A little background about myself- I'm a finance professional with more than 15 years experience
Weird identity issue
Zoho Creator's identity management has confused the hell out of me. My screenshot shows there are 4 different IDs associated with my account: lexshan1 lexshan8 lexshan@walkintour.com 51551681 I think lexshan1 and lexshan8 is related to data corruption. I might have two user accounts at one point. Such as one registered through Google Apps and another directly with ZC. Can someone explain to me how to consolidate these? I have another record access control issue which may relate to this. Application: https://creator.zoho.com/lexshan1/order-manager-v2/
Record Summary - formatting
In the Record summary, I need to format the sub-form Item like the invoice template in zoho help https://www.zoho.com/creator/help/images/record-summary-invoice-details.jpg how to do: formatting the Item rows (add line under each record) set the data position vertically (top /middle/ bottom Omar
Need a BUTTON that will increase the value of a number by 1. How do I code this in deluge?
Any assistance would be greatly appreciated. Say I have a shopping cart line item with a count value of 0. I would like a button to the right that increases the count by increments of 1. Is this possible in deluge? Thank you
Use same script for multiple pages
Hi Zoho! I have several pages in my system that use nearly the exact same script (2 different variables) How can I make the script to auto-update in all of them when I update the template? Maybe create some function that has the complete script inside and just get the two changing variables? Will really appreciate any suggestion on this one Thanks! Ravid
Embed Form Problem
Hi. I have created a site with Sites, and I am now evaluating creator to use as a back end to embed more powerful forms. I am currently using the free version to evaluate, but the "embed form" option does not appear in the "more actions" drop down. Do I really have to register to try this feature ???
Error Log Location
Simple question here. With the changes to the Zoho dashboard or interface, I can no longer find the error log. There used to be a link under usage details at the Setup screen but that has all changed now. Thanks for the help.
OnClick OpenURL?
Hi Zoho, I'm having some trouble here - I'm trying to create a button with an "onclick" event, theat will open a url using OpenURL command. this script <a class='zc-formbutton' onclick=openUrl("#Page:Pyxis_Loan_Lea", "Popup window") >Click me first</a> created a button, but clicking on it did nothing. What an I missing here? Thanks Ravid
Help please
I think Zoho is great but I am not a coder I am trying to fetch an email record for a customer from one form into another. I have Two forms Form 1 “New_Contact” Field Names are “Company_Name” and “Email_Cust Form 2 “Order_Details” Field Names are “Customer” and “Email” When I do look up of customer in Order_Details in field “Customer” I want it to fetch “Email_Cust and put it in “Email” Can anyone help me with the code.
How to hide sub forms
How do you hide an entire sub form (not just subform fields) based on conditional statements? The subform comes as a greyed out option in Deluge Script Builder when using Show/Hide function?
Special Characters remove / replace
Hi Zoho, I need check for special characters in one of my string (text) fields in a form. How can I do this, except for a veryyyyy long "If" command listing all the possible characters? Any build-in function? I've tried if (input.Insurance_Type.contains("[/\-\(\)_@#\^!\$%\&\*:;`~ ]")) { alert "Special characters are not allowed in Insurance type field, please re-enter"; } Both on field -> on user input and on the form's "On validate" - but nothing happened Ravid
Rquested products total amount in report
Hi Zoho Community, I am working on a purchase request form. Through this form all company departments make requests of the products they need to the purchase department. Currently the report shows a row per product, in each row there is a quantity field. So for example, if 3 departments ask for 2 apples I will have in the report 3 rows of 2 apples each (it is ok,I need a report that looks like this too). I would like to have an other report that shows the total amount requested for each product,
Next Page