Heelp urgent: Somebody can tell me why my script did not work. Fetch data from a father form
Hello I have dificulties to retrive data from a father form, because the system not retrive me the information I need. I puted the following code in the look up field on user input action: if (input.Correo_Electronico1 != null) { tempo = Principal [Correo_Electr_nico == input.Correo_Electronico1.toString()]; input.Nombre_Completo1 = tempo.Nombre_Completo; input.Estatus1 = tempo.Estatus; disable Estatus1; } Somebody please heeelp me, is urgent
sort a combined date/ string field
I have a form that I'm viewing service history with a drop down list. All of the information I need is stored in the Service_Request form. I would like to pull out the service date, the type of service and a description of the request. Below is the code to pull the data from the form assemble it, sort it and place it in the drop down list. for each rec in Service_Request [Site_ID == ThisAccount.ID] { ThisRequest = rec.Schedule_Date + " - " + rec.Request_Type + " - " + rec.Description_of_Issue;
Problems Total on A SubForm
Im trying to Total the cost of a list of products in a SubForm. I take a look for the same script in the New Order form for the Order Management app, with no satisfactory results. I use this code: This Code is Located on User Input in the field where I change the quantities row.subtotalcost=(row.pcostadd * row.pqty); totaltemp=0.0; for each rowvar in Subformpadd { totaltemp = (totaltemp + rowvar.subtotalcost); } The error message I got when I fill the SubForm is: Error in performing the operation
Users And Permissions : addon price from old Express Professional Plan
Hi, I manage an old Express Professional Edition at 99$/month with 19 users. What is the price of addon to use feature "users and permissions" ? Or should I migrate to new plan ? Thanks a lot
Cannot duplicate application
When we try to duplicate the application we have called Ci Production 3.1, it says "Duplicating" for about 10-15 seconds and then the screen flashes, but the application is not duplicated. Please help.
CRM Plus or CRM versus Creator...?
Hi there (I have already had a brief discussion with Zoho on the phone re this - so am just seeking others input) I have already signed with CRM module - all good - and you can customise it etc - even better! And it has Vendors and Products (which I can also customise) and of course Creator can pull in records from CRM. And CRM is pretty sexy etc. The question is - why would one buy CRM or CRM Plus when you can basically do the same stuff in Creator (just your development time). It is not about saving
New - HTML / Custom Actions - number of records - lots of q's
Hi all New to Creator and so far VERY impressed. 1. A couple of things - is there a way to have custom buttons? I see you can have Pages (and have not played extensively there yet) which looks like u can embed HTML... not sure if that is an option...? 2. What defines an app? Considering an app can have as many "tables" as you like - why would you have more then one app? So if an app can have plenty of tables and forms and even "call" (relate/refer) to other apps or forms of apps. I then thought maybe
Maximum number of forms per app?
Is there a maximum number of forms per App? I was unable to find this information in the user documentation.
How to line fields horizontally.
Considering there's currently an option to have double columns in a form, do you guys support multiple columns? I am trying to build a form to mimic the layout of the spreadsheet we currently use, so the request quantities are inputted into fields named by the Week Number. I've tried using a SubForm to manipulate the field layout to line up horizontally, but the data then isn't stored properly. If there's no way to create multiple columns in forms, do you guys have any suggested workarounds?
Locked out of Creator account
I signed up to creator and paid the money. I was issued with a receipt conforming I had paid. My bank account was debited. I created my first important application and all worked well for two weeks. I was still in the process of developing it. Recently I transferred my email hosting to ZOHO as well. I set up a few email addresses which work great. Now I can't get in to my Creator account. Is this related to setting up email?
Drop Down Picklist Issue
Good day I got some problems creating an automatically filled picklist, when I try to Save the Script I got the following message "Error modifying the page" Null I have this code must have Equipo ( displayname = "Equipo" type = picklist values = Products.ID displayformat = [ Products ] allow new entries = true [ displayname = "" ] searchable = true width = 206px )
custom json export (link creator report to external app)
hi just need integrate creator's app database with external application application query data from creator's app via json how can i make creator's view so that external app can access it and query data via json? (in manner as on screenshot) or it can make via Zoho Reports functionality? example of data that external app understand:
Delete Records
Hi. I wish to delete records if a field contains a certain character. "contains" isn't allowed in the script builder. Sorry I'm new. Learnt Excel over many years, now switching to Creator. Also, I need a place to learn how to do all this kind of stuff. Any suggestions.
submit hide
Hi, I want to hide submit field,becoz my data is very important,If i make any mistake,the whole record gng to be wrong,thts y i am asking.If i finished all the fields then only show submit button.Its possible? Please reply me! Thank You!!
Retrieve data based on previous two drop down selection
HI, I have a form like below image . What I am trying to do is update this form data by using stainless form where user first Enter the "TV Station" Name form drop down and a script will run on User input on "TV station" to populate all related "Network" name in the "Network" drop down field. After that User will go forward and select the "Network" name from populated value. So on User input on "Network" Field I would like to populate the "Cable" name to corresponding field automatically. For
zoho table
Hi, My Application is Reservation System, so i want to show my field company_name,occupancy_type,Room_type,etc.., I got ans for all possiblity, becoz i give some condition in back end process if((company_Name =="aa") &&(Occupancy_Type=="Single_Occupancy")) { input.Rate =2300; } so i put more condition like this (i have 20 and more company).My another idea is these values store under one table ,so dont giv a condition but that field take this table and display that values.That table
Calculated date from formula shows up as text in pivot table report
Hi there, I have a formula in a form that displays a date in a list view report that I have created. It displays as a date with no problem there. However, when I try to include the same formula result in a pivot table, it's not showing up as a date but rather as text. What do I need to do to this formula so that I can have it display as a date in both my list report as well as when I am trying to build a pivot table report around it? Thanks.
Some criteria can't be supported when edit records via Creator API
This is my appication url： https://creator.baihui.com/creatorissue/testapp/#View:view I've tried to update record by using Email as criteria. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <form method="POST" action="https://creator.baihui.com/api/creatorissue/json/testapp/form/test/record/update/"> <input type="hidden" name ="authtoken" value="0b9a1897ac10cf66a9e699f688cb6522"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="text" name="criteria"
Using images as hyperlinks; Adding Alt and Title strings; Setting Image size
Here I am sharing my experence as tutorial; could be helpful Using images as hyperlinks; Adding Alt and Title strings; Setting Image size Scope: Following Tutorial applies to images added as field type image (not file upload). Step 1.Please prepare image named “TestImage.jpg” with approximate size 100X100 px. Step 2. Create form “Images” with 2 fields: Field 1: Type: Image; Field Name: Image; Field deluge Name: Image Field 2: Type: Multi Line; Field Name: “Multi Line”; Field Deluge Name:
How to calculate difference date?
Hello İ have form A And i have form B İ want in form B a field to calculate Added time form B - Added Time A (or current time) İ tried to this with formula but there is a error whic says one field is string the other float Thanks for help
Fetch total number of unique values
Here is an example of what I am trying to do. There is a Projects_Form and Employees_Form. In the Employees_Form, there is a multi-select field named Related_Offices. Each Projects_Form Record contains a multi-select look-up to the Employees_Form. I would like a field in the Projects_Form called "Total_Number_of_Related_Offices", that automatically displays the number of unique related offices for that project. For Example: Form: Projects_Form Record: Project One Lookup: Bob - Human Resources,
getDayOfYear() with leading 0's
I am trying to use getDayOfYear() to generate a date code for orders, but would like the output of the Day of Year to always have three digits. For example, I would like Jan 1st to be 001 instead of 1. Feb. 3rd would be 034 instead of 34. Here is how I am using it: if (((input.Wash_Date != null) && (input.Washpack_Step != null)) && (input.Batch != null)) { year = ((input.Wash_Date.getYear()).toString().getSuffix("20")).toLong(); step = Washpack_Step[ID == input.Washpack_Step].Number;
Question about making data publicly available
I have a report from a private application that is embedded in a Web site. My understanding is that using the permalink feature allows the private view to be shared publicly. Now I want to add a custom action to that report that will allow the viewer to generate a record summary report with one click. Here's the custom action: openUrl("record-summary/Force_Player_Profile_Report/" + input.id, "Same window"); It works when I am logged into Creator. However when I execute it through the embedded
Hours Worked Time Sheet
I put together this script for calculating for my time sheet. All hours worked are during the day. Start_Time and End_Time are Date-Time fields. Break_1, Break_2, and Time_Taken are decimal fields. This appears to calculate correctly, and meet my needs, but I want to check before implementing it. Does anyone see any reason why this wont work? startmin = (input.Start_Time.getHour() * 60 + input.Start_Time.getMinutes()); endmin = (input.End_Time.getHour() * 60 + input.End_Time.getMinutes());
Change Report Script to show Totals not all records
Hi Guys, I have the current script to generate a report: spreadsheet Hours_Report_for_Wages_II { displayname = "Hours Report for Wages (II)" show all rows from Employee_Time_Sheet ( Name Hours ) filters ( Date_field "Last Week Hours Only" : Date_field in last 7 days ) group by ( Name ascending ) } Can anyone help me with how I edit this script to the report only shows one row per Name and the total number of
Custom action to send veiw/ report via e-mail
Hi, I'm having trouble understanding how to configure a custom action that would allow me to send a PDF or plain text copy of a Form report/view. I followed the instructions on the How to , however I am still not able to send the report via the custom action The custom actions sends the report but it does not send the report (PDF file) I have a work assignment form which consists of a an Employee field. The employee field is a look up filed back to my Employee tble. My Employees tbl consists of
Users And Permissions
Dear Sir I would like to set permissions for some fields But i can not do that In the notes it says some old accounts can not do this I have to solve this please help What i want is easy I want to create roles and i want to set some fields to be shown some groups and some other other fields What i see now Show field to Admin or Everyone.I need to create some Other goups such as Account Department or Exporting etc Thanks
Zoho Creator Won't Take Pictures on iPhone 5C
We noticed on our iPhone 5C that we can't take a picture while in the mobile app. Everything else works great. When we hit the camera option all that pulls up is a blank screen. The camera will not work. Is this something that just occurs for the iPhone 5C and is there a fix? Thanks!
Date Time problem
Dear Sir, I already try Many Date, only 2/11/2014 return Wrong Result.. Why same formula return two different result ??? (((End_Time - Start_Date_Time) / 1000 / 60 / 60)).toLong()
Tooltip not working
Hello, I configured a tooltip message as indicated here: https://www.zoho.com/creator/help/fields/configuring-tooltip-for-a-field.html but is not working. The field is numeric and I've tested in Chrome Version 38.0.2125.111, Safari Version 8.0 and Firefox version 33.0 Thanks!
if (First time user input)
Is there a way to only execute a function if a user has not inputted into a field? For example, I have a form with a Start_Time and End_Time. I would like that if "On Edit", the End_Time will be set to now, but only if it has not been previously inputted by a user.
Email Address
I've created a web form that's embedded in our website to enable clients to register support requests. I want to be able to automatically send an email confirmation back to the client for each request. However, at the moment if I send an email automatically, it shows my personal email address, martynhale@vct.uk.net as the sender. I want to be able to use something like support@vct.uk.net. How would I do this? Thanks, Martyn martynhale
Create an upload button as Custom Actions in a report
As we know with the custom Actions in the reports we can create buttons with call functions. I would like to ask you if there is any way to create an upload button in the reports in which I can upload files from my PC. Like the upload button in the form creation.
Sub forms on iPad
Any news on greater functionality for sub-forms on the iPad? I cannot get any forms with sub-forms to appear. My sub-forms do not have image or file upload fields. Zoho creator support lists the limitations as such: Zoho CRM field] is not supported. Charts and Pivot table in reports are not supported. Limited support for Pages (HTML View). Subforms with file upload and image upload fields are not supported. Forms with Rules are not supported. According to these limitations, my form should
problems using a lookup in a stateless form
I have a table <MyTable> which has a lookup to another table <Data Table>- so far so good. I have a stateless form which receives the ID of the row in <MyTable> via a function. I can then pull the row in <MyTable> and populate the stateless form. I need to be able to populate the Lookup with an existing value from <MyTable> and allow the user to change the lookup value in the stateless form - eventually to save back to <MyTable>. Currently the stateless form has a lookup defined in a similar way
Formula Field return with dollar symbol
Hi, Create this formula (Pago_Total - Pago_Total * Porciento_de_Descuento / 100).round(2) and work great but I need the return value with the dollar symbol ($) in the formula field and in the column total.
My schedule doesn't work
Hi there, I have a problem with my schedules. I tried both custom and form ones, set the right timezone (CET) and they don't seem to be working. Even though the right time, set in "When to do" passes, no activity is reported in Usage Logs neither the e-mail is sent. Can you help me please? Thanks in advance, Stan
Fetch records from Zoho CRM and update picklist
Is it possible to fetch the values stored in a Zoho CRM picklist and add them to a Zoho Creator picklist. i.e. I have a field in the CRM called 'Roofing Type' in which I have about 10 different types of roofs which I select depending on the job. Can I have zoho creator pull this list onto a picklist in zoho creator. That way I only need to add different roofing types into crm and it synchronises with creator.
Retrieve all related data based on lookup field selection
Hi, I have a form and which has several fields but two fields are TV station and Market ( Market is the lookup field of market Form). below is the data format. I am trying to update this form data by using another stainless form.What I am trying to do is put a Market field drop down above on the stainless form and when user select the market name from drop down then a script will run to retrieve the related TV station name in the next tv station drop down field. For instance , if user select
IOS linked record searching
Hi, I am using zoho creator on ios devices now, after using it primarily on android before. One thing that I have noticed is that when searching a linked record in a form on ios, the full list is not populated, only the first portion. This is fine for me as the list (typically) loads more results as I scroll down. The problem I have been having is that when swiping up to reveal the search box, the search will only return the results that are already loaded, which kind of makes the search useless.
Next Page