How do I convert drop down sting info to values?
Hello all. I really need some help, I am trying to get the following code to turn a set of drop down numbers to formulate as a sum. However I keep getting multiple error messages. I have tried the following variations: (Risk_Score_1_5.toLong() + Return_Score_1_5.toLong() + Time_to_Implement_Score.toLong() + Cost_Score.toLong()) (input.Risk_Score_1_5.toLong() + input.Return_Score_1_5.toLong() + input.Time_to_Implement_Score.toLong() + input.Cost_Score.toLong()) I have also tried the .toNumber()
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
Part of a form in a single column and part in two columns?
Possible? Thanks! Ravid
Function not returning value from another application
Function in Application 1 string userDetails.getCompany(string e) { x = "ERROR"; company = User [Email == e]; info company; if(company.count(Email)==0 || company.count(Email) > 1){ x = "ERROR"; }else{ x = company.Email; } return x; } Application 2 Calling the function from Application 1 string projectEdits.test(string s) { company = user_management.userDetails.getCompany(s); return company; } Results: If I pass a invalid emailID from Application 2, I get the desired result "ERROR". If I pass a valid
Fetch records and relate lookup fields
Hi, I am creating a Purchase order form, in which I have 2 lookup fields, one lookup is for the provider name and the other one is for the payment options. I woul like that when the user selects a provider only the payment options available for this provider are displayed. How can I do this?
On-Premises - Download - Generation Failed
I have already raised a support request for this but due to lack of progress I thought I would ask the forum if they can help. I would like to try running my creator application in the on-premises version. However I can't even get started, as when I attempt to download any application from ZC, I receive a "Generation Failed" error. Does anyone know any way I can get the application download function to work?
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
Sub-Fields in a form? (or indent?)
Hi Zoho, I have a form with 3 fields for text. I need the user to enter a number for each field. Is there a way to get the numbder field next to the text field, in a way it will be with a little indent or closer to the upper fields (the one its associated with) than to the lower? (Except from building a form with two column, and to have the number field next to each text field its associated with) I've attached a photo with an example of what i'm looking for. Thanks!! Ravid
Dropbox Selection Changing Form Options
Good afternoon community, i just have a quick query. is it possible for me to have a dropbox selection determine what shows up on my form ?? What i have created is an employee onboarding form i have finished it on Zoho Sites Form maker but i would like to move it all over to creator so i can get someone else to be able to log on and edit it themselfs depending if a client wanted something different on it then the other clients ie. a mandatory field or a pay grade dropdown. I know i can use if (input.Company
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,
Inventory
I am trying to decide on Zoho or paying for a full CRM/ERP package like Netsuite. Does anyone have any advice as to whether Zoho can do everything it says? One area of concern would be inventory. Can Zoho integrate with a magento website and update inventory in real time? Thanks for the help. John
life insurance calculator
i am trying to find out if zoho creator would be able to show certain quotes for insurance based on a few simple entries into a data enter form basically someone will put in their age, gender, and whether or not they use tobacco. all of the rate tables would be loaded into the database, upon the person entering their above info, the database would show the results for 3 or more carriers based on their inputs and the database making the calculations in the background what would be the best way to
User Defined Format of Add Email Data to Form Simply Not Working
https://www.zoho.com/creator/help/forms/email-data.html#Adding_form_data_via_e-mail_in_user-defined_format I followed these directions to a T and it's not adding data... When I send an email with rich text I get a reply that says "Rich text formated email template is not supported, please resend the email as the plain text formated." ...when I take out the rich text nothing adds at all Can someone get back to me and tell me what I'm doing wrong?
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
Capture image directly into a record
I would like to build a contacts form with an image of the person. Is it possible to have a button on the form to capture a photo taken with an ipad or iphone directly into the record?
Display outcome of fomula field as currency
Hi, I am creating a form, which has a formula field. The formula field makes the addition of two currency fields but the answer is not the currency, is a number. I would like the outcome to be displayed as currency. How can I do this??
Delete record using a link
Hi Zoho, I'm trying to create a link (button, actually) that when clicked will delete a record using its ID. I've managed to create a button linking to edit mode of a specific record using http://creator.zoho.com/<zoho.loginuser>/<zoho.appname>/#Form:<FormName>?recLinkID=<LinkID>&viewLinkName=<ReportName> Anyone with a hint how can I delete a specific record? Thanks! Ravid
Creator/Support Integration <response> data type is incorrect?
While trying to integrate Creator with Support, I have determined either the online documentation is incorrect or the return response data type is incorrect. Here is the reference document: https://www.zoho.com/creator/help/script/get-records-support.html The above doc states that the return response data type should be a "MAP" in the Syntax section. where, <response> is the map variable returned as response. When coding it as a MAP the error is expecting an "INT" upon saving. Here is the code that
Hide/Disable Does not work when entering edit mode directly
Hi Zoho, On an html page I've created a button linking to editing a specific entry in my form, using http://creator.zoho.com/<zoho.loginuser>/<zoho.appname>/#Form:<FromName>?recLinkID="<LinkID> &viewLinkName=<ReportName>" Main issue - when opening the link, the form is shown with all field shown and enabled, although some are hidden / disabled at On Edit -> On Load. This is very important.... Why is this happening? Ravid
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()
Autofill using a link to the form?
Hi Zoho, On my html pages I have a link to a form. I'd like to have few of the fields in the form autofilled by variables from the page (I have the same link in 3 pages. I need the project name on the form to be auto filled with the project name from the html page directing to it). Possible? Thanks! Ravid
Only displaying section tabs to certain roles
Is there a way to restrict section tabs so that they only appear to users of certain rolls? There doesn't appear to be a way to do this other than hiding or showing the tab in the live application regardless of who is logged in.
Idea For A New Application
Hello everyone, i apologiose in advance if i have posted in the wrong section of the forum. I am looking for some advice as i have an idea for an application that i either need to build myself which i think will be far to complex for my ability or alternatively get an idea of price to build the application from a developer. I currently have an Excel spreadsheet to calculate the information for me but i want to offer it out to other people on the cloud as a subscription so customers can access the
Is anyone having an issue with the new ZOHO Creator to ZOHO Invoice Integration API?
With the old zoho invoice integration API I was able to create an invoice and have the invoice automatically emailed. With the new API, I can create an invoice but can not email automatically. I have to manually go into zoho invoice an email each invoice individually. Is anyone else having this problem. Creator support will not even answer my emails as to when this will be resolved. This has been an ongoing issue for over a week and all I get if I get to talk to someone is the old "we're working
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?
Production management app.
Here's what I need: I need to be able to upload a list of tasks with assigned numbers from a spreadsheet.. 105,205,305...Then have a button to activate a start and stop timer that logs how long each task takes. Can creator do that?
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
convert list or Map to JSON string
Is there a built in function to take a Map list and format the list into an appropriately structured JSON string? If not, is anyone familiar with deluge code snippet that would perform this function? Even better, is there a method to take the existing form displayed and convert the fields and value pairs to the JSON string?
Clause to Fetch
Hello all, please help me fixing this issue, I am trying to delete the Contact Number field and i do not understand what is a clause to fetch script? I have wasted hours searching for this..
Multiple lookup-fields referencing same form
So in form1, I have lookup fields lookup1, lookup2 corresponding to field1 and field2 in form2. Whenever I change value in lookup1, I want value in lookup2 to change to the field2 value in the same row in form2..... this is dumb request... but can it be done?
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
"Add record" to form does fill in its subforms
Good Morning Zoho! I have a main form with 3 subforms. I've managed (thanks Damien!) to auto-fill a few fields in the subforms based on entries on the main form. BUT- When I add an entry to the main form using "add record" on an "On Success" of a third form (hope I'm clear on this) - the subforms are not filled in - even though on the main form their default entries are set for "1" so at least one entry should be added.... Another thing - even a field in the main form that should be filled based
Script link subform back to form prior to saving record
Hi, I have a form with a subform, linked via bidirectional lookup so I can see or modify the associated ID's. i.e. The Form is for each Contact, with a Subform listing Phone Numbers associated with that Contact. Each Phone Number has a field showing the ID(s) of the Contact(s) associated with that phone number, so I can lookup both ways. This works fine. Now, I want to create a new Contact, and script to add a link back to a default Phone Number (i.e. all colleagues in the office have at least by
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
Set variable for a subform does not work?
Hi Zoho, I have a form with 3 subforms in it. I need the subforms to take values from the main form. When scripting with "set variable" under "on user input", setting the variable for one of the subforms' value (Subform.ValueToUpdate) , when trying to submit the form I get an error "unable to execute update record task". Off course, when loading the form the subforms are all empty. How can I fix this? Thanks Ravid
Next Page