Embed sign-in form
Hello. Could you please help me with embedding sign-in form to my site. I use iframe with https://accounts.zoho.com/login?servicename=ZohoCreator&serviceurl=http%3A%2F%2Fwww.mysite.com&hide_signup=true But when i'm loggin i will redirect to https://www.mysite.com I'm not seeing https links. I have browser warning about different SSL in this link. And what's mean "dcc" and load_ifr tag's in Zoho url Thanks!
Sidebar that the information is not displaced,
I am sending an automatic email with the content of a subform for each entry. I would like the photography and content from becoming a single entry that would shift at the same time because if I add a variable to "PHOTO" and a variable to "Text" page breaks give me different positions. How to change my code to make the photo and text are in one sidebar regardless of anything? CODE output=""; Foto=""; for each entry in input.R { Foto=Foto + entry.Imagen.replaceAll("/sharedBy/appLinkName/","https://creator.zohopublic.com"
Translation
Hello, is there a way to translate integrated buttons in the Creator?
Edit record issue
Hi In my application record usage limit is 140000 and I used 120000.I have still 2000 records to add.But when I go to one of form in my application that has 19000 records and when I try to edit record it's hanging it doesn't showing the edit page window, it just spining like "Please wait...". Can you please let me know why this happens. Thanks.
Filter Drop Down Menu
In FormA, I have 2 drop down menus. The first drop down, DropDown1, is the Batch No. The second drop down, DropDown2, is the Student Name. In FormB, I put DropDown1 and DropDown 2 as lookups from FormA. What should I do in FormB, if I select Batch No. = 20, then the DropDown2 only display the respective students from Batch 20?
Formatting a formula field
I have a formula field on a form that displays the values without the commas and currency symbol. How can i change to my desired format? Expression: (Amount * Chance / 100).round(0) Explanation: The formula is taking a currency value (Amount) multiplied by a percent value (chance) to give a weighted amount value. Format now: 1000000 Desired format: $1,000,000 Thanks, Jon
How to calculate a formula field based on two dropdown fields
I have two drop down fields that both contain numbers based on military time, 1400, 1500, 1600. etc... I am trying to create a formula field that subtracts one of the inputs from the other one and returns the number of hours. I have tried to use the string input.fieldname but it doesn't work and just returns an error that it's a string expression and the operator is not valid. Any ideas!
What Formula Functions can be used with Pick List fields?
I am using a pick list field in a formula, what functions apply to pick list fields Specifically, I have a pick list Price that contains numbers (18,21,31, 36,40) which equate to a quantity value. I want to multiply the value of the picklist by another field (unit price) to get total amount. Thank you
Bulk Update More Than 200 Records
It seems that when I use the "select all" check box and then bulk edit, it is only grabbing the visible page of 200 records, not the entire list, about 13k for me. Is there a way to bulk edit all of these?
Data updating from Creator Web Forms/Website to CRM
I would like to know if there's a way to have a Creator Form *update data info (that was already submitted previously) to ZohoCRM and website. I'm trying to build a database "Profile" process that if a user updates info in their profile (within our website/ZohoCreator form) that this info would update in our ZohoCRM > "Profiles" tab. Is this possible... if so please advise.
Make a hyperlink with a URL field.
I want to make a hyperlinked text, but Link is a field already established. I have a field with URL but I can not make a text. When sending an email I need to apply this function.
Round decimal
hello, do you have a function to round a decimal with range of 0.5. By example if i have 16.56 i would 16.60, 22.12 -> 22.15, 14.34 -> 14.35 thanks you
How to clear a date field ?
How can I clear a date field ? Null does not work, nor does empty string "", nor can I clear picklist as it is a date field. e.g.: if((input.Status == "Closed")) { set ClosedDate = zoho.currenttime; } else { set ClosedDate = null; } Thanks, and I love the Zoho 2 features & look ! markv
Add Record in Quotes
Hi. . I can not create an entry in Quotes. The problem in the section of "Product Details " in Module Quotes . Either this section blank , or an error. For example : ______ mp = zoho.crm.getRecordById("Quotes",1402978000000223001); ______ mp.put("QuoteID",""); ______ resp = zoho.crm.create("Quotes",mp); ______ "Product Details " - empty. Or mp=map(); mProd1=map(); mp.put("Subject","Тест4"); mProd1={ "Product Details" : { "Product Id" : "1402978000000087066", "Product Name" : "Кухня jivo"} }; mp.put(mProd1);
Dynamic Picklist not submitting selected choice on add
I set up a dynamic picklist and the options available in field 2 depend on what I selected in field 1. The problem occurs once I hit submit. In the corresponding report, the option I selected in field 2 is not recorded. The record displays all other entries except the selection from the dynamic picklist (field 2). This problem occurs even if I try to add a new record from the report. The only way I've been able to get the option to stick is if I edit the record once I add it. Any ideas on what the
printing mailing labels work around?
I was reading that you can't print labels form Creator. Is there a way to do this by connecting data to to CRM or Reports and then printing them from there? When do you project to have this work in Creator? Ray
Creator Report by Record Creation Date
I want to make what I think should be a very simple report in zoho creator. The report would show us the number of leads we get per day. Should be easy but i can't see any way to add zoho record creation date to one of the report axis. Why is this field not available to add to an axis? This is a system field and i would rather not create a new field to hold the value as it is already stored. What am i doing wrong? I cant figure out how to use the Add Aggregate Formula section either so if this
Page Printing - Not printing record detail
I have created a page "test page". In the page I have embedded a stateless form "job detail". The "job detail" form pulls information when the field "Job Number" is selected. The "test page" looks great on screen but when I print the page I get all the fields from the "job detail" stateless form with no data or record information. All the fields are blank. What am I missing?
View criteria for blank (null) date field?
Is it possible to set criteria and/or filter a view to show only rows where a particular date field is blank (null)? If so how? Thanks.
Create a Task list based on dates from different forms
Hi all, I would like to create a task list based on information captured for different forms ex: I have a Client's Birthday fields - on Client information Form Broker Birthday Field on - Broker Form Follow up Date - on Referral Form So I would like to create a to-do-list / Task list if any of the above happens it should be added to the list ex: Client's Birthday - Mr Koos is having his Birthday Today with his Cell number ex Broker Birthday - Koos Marias is having his Birthday Today with
Zoho Creator Chrome App?
Is there a Chrome App for Creator? Seems to be an app for every other application but I can't seem to find one for Creator?
one lookup to fill multiple fields
Hello all I have two forms CLIENTS and CLIENTHISTORY In CLIENTHISTORY I need to fill the client ID, full name and office name I want to select the client ID and once selected the fields of full name and office name to be filled automaticaly from the data already stored in CLIENTS form How can I do it??? Thanks
Dropdown list contents listed out in customized order
Hi, I'm trying to setup a dropdown list with lookup relationship, and I'd like to list out the looked-up contents in a specific order rather than the default alphabetical way. Please kindly assist. Thanks.
Zoho Creator lookup field, getting contact ID
In my application I have a form Courses and subform Students. In my students subform I have a zoho crm lookup field (looks up contacts) labeled Student Name. How would I get the zoho contact ID of the record that I'm working with. All that I see in the field is what appears to be a concatenated first name and last name of the contact i.e. Bryan Annas. I need to update the record with application values and can't figure out a good way to do so. Thanks, Bryan
Export images from records
Hello, I have an application that uploads .jpg files. I would like to be able to export/download all the .jpg files for a specific record onto a local hard drive. How do I accomplish this other than saving the .jpgs one at a time? Thanks in advance!
Birthday's in Calendar
I haven't been able to find an answer to this as it pertains to Zoho Creator. I have a birthday field for employees children and am trying to get them to display on a report (Calendar View). They only show up for the year they are born, not yearly. Has there been a solution for this? Thanks, Brian
Information from South African ID
Hi there I am referring to the post made 3 years ago. I need to calculate the Date of birth and Sex form a South African ID Number https://help.zoho.com/portal/en/community/topic/extracting-usefull-data-from-south-african-id-number I am not sure where I need to insert the required information, also I need to adjust the code to suite my field names: I have an ID Number Field (ID_Number) and then a Date of Birth Field (Date_of_Birth) as well as a Male / Female option box (Sex1) Hope someone will be
Function fetch all records in a subform
Hello, I have a form with a subform and I want when selecting a client of my form subform records fill one box (with the fetch function). I have managed to do with the first record, but in my subform I register more than 2 records, the fetch only affects the first, I want that all records have filled that box. "R.Ordenes" if (input.Clientes1 != null) { if (input.Correo_Electronico != null) { dat = Clientes1 [ID == input.Clientes1]; R.Ordenes = dat.Correo; } }
How to show information to user after the form submission?
After someone submits the form, I want to give some copy/paste code to the user on the basis of the form's data that has been submitted just now. How can I do that?
Do I must need to create relationship using lookup field?
I want to fetch some data from another form using deluge. Do I must create a relationship using lookup field? or I can fetch the data directly via deluge script? Also, if lookup field is a must then what to do with that lookup field when I don't need it at all in my form?
Filtering data in iCal feed
I have created a calendar view report in Creator with one criteria. The report works just fine and shows just what it should. But, I have gotten the iCal link for that calendar and added the necessary parameters and I am simply getting an empty feed (no events). As soon as I remove the criteria from the rpoert, the feed works normally. To isolate the problem, I tried changing my criteria to a different field and that produced an empty iCal feed as well. Any ideas on what I'm doing wrong?
Questions
Hi, is possible make this? x=abcd i need put y=dcba Thanks and regards.
add and display running totals on a form
so i have two forms Material In and Material out we get material from different sources so i have on my product in form (table) product 1 qty 10 from PO xxxxx product 1 qty 7 from Job xxxx On my product out form i have a look up field to another form called product type, upon entering the product type i have a field called product on hand and i would like this populated with the total number of products from the product in form. i am using : if (Material_In[ID == input.Material_Type].count()
Updating field in report based on formulas from two forms
The scenario is this: two forms Materiel in & Material out one report Materiel on hand when material comes in it is logged on the "materiel in" form and assigned an Auto_Number when it goes out it is logged on the "materiel out" form using a lookup field back to "Materiel_In" Auto_number is there a way on the "materiel on hand" report that i can set a Materiel_On_Hand field that is something like //Materiel_in.QTY - Materiel_Out.QTY = Materiel_On_Hand IF there is a corosponding record in
Latest Creator Update bugs
@Creator Support First let me say that the new compiler is awesome, many thanks :) 1. Double fetch no longer works, eg: //this will not work x = Form_Name1[ID = input.Lookup_Field]; y = Form_Name2[ID = x.Lookup_Field]; input.Field = y.Field; 2. Numbers in drop-downs not saving when using "other" option 3. This no longer works: if(!Field.contains("No")) { alert input.Field; cancel submit; } get this error: Error details: Error in executing On Edit - On Validate script. Function '{0}' specified
Not able to total from subform
I'm trying to total the amount from subform and display in the main form. But it seems the for each loop is not going through all the rows. Here is the script I'm using: ProductTotal = 0.0; for each item in Product_Details { ProductTotal = (ProductTotal + (ifnull(itemTotal,0.0) )); } Product_Total = ProductTotal; What am I doing wrong?
If This then That
I'm having a bit of fun with a service called IFTTT. This offers Creator yet another way to interact with the outside world. Using IFTTT, you compose IF-THEN type recipes using ingredients like email, Facebook, and other Internet services. The roll Creator can play is to send an email and have IFTTT do something with it. For example, I'm using it to update a Facebook page. I have suggested to the IFTTT team that they also enable http post IF's, which is something Creator does well. IFTTT is still
Umlauts do not work
German Umlauts, e.g. ÄäÜüÖöß do not work in ZoHo Creator. sebastian.schaper
Calculation based on options selected
Hi there, I have 3 Option Boxes and based on the options selected it needs to give me an amount Ex OPTION BOX 1 : 1. Mamma 2. Pappa 3. Mamma & Pappa OPTION BOX 2 1. Single 2. Family OPTION BOX 3 1. Monthly 2. Yearly Say I choice 1,2.2 It needs to calculate a formula If Mamma and Family and Yearly then R195.00 Hope this can be done Regards
Dropdowns not listed as User Defined Fields in Lookup
I am a DabbleDB user attempting to rebuild in Zoho. Your Lookup fields are wonderful, and this is a feature that didn't work very well in DabbleDB (which is why I'm rebuilding from scratch rather than importing). But I keep running into the same problem: In Form2, I want to add a Lookup field that refers to a Dropdown field from Form1, but none of the Dropdown fields from Form1 appear in the list of User Defined Fields in the Lookup dialog box. All the other fields from FormA seem to appear just
Next Page