How can I create individual records from a subform?
is it possible to create individual records from the inputs to a subform instead of displaying everything in the same line?
Deleting scripts
Hello - I am working with writing scripts for field actions on a form. I wrote some simple scripts to cause an alert box to appear, etc. when a field on the form was "user input". However, now I cannot delete the script. I go into the free form script and delete the lines, but, when I access the form and change the field, Zoho puts up an "Error message" that it cannot execute the user script. Yet - there is nothing in the script I can see? I am sure this is simple to fix, I just cannot find out
Why is creator adding rows in a subform when it opens a form?
Hi, when I open up a form Zoho creator adds records to all the subforms, triggering all the add row scripts and giving me errors because they calculate off fields that haven't been entered yet. Why is it doing this - I don't want rows already created. How do I stop it? Thanks
Where do I find a comprehensive list of Zoho CRM fields to use as reference for mapping
Hi, I have got some great help in learning how to create a task in crm from creator but I don't want to have to go back to you guys every time I want to slightly alter my map or create in a different CRM module. Where can I find a comprehensive list of CRM fields and their deluge names? The list that is in the setup section of Zoho CRM does not seem to be complete and does not include the deluge names. Does this exist? Thanks again for the help
Customer Portal - NullLogin capture
Hi All, We know that via Customer Portal, we restrict who sees what from the main-app. This is good, However, when it comes to reporting (HTML-page-custom-reports-kind), there will be links to other forms / reports / pages within the zc app, (which makes sense as a whole) However, since those (forms / reports / pages) are not explicity shared to the CPortal urser he has not access to them .. this is good too. It has to be this way. However, what comes next is what troubles be a bit from UI perspective.
String to Value
New to Zoho, How can I convert a String to a Value? I have two drop downs that rage in values from 1 - 5. I would like to sum these values in a formula field. Any help is appreciated.
Loadin Custom Action
Hello, I have a problem. I want modify my viewer "LOADING" custom action. I want see everyone record actions complete. One by one. Type. 1/100 - Complete 2/100 - Complete 3/100 - Complete
extracting date field from a date-time field
Hi, I need to replace the time in a date time field with another time. The .add(minutes) doesn't do this is - as it adds on to the current time. is there a simple way of achieving this goal?
I need make fetch an individual record in a subform
I want to do a fetch that affects a single entry from my subform. This subform is an independent form in which I filled a record. I want to invoke that record in a single entry from my subform, and another record different the following entry and so without affecting my other entries, My code it works fine if I open the form and use the Fetch. But it does not work when I try to use it when it is a subform if (input.Articulos_Cotizados != null) { if (input.Imagen != null) { fetch
Inserting data from last row in subfield into newly created row
Hi, I am creating a call sheet that has start times, duration of an shooting event (like travel time or setup time) and an end time. The end time is calculated from the start time + the duration. I want to be able to take the end time from the previous record and insert it into the newly created record because logically the start time for the next event is the end time for the previous one. I have attached a call sheet example to help visualise, it is the end printout so the time field is actually
Can you display forms from the creator app in the zohoCRM home page?
Hi, I would like to be able to list jobs my app (essentially a report list) in the home screen of ZohoCRM, is this possible? Thanks
Deluge Mode; numeric field not giving actual value
I am having an issue with a workflow where I have below defined: sendmail ( To : "email@email.com" From : zoho.adminuserid Subject : input.Vessel + "arrived at" Message : "" Attachments : template:Arrival_Report as INLINE ) However, the email notification arrives as below example: Example: 2912445000000210079arrived at It seems as in Deluge Mode I can only choose the relevant fields as numeric fields, which would explain why the ID is shown. So question is,
creating a record in zoho crm events and tasks
Hi, I have been able to create a record in zoho crm contacts module (although it took a while to go across and I ended up making 3 duplicates) but when I try the same for events or tasks it doesnt seem to work I am using the call function with Zoho intergration what are the key fields I need to enter to make the task or event appear in my feeds/calendar? is there a help document that deals specifically with adding tasks or events - the only one I can find is about adding leads Thanks
Function applied over invalid expression
Hi, I am trying to calculate various fields in a subform and am hitting the above error. The calculations work when I am in the subforms original form but when I alter the forumla for the subfield I get an error message I have isolated a simple example that if solved I could use for the actual formulas that are more complex (but not by much) in the original form the set variable would go Start_Hr_num = input.Start_Hr.toLong() that works but in the subform I am trying to use row.Start_Hr_num = row.Start_Hr.toLong()
Fixed Input
Trying to recreate an excel spreadsheet with a fixed input that affects the equations used in the spreadsheet. Does the fixed input belong on a separate form page or does it exist elsewhere?
Self referencing tables
I need to have a form that includes a dropdown lookup that references itself. For example a form called 'COMPANIES' where there is a field called 'PARENT COMPANY' that allows you to select from the records already entered in 'COMPANIES'. This doesn't seem to be possible - is there a way to do it?
Sum Sub Totals from multiple subforms into a Total field
I have created a form that has multiple subforms each with a Sub Total field and I want the main form's Total field to be the sum of the Sub Total fiels from all of the contained subforms. Can someone please offer me some script that can do this and a little assistance on where to enter the script please? (Would I enter it into the main form definition?) I currently have the Sub Total fields in the subforms displayed as USD and would like the Total field to be in USD as well. If it is possible
Email From Field - How to set it to a specific email address?
Zoho Creator will not let you set the From field in an email sent by the sendmail function unless it is zoho.usernameid or zoho.adminuserid. I believe this has been setup to stop spammers from using Zoho Creator. We do however have a ligitimate requirement to have the From email to be set up as a specific email address. The only way I can work out how to get around this issue if for me as the admin to change my email address to the email we want to use in the From field. This will not work as a solution,
How Can I Dump my own html in my domain
Hi I am writing my own html code and i want to dump it to my domain in zoho site hosting so can you please help me out thank you
Not an expert
In my mind I have an idea of what I want to create, but it is difficult to achieve it with the tutorials and the resources you give. In my opinion they are not easy enough for the common person like me. I think language in my country can be an issue. Even if you speak English as a second language, the computer language is a barrier. I think Spanish speaking people could get a lot more of your products if there were tutorials in Spanish and/or videos on how to create more simple apps. I think Zoho
USERS CANNOT ATTACH FILES - AGAIN AND AGAIN
AGAIN - MY USERS ARE HAVING DIFFICULTY TO ATTACH FILES IT IS THE THIRD TIME THIS HAPPENS ZOHO IS SUPPOSED TO OFFER ME A PLATFORM FREE OF THESE PROBLEMS
how do I add ddrop down field to a number
Hi, I am trying to use a drop down to select the hour for a scheduling app. I don't want to have 24 values because that is way too many so I want to use an am/pm radio button to create a calculation that will give me a 24 hour clock. There is also a minutes drop down that is included in the calculation so that the final result should say 13:25 when the user puts 1 in the hour, 25 in the minute and selects PM for the radio selection I have an if statement that captures for the am/pm not being checked,
How do I write the value of the autonumber field to a single line data field?
Hi everyone, I'm new to Creator, so please excuse the dumb questions... I have two forms, Person and Cases. Each form has two fields - Name and Client_ID. Person.Client_ID is an auto number field, but Cases.Client_ID is a single line data field. Cases.Name is a lookup based on Person.Name. I'm trying to update Cases.Client_ID on input with the value in Person.Client_ID, based on the looked up value in Cases.Name. When I compile the script I get the following error message : "Variable 'Client_ID'
postUrl not working
I am trying to post some data when the status field in my form is updated. I am using this code: result = postUrl("http://www.reviewill.com/zoho/ccnow.php", input.Price); In the ccnow.php: if($_SERVER['REQUEST_METHOD'] === 'POST'){ $req_dump = print_r($_REQUEST, TRUE); $fp = fopen('request.log', 'a'); fwrite($fp, $req_dump); fclose($fp);But when i update status field in my form, The post array in the request.log file is empty. I think zoho is not posting anything.
Convert JSON to XML for Related List?
Does anyone have a script example of converting a JSON string to an XML that is usable in a Related List custom function? Basically I want to display a list of cases from an external system as a simple table of 4-5 columns, ideally with a link. I can't even get the sample static XML (from the documentation above)to work -- the script editor just won't save it, maybe because of the quotes. Any help would be greatly appreciated. JSON snippet below (retrieved using getURL function): -- { "total_entries":
FX formula
Hello (again)!! I got stuck trying to calculate a FX formula. The thing is I don't now how to make the proper expression. This is how I want to calculate ((Strecka1 + Strecka2 + Strecka3) * Perkm ) + (PALL * Antal_pall) + (Antal_kartonger * KARTONG)+ (Startkostnad ) How can I write the proper expression for this) Another question, is it possible to use defined variabels in FX formula? I make a variabel named rec12 and give it a value but I can't use it in FX formula expression? Its
Formatting error ? 'If' statement
I have Three Forms -Material_Type_Form -Material_02_Form -Material_Out_Form - Stateless there is a look-up field Material_Type_Field in form Material_02_Form, which gets its list from the form Material_Type_Form. The form Material_02_Form does calculations for material in, on hold and out and displays the total on hand in a formula field named On_Hand_Field, for convience there is a hidden field, OHH, which is a copy of the output of On_Hand_Field but in string format. On Material_Out_Form, the
Where is the ERROR?!
if (Passaporte_Diplomatico[BI == input.N_De_Bilhete_de_Identidade1].BI()!"0") { busca = (Passaporte_Diplomatico[BI==input.N_De_Bilhete_de_Identidade1]); } Please help me!!!
Sort a subfield
Hi, I want to be able to sort a sub field but there seems to be no options to do this, if I create a sort in the original report will the sub field also sort by the same criteria? Basically I want to be able to create a call sheet that list times that people do various things in a day. The order of things might change and I don't want the user to have to delete rows in order to insert information. Basically the call sheet form holds multiple subforms with different information. The shoot schedule
Using "Yes" in a String
I want to have 3 conditions, most important is the "Yes" condition. Line 1 or 2don't work, but 3 does, but I don't have the "Yes" condition in example 3. How do I write the string? 1. if (((input.Billed != 0.0) && (input.Invoice_Email != null)) && (input.Resend_Invoice_Email == "Yes"))) 2. if ((input.Billed != 0.0) && (input.Resend_Invoice_Email == "Yes")) 3. if ((input.Billed != 0.0) && (input.Invoice_Email != null))
How to change web address path-name to reflect my updated username?
I created the zoho account with myname as superadmin username, I notice that the pathname is always show myname as part of the address path for zoho products even though I change/updated my super admin name from myname to othername. https://creator.zoho.com/myname/products-listing/ How can I change the path to reflect my updated username.
Member account can't read/write or see files in CRM
I have set up a second account in both CRM and Creator to test my combined applications. The second account (Victoria Joe) has standard permissions in CRM and in her profile is a member, but the software ays this is disabled. Basically my user can't access any records in the CRM, they don't exist in any way even though I have assigned contacts to her and while she can read creator records in both the native app and CRM she can not edit them. What am I missing?
Error in dynamic pick list script
I was hoping someone could help debug this for me. I have used a dynamic pick list a couple of times now and it has worked but this one won't - it gives me an 'error occurred while executing on user input script'. So I have a parent form (Equipment1) that has Equipment in it - Type: Cameras, sound gear and lighting. I also have a name for each one Name: Michael's Z1p (which is a type of camera) in a radio button field. In the child table (Equipment_Link) I want to select the type: "camera" in a drop
create subfield picklist from data in a third form
Hi, I have managed to create a dynamic pick list from one form to another The form is a Crew booking form that is linked to a crew form that contains the contacts details including the roles they are skilled to perform. The script is on the crew lookup on user input //create a picklist based on related crewmember's skills rolepicklist = Crew[ID = input.Crew].Roles_Available; Role:ui.add(rolepicklist); it creates a list of roles available based on the crew persons skills. My problem is I don't use
Response field for records to be filled by a different user
How do I design this form / report scenario in Zoho Creator: I've created a form where User1 submits work requests. I can see the corresponding report. User2 is the one who is supposed to deal with these work requests so I want to create a way for him to tag every request as pending / complete etc. and also to add his comments if any. What's the best way to design for this workflow?
zoho crm field displays incorrect dropdown
I am attempting to intergrate the zoho crm of both my Accounts and my Contacts in a Creator app. I can get a drop down to choose the Zoho CRM account in a field but when I click on the zoho crm drop down that is attached to the contact app it gives me a list of names that are partially contacts and others are titles or other fields. When I use the creator app through Zoho CRM interface the app lists all the contacts correctly. What is going on? Is this a bug? (see attached pdfs to compare the lists
Report Sort Not Working
Hi, I am trying to sort a report either automatically or using the arrows at the top of the report view but after sorting by 'shots' once it will no longer sort by anything else. I want to be able to sort by the field 'decimal' so that the user can change the order by changing the value of the row in 'decimal'. Why is the report not sorting? Other reports are sorting.
Any One Else Have Backup Problems & Secondary Options for Backing Up Data
Backup Issues Anyone? Are There Common Errors That Keep Backups from Saving?Has any one else had issues with backups failing? Our backup gets fixed and then it fails again. I'd appreciate any tips you learned if you have had this recurring issue. (Tip) One item we learned that may prove helpful to new users...too many lookup fields in one report can prevent your backup from saving. I don't know the threshold but Zoho Support said this was one reason our backups failed. Other Methods of Backing
Edit & Submit a Form Update via One Link in an Email
Hi, I would like to be able to edit a field or two in a form and for this to be done in a single click from an email that I create inside of Zoho creator. This would be very similar to an "unsubscribe" functionality where a user clicks a link, the link then edits a form where a field is changed "Active subscriber" from yes to no and then adds a date/time stamp, then automatically submits without the user even noticing. Is this possible? I have read this post... But it does not talk about how it is
Create Record and pass a Lookup ID from another module
Hello Guys, I'm using creator to create a record in Contacts Module and one in Leads Module. I'm doing that to separate fields that I use in each Module. ------------------------------------------------------------------------------------------------ fieldMapLeads.put("Last Name",input.name); createLead = zoho.crm.create("Leads", fieldMapLeads); fieldMapContacts.put("Last Name",input.name); fieldMapContacts.put("Lead Lookup",createLead.get("Id")); createRecord = zoho.crm.create("Contacts", fieldMapContacts);
Next Page