How find the Modulus function in Zoho creator
Hi, I want to find the Given Number is "PRIME NUMBER" OR "NOT" So, I need this function where I can write the program to find the number is "Prime or Not". I have checked in Google, no where I found this function in Zoho creator application Kindly let me know, Thanking you, Regards Prashanth K
[Help, please. Have this problem] We are unable to fetch this data, sorry! Please note that your data is SAFE.
Hi, able to create entries, but cannot view them. Also received this error message. May we seek your kind help fixing this? Thanks, keen to hear from you.
How to enable one value in Radio button field ?
Hi, I want to Enable only one value in Radio button field. Say for example - I have 2 Live forms : Employee_Info forms & Beuro I have an Employee_Info Live Form , Attributes -- Employee ID [ Number ] -- Employee Name [ Single Line ] -- Gender ( Radio field) -- DOB [DATE] Another Live
Fetching data from one lookup to another lookup
Hi Support Team, I have Live Form A , with some Employee data - Employee_ID [NUMBER], - Emp Name [SINGLE LINE], - Salary [NUMBER], - Departments [SINGLE LINE ]. I have another form - B, - with 3 Different Lookup field fetching only Employee_Id and Employee_name,Salary (fetch from - form A) - Hire_Date [ DATE], - DOB [DATE], - Age [DECIMAL] - CALCULATED,
Subform
Hello, My main form "Store Records" contains a subform "Items List". I added a CRM field on the subform related to "Products" Module. Is it possible to have the subform act as follow, 1-Creating 4 fields "Product Name", "Product Description", "Quantity in Stock", and "Qty" which is the number of the selected product to be taken from store. 2-When the user select the CRM product in subform the first 3 fields data will also be fetched and auto filled 3-Subtract the amount taken from store and update
Insert data from form to subform
I have two forms, Event; Tickets. On the SubForm(it's the Tickets Form) located on the Event Form, I'm able to add "Promoter ID" and "Tickets Sold", to keep track of all tickets sold by a promoter, which then updates the data on the Tickets database. I have added row.Events_ID = input.Event_ID; to "On Add Row" to the SubForm on the events form, so I can also include the events ID, so I can produce proper reports. But, no matter what I do, I can't populate the rows on the subForm with the Form's ID.
Missing Application
Hi, I created a form using Zoho Creator, from scratch in August. Now I log in and found all my application and form with data missing as if my account is newly signed up. Please help me to look into the matter. This is urgent! Thanks and regards, Richard
Excel import
Hi there I encounter 2 errors during import of excel data. 1) Even though dates data is set correctly both on Excel an Zoho Creator side date field is not imported (see screenshots below) 2) Seems like Zoho modifies the value slightly during the import (see 10478..... value on the screenshots). Modification is very small, but for long numbers it results in import errors because of the length of the field. Setup in Excel: Date is not imported: Date format is correct in Zoho Value is modified (compared
Function for each, in a html page.
I have a code to enter all data "Model" on my subforms, but when I run the code me 5 data appear, all for the first record of my subform. I wish it were 5 data, the 5 Records in my subform. htmlpage Verificador_de_Correos_SP(recId) displayname = "Verificador de Correos SP" content <%{ x = 0; if ((input.recId != null) && (input.recId != "")) { orderRow = Ordenes [ID == input.recId.toLong()]; output2 = ""; output3 = ""; imagen = ""; output
Auto Fill from CRM to Creator field
Hello, I have a CRM field on my creator app (Sales Order No.). The user can select the created SO from CRM while using creator to enter records, and another CRM field which will be auto filled with account name related to the SO number chosen by user. I need to keep the last selected Sales Order # and the Account name, so the user doesn't need to re-select the same value incase entering multiple records for the same SO/Account. I'm using below code: on user input: crmresp = zoho.crm.getRecordById("SalesOrders" ,input.Sales_Order_No_ID )
Possibility to Drill Down into More Information?
I am using Zoho Creator and I have a form that I created to hold a list of contacts. The contacts table has approximately 15-20 fields that I defined (name, email, address 1, address 2, etc.). I have created a view of the contacts table that I have embedded into the page of another website. In the view that I created, I only have 4-5 of the 15-20 fields displaying (if I display all the columns in the contacts table the iframe becomes unattractive and has a long horizontal scroll bar). What I am trying
How to get a vendor id from Zoho Books?
I am trying to make a bill from a Zoho Creator list record but does anyone know how to get the vendor id already made in Zoho Books?
creating a graphical style report
I want to be able to produce reports on properties we inspect. the repots need to be graphically pleasing and will include lot of photos. the reports are done on a room by room basis (average is about 10 rooms) and in each room there will be 10-15 sub items(ie walls, carpets, furniture, lights etc) I want to collectthe data using zoho app creator and this will need to merge with data stored in the main zoho creator database. I have seen other programmes which link directly with an excel template
Get Error 500 After I enter login info
I go through the process of logging in, including two factor authentication, but then I get an error 500 screen. Any ideas?
More than two columns in Forms?
Hi, Is there any way to have more than two fields per row (or two columns)? Is there any plan to make more flexible the form field positioning? Thanks, Fidel Martín
Question conditional formatting (calendar)
Español: Buenas tardes, deseo aplicar formato condicional al calendario, dada la siguiente condiciones. Si la fecha del campo menos la hoy es menor a 7 días. Ingles; Good afternoon , I want to apply conditional formatting to the calendar , given the following conditions. If the field date minus today is less than 7 days. Example: conditional formatting ( "Test" { condition = ( (FECHA_V - zoho.currentdate) < 7 ) format = "color:#ffffff;background-color:#489641;"
Cannot save after editing in spreadsheet mode
Hi everyone, Please refer to the screenshot, after editing multiple records in the writing time column, I tried to click save but nothing happened. Then of course I cannot save my editing. Sometimes it works, but most of the time it doesn't. Please look into the issue and advise. Thank you Regards
URGENT | User does not exist? | USER ID 49606658
Dear Service Provider, None of my user have access to this application except for the app owner socure.bureau@gmail.com Please advise ASAP how this can be fixed. Please find attached print screen
Lookup question
Hi I'm currently writing a booking system for the theatre company that I work for. The image at the bottom of this post may explain it better, so you may want to look at that first!, but my problem is: The initial form ('New Gig') has 2 fields, 'GigID' (autonumber) and 'Event Name' As soon as this form is submitted, it automatically creates a record in the 'Tech' report, autofilling the 'GigID' and 'Event Name' fields (there are actually lots more reports, but just to keep it simple to explain)
Pivot Tables No Data, Help
List Reports are showing data fine, but our Pivot Tables don't show any data, as if there's nothing in our database. There's also some inconsistencies with "Select/Drag and Drop the Columns"; it's listing some column names wrong. It's as if Pivot Tables is unsynced from our database. Is there anything we can do to fix this?
Dynamically add or remove stages
Is it possible to dynamically add or remove stages from potentials based on another value in the form such as the amount? We have 3 types of potentials (small, medium, and large) each one has a specific set of stages. I would like to only show the stages that are relevant to each size.
Add the value of a single field to a lockup
I would write on a single field and the value of lockup were the same as the single field, then do a fetch automatically. I wish I could do this because I'll make a public view and not to display data from the lockup to the public, Thanks! if (input.Alta_de_vendedores == null) { if (input.Correo_electronico != null) { ALTA = input.Alta_de_vendedores.toString(); ALTA = input.Correo_electronico; x = Alta_de_vendedores [ID == input.Alta_de_vendedores]; input.Verificacion_Correo
Display multiple fields on calendar
Is it possible to display an event title and starting time on a monthly calendar report view? I only seem to be able to choose one field. I suppose I could create another field that combines them, like "1:00pm Staff Meeting", but the data is already there, it would be easier to just show a combination of the fields. Bruce Letterle Red Lab Media
Cancel an account
Hello to everyone in the forum. Anybody here know how? or where? to cancel an account on Zoho-Creator or zoho.com
Dudas sobre el limite de uso
Buenas tardes! Realice el pago de la suscripción por paypal , adjunto imagen. Debería tener habilitados 10.000 registros pero solo me dice que tengo disponibles 750. Me podrían explicar?
Maximum fields in a stateless form
Hi I'm doing a booking system for the theatre company that I work for, and the tech section is quite substantial (100+ fields). I've split this up into several forms, but would like to enter the data into one big form (much easier for me) I've got the stateless form working, so that it updates a number of different reports, Do the limits on the maximum number of fields apply to stateless forms, or just to the reports that they're pointing at? It would be good to know this before I spend lots of time
FTP
hi, do you have a solution in ZCREATOR for read/write in a FTP ? thanks you
msg...... invalid entries found (HELP ME)
I'm and my public colleague receiving this msg when we try to add any app record... "invalid entries found please correct and submit again" in zoho creator. HELP ME PLZ as soon as possible
Integration with CRM
There needs to be a way of sharing prospect and client data between applications built with Creator and Zoho CRM. Creator gives the ability to build a full-featured applicaiton to capture and service the contacts/leads/prospects but CRM is needed to manage and follow-up. Last reference to this I can find is from Nov 2007. Any progress?
creator task to Zoho Crm
Trying to get the process clear in my head. We use cam and then creator to log customers equipment. Once a month creator produces a report of equipment that needs servicing. It would be useful if we could put a notification up in the contacts crm to say service due. the best way I guess is via a task. Is this possible and could someone point me in the correct direction of the process. I have searched but I am struggling to think mom the correct terminology.
Error when exporting to spreadsheet
Hi, When I try to Export my List Report to a Spreadsheet, I get the following error... This site can’t be reached The webpage athttps://app.zohocreator.com/tomroot/southsideassetmgmt/xls/Drawing_Tie_Outmight be temporarily down or it may have moved permanently to a new web address. ERR_INVALID_RESPONSE
Formatting (input masking) phone numbers in ZoHo Creator
I've been searching most of the day for this answer; how do you format the 'field' in a form that displays a ten (10) digit phone number correctly (as is displayed in most web-based forms). I can easily do this using Microsoft Access, however, I don't know how to do this in ZoHo Creator. (123) 456 - 7890 The idea is to just type in all of the numbers and "after updating" the format will be assembled to look like the above example. I keep reading about using 'strings', but since I do not know
Adding multiple emails to a script
Good morning. I have a small application that on the submit of the form emails to whoever is selected in the record. This script below works great. But I need to send it to multiple emails. I tried to add them and separate them with a comma. But when I try to save the script it gives me an error on line 2. Which is the start of the script. input.Management.Email From : zoho.adminuserid Subject : "PO Number" Message : "<div>Here is your PO number:</div><div><br></div>" + input.PO_number
Import data into a lookup field with multiple values
I've searched through all documentation/forums and nowhere is this simple use case adequately explained or documented I want to import data into a form that contains a lookup with multiple values with a form linked by lookup relationship. The classic example is I want to import data of students who have multiple courses. - I have a form for students. - I have a form for courses. - In the student form, the courses field is a multi-select lookup from the courses form. I have a .csv file that
Cannot create a zoho account via China mobile number to activate the account
I tried to create a new zoho email account, but when I activate the zoho account to let the system send a verification code to my Chines mobile number, I will never receive any code. Is this a known issue?
Restrict Search to initial filtered view?
hi - I have a view that is accessed via an OpenURL statement and has filter criteria applied on the openURL statement so the user only has access to view a subset of records. However, when they do a search from the view , then all records are searched and what gets returned are records they should not see - ie. the initial filter criteria is now ignored. How do i restrict this so the only records that get searched or returned are records that also have the initial filter criteria applied? thanks
Lookup multiselect - counting the number of selections
In my application I have a form for recording the published books/papers written by my colleagues. The form has also a lookup multiselect field for selecting the name of the authors from another form that contains the names of all my colleagues. For each published work there is allocated a number of points. For example, 5 points. If the published work has only one author he will get the 5 points. If there are two authors each will get 2.5 points, etc. I have to calculate for each author the number
Multiple selected records on 1 page table in Record Summary
Is it possible to create a Record Summary which displays certain form entries in a table...all on 1 page, instead of each record having a separate page. A similar command, would be the >>Next Record command in a Word Mail Merge. Record Column 1 Column 2 Column 3 Column 4 Record 1 >>Next Record >>Next Record >>Next Record
Updates
How can updates recods comimg from api?
How to Create a pop-up message?
I would like to create a pop-up message after a user submits his information. I see that you have a function called Alert() but this function is not listed under the More Task options nor under the Built-in functions to select from.
Next Page