making picklist for sub field
Hi, I have tried to get a picklist to pick only the equipment related to a type dropdown but it only lists one of the choices when there are three available. So the type lists Camera, Sound and Lighting The names would be Reuben's Fs7, Gregs A1p equipmentinfo = Equipment1[Type = row.Type].ID; row.Equipment_Name:ui.add(equipmentinfo); Thanks
Changing table border weight
Hi Zoho, I have a realllyyy big table. I'd like to have the table split, visually, by thick border lines. I've attached a picture to explain myself. How can I do this? Thanks! Ravid
Change start index of an auto number field
Is it possible to change the start index of an auto number field? after the first chance you have when dropping it
Best approach to obtain data from this type of Map
Hello, I have the following code snippet and I wanted to ask fellow dev on what is the best approach to obtain data from this map. What I'm really interested in is getting the Company string data from this map. Below I use a combination of prefix/suffix functions to get the desired data but is there a way to get the same data using map.get? MacLookupMap = { "responseCode" : "100", "responseText" : "[{\"company\":\"Lenovo Mobile Communication Technology Ltd.\",\"addressL1\":\"No.999, Qishan North
No idea what is wrong with this send email script
Hi, I wrote this code : if (input.Valor_Total_Orden <= 4000000); { sendmail [ from: zoho.adminuserid to:admin@vallesalud.com subject: "prueba OC" message: "prueba OC" ] } and I keep getting this error: Error at line number : 2 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression and I have no clue what could be wrong in line 2. Does anybody know?
addMonth not working
Any idea why addYear works but addMonth does not?
Send mail function with conditions
Hi Zoho fans, I am working on a purchase order form, in which I have several fields with customer info, provider info, etc. Among this fields a have a Total field, the final cost of the order. If this value is less or equal to 1000 it doesn't need to be approved so I need to send it to email addressA. But if the Total value is more than 1000 it needs to be aproved, so I need to send emails to email addressA, email addressB and email addressC. How can I do this?
Auto Number with different start index for different accounts
Hello Zoho community I am creating a Purchase Order form, in which I have an Auto Number field, for the number of each order. There is also a Lookup field with the companies we take orders from. Each company has a different count for the purchase orders. I would like the auto number field to relate the order number for each company. Example: Company A = current order 1 company B = current order 234 Company C = current oder 123 So, when the user selects in the lookup fiel company A I wold like the
Error: 'BIGINT' trying to update 'STRING' data type
Hello, I'm trying to fetch data from a report to auto fill a form. When putting in the code, I get an Error. Can someone help me fix this? Error at line number : 5 Variable 'First_Name' is already defined of data type 'BIGINT' but trying to update 'STRING' data type if (OC_Information[ID == input.Employee_ID].count() > 0) { ocinfo = OC_Information [ID == input.Employee_ID]; //input. refers to fields in current form input.First_Name = ocinfo.First_Name;
Indent inside a table cell
Hi Zoho! I'm trying to indent the text inside a table cell. So far tried "<td style="margin-left:50px">" and <td style="margin: 0 0 0 50px;"> <td cellpadding="50"> - all with no luck. <th></th> is not an option here. Any other solution for this? Thanks! Ravid
Scripted Record summary
We are currently using a form that contain many customisable products. The user customer can choose to use one or many of these. This was simple to solve in the form by hiding unused products, however when the customer has only chosen one product in the form the record summary still displays all of the options. My question is, is it possible to script the Record summary so that entries only show options that have been used? Or are we able to switch Record summary templates via a script when the
Custom actions - passing functions in criteria
Under Custom actions of Report, I am trying to add a criteria as shown in the image. For some reason it is not working. I am not able to pass ID as argument to the function - isValid. Any work around to pass the ID or the entire record as the argument ? Criteria (image attached) ID equals thisapp.wf.isValid(ID)
Customer Portal Sharing Data
I have created a developer profile and created a simple app, and customer portal. I have added a record to the app. I have then created a customer login to use/test the app and added some records. The problem is that both profiles see all the records. If I have 2 customers, they should only be able to see their own records, I can't have a system where they both see each others records. Is this possible? Surely it is a setting somewhere, but I cannot find anything in roles/permissions etc.
Can´t submit a main Form with subform
Hi, I'm trying to create an order sheet with fields like: "authorised by", "request by", "department". Then a subform with: "Product", "Quantity", "Price" and a "Subtotal" field per row. And finally a "Total" field in the main form which sums all Subtotal fields in every row of the subform. Right now i have this scripts: On user input: input.total = 0.0; row.Subtotal = 0.0; for each row in Orders { if (((row.Quantity != null) && (row.Price != null)) && (row.Subtotal != null)) {
How to refresh time display on each browser refresh (HTML page)
I script a HTML view with codes like TimeNow = zoho.currenttime; but when I insert code using <%=TimeNow%>in The HTML to display the time, it remains unchanged when next time I refresh the browser. Then I realised that even zoho.currenttime cannot be refreshed in HTML workflow during a certain time period. I found another time of starting a new session of browser can or cannot get a latest time display. So..... is there anyway to fix this to get a refreshed time once browser is refreshed. Many
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?
Aggregate formula
Hello! I have two forms with following fields EmployeeForm Employee name Hourly wageTasksForm Date Employee name Task Time spent I want to create report based on TasksForm that will summarize all the time spent by each employee and dynamically calculate employees salaries according to their hourly wage. Is this somehow possible? Thanks in advance for your help!
Add record in table
Hi, new to Zoho Creator, so far working with MS Access. Is ti possible to somehow have an Line in table view. where i could enter data? I mean, when adding new record, does it has to be by opening Signle record form? Tnx
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.
Restrict access rights to Forms and Views on ZohoCreator application main page
I am creating a Zoho Creator application that should allow users to edit information in existing records, but not to add new records. In addition users should I created a View and a stateless Form that are embedded on my website and that allow users to edit information in existing records, but not to add new records. In addition I created a handful of additional Forms that are opened as popup windows from the stateless "main form" that allows the user to edit detail information. The Views and Forms
Customer Portal and Pivot Charts
(Note: I am new to Zoho Creator) I am creating an application using the "Customer Portal". The data shown to the customer is limited to their own data. This is working for all Reports except when I try to make a Pivot Chart. On the Pivot Chart I am only able to add a Filter "ZRCriteria_Added_User". When I do this is shows all the Customers data for everyone (and the dropdown list of all users). Is there a way that the data shown is automatically limited to the logged in customer?
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.
Trialling Creator and need help
Question 1 - How would I add two fields from different tables? The first field is date field "Purchased Date" from Devices Form and the second is "Warranty" a number field (3 digit) representing the number of months from Products table. I want to populate a "Man. Warranty Expiry" date field in Devices Form. Question 2 - I have created a support ticket form with "Ticket Raised" Date-Time field in the Tickets Form. In another table I have an "On-site response time" which is a number field to illustrate
Copying the sub form in a same form
1. I have a form which includes a sub-form 2. I have a radio button after the sub-form asking YES or NO what i want-: if client clicks on NO, then he should see a second sub-form autopopulated by the values which he filled in first subform. how to do it. thank you for your help.
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,
Next Page