Weird identity issue
Zoho Creator's identity management has confused the hell out of me. My screenshot shows there are 4 different IDs associated with my account: lexshan1 lexshan8 lexshan@walkintour.com 51551681 I think lexshan1 and lexshan8 is related to data corruption. I might have two user accounts at one point. Such as one registered through Google Apps and another directly with ZC. Can someone explain to me how to consolidate these? I have another record access control issue which may relate to this. Application: https://creator.zoho.com/lexshan1/order-manager-v2/
Record Summary - formatting
In the Record summary, I need to format the sub-form Item like the invoice template in zoho help https://www.zoho.com/creator/help/images/record-summary-invoice-details.jpg how to do: formatting the Item rows (add line under each record) set the data position vertically (top /middle/ bottom Omar
Need a BUTTON that will increase the value of a number by 1. How do I code this in deluge?
Any assistance would be greatly appreciated. Say I have a shopping cart line item with a count value of 0. I would like a button to the right that increases the count by increments of 1. Is this possible in deluge? Thank you
Use same script for multiple pages
Hi Zoho! I have several pages in my system that use nearly the exact same script (2 different variables) How can I make the script to auto-update in all of them when I update the template? Maybe create some function that has the complete script inside and just get the two changing variables? Will really appreciate any suggestion on this one Thanks! Ravid
OnClick OpenURL?
Hi Zoho, I'm having some trouble here - I'm trying to create a button with an "onclick" event, theat will open a url using OpenURL command. this script <a class='zc-formbutton' onclick=openUrl("#Page:Pyxis_Loan_Lea", "Popup window") >Click me first</a> created a button, but clicking on it did nothing. What an I missing here? Thanks Ravid
Help please
I think Zoho is great but I am not a coder I am trying to fetch an email record for a customer from one form into another. I have Two forms Form 1 “New_Contact” Field Names are “Company_Name” and “Email_Cust Form 2 “Order_Details” Field Names are “Customer” and “Email” When I do look up of customer in Order_Details in field “Customer” I want it to fetch “Email_Cust and put it in “Email” Can anyone help me with the code.
Special Characters remove / replace
Hi Zoho, I need check for special characters in one of my string (text) fields in a form. How can I do this, except for a veryyyyy long "If" command listing all the possible characters? Any build-in function? I've tried if (input.Insurance_Type.contains("[/\-\(\)_@#\^!\$%\&\*:;`~ ]")) { alert "Special characters are not allowed in Insurance type field, please re-enter"; } Both on field -> on user input and on the form's "On validate" - but nothing happened Ravid
Rquested products total amount in report
Hi Zoho Community, I am working on a purchase request form. Through this form all company departments make requests of the products they need to the purchase department. Currently the report shows a row per product, in each row there is a quantity field. So for example, if 3 departments ask for 2 apples I will have in the report 3 rows of 2 apples each (it is ok,I need a report that looks like this too). I would like to have an other report that shows the total amount requested for each product,
Language Problem!!!
I have changed my language to English, many things are now seen in English, but a lot of important things are still in Japanese! Why? How can I have only English?
Does Sendmail rely on the local email client or is it cloud-based?
I have created a Schedule that scans a table for overdue tasks and generates a reminder email to the task owner. This runs nightly and works fine, but I just noticed that all the generated emails appeared in the Sent mailbox of my machine, which implies to me that emails are NOT being sent through the Zoho cloud host but rather through my local email client. That is not good, because it implies that if my machine doesn't happen to be running (and logged into Zoho, I guess), the emails won't go out.
Need ability to print a record
Is there a way to allow the user to print a retrieved record? I have read all user docs, developer docs, and posts related to this but there does not seem to be a way to do this. Thanks for any help -Greg
Stateless form on success insert to other form
I have a stateless form set up whereby people will enter details from a drop down look up. If (Health_and_Safety_Assesment (SurnameHSA == HS_Sign_In.Surname == null); insert into Health_and_Safety_Assesment; { Added_User = zoho.loginuser; input.SurnameHSA = Surname; } it is coming up with error on line one
Creating a Vendor Bill in zoho books using Creator
Hi i have a requirement to create a vendor bill in zoho books passing value from zoho creator.Please Help with the needed info on how to go about it for that. Thanks Giriraj.R
How to delete a Auto Number field?
Hi I want to delete a Auto Number field from FORMA but when i try it says it is linked to another FORMB. But when i go to FORMB, the field is not there in the form builder but i can see the field in field actions(strange). How can i delete this field from the FORMB so that i can delete it from FORMA?
Custom Action doesn't work from inside a Lookup
I have setup a simple Custom Action that uses OpenURL to open our Client Form in a new window. This works just fine when clicked from the clients report. I have an additional report with a list of tasks related to our clients. This report lists tasks from a form that has a Lookup field that looks up the client. The report shows the client's name, and when I click on the name, it opens up the client's record, so I can see his details. So far so good, and everything is working as it should. However,
Users Logins and Filtering Data
Hi everyone, I am a new user of Zoho Creator. I like it very much and I would like to create a database to mange monthly reports that I receive from couple of agencies. I am currently use MS Excel and Access. My question is related to users' logins and filtering data. Below is my question(s) based on what I want to do: I am the main user/administrator of the database, and can see and manage all data from all different agencies. Let us say that I deal with 4 completely different agencies (A, B, C,
Adding users / sharing the application?
Hi Zoho! I'm trying to add users from my company to use the Zoho Creator system I've created. Right not I have 7 separated pro accounts that are shared to the application - I think this is not what I was supposed to do... When trying to add the users on the "Share" tab under the application settings, it contradicts something in the system and the users cannot access the system at all. What do I supposed to do than? How can I set different permissions to users in that way? Thank you Ravid
Can I create a relational database
Hi everyone. I am trying to figure out how to link tables (or forms) with relations using Primary Keys and Foreign Keys, something similar to what in MS Access. Does Zoho Creator do this? and how? Thank you.
Image not displaying in PDF
I have a rtf that contains an image. The image shows correctly when I view the record using a record summary. However if I use the export as PDF link the image shows as a blank box. There is also a signature field that does show correctly. If I use the print button and print to a PDF using PDF Creator the image shows correctly. Is there anything special that needs to be done for an image to show using the built in PDF? Such as publishing the underlying report or form?
Webhooks into Zoho Creator
Hi I'm looking to integrate Zoho CRM with Instamojo payment gateway. Instamojo will post transaction details on to a webhook which need to provide to update my Zoho CRM database. The Instamojo webhook request is a request with content-type application/www-form-urlencoded. Are there any provisions in Zoho Creator to enable this? Regards, Varath
Alert if a record already exist
Hi Zoho community I would like to create an alert message if a record already exists in a report. can someone please give me a hint on what should I write or where should I read? I am trying this: if (Objecion[Factura == input.Factura].count() > 0) { alert "Este número de factura ya existe, Favor verificar estado."; } with no success am I in the right path? any help will be appreciated
Fetching Data
Hi, I am new to Zoho and i am currently stuck on something. Here is my scenario i wonder if you can help. My Girlfreind has a hairdressing company so i have created her a job record , payment tracking system. The form has the following fields. Date Name Of client (drop down selection using realtionships) (from Clientel form) Discount (dropdown list, with values set on the form) Job Undertaken (Multiple selection list using relationships) (from Price list form) Number : (used to calculate price from
custom apps- workflow task forms
I am trying to create a workflow task form. step 1: a user will inform that a new staff member will be joining (this is standard info-name/ start date etc) step 2: the contents of this form will flow to the IT department for them to action ( i am not sure how to get the filled in information from step 1 to come into step 2 (non editable just visible) step 3: some information gathered in step 1 & step 2, will be sent to another department for them to action some internal steps. step 4: a welcome email
Latest Version Bug with Subforms & Bidirectional Relation
@ Zoho Creator Support, In the latest version there is still an issue where the Bidirectional Relation field in the subform clears after updating the main record. I sent a support request about this a month ago. Since then I am using multiselect lookup fields in place of subforms, but I need to use a subform now(lookup field won't suffice). I have sent another support request. Can ye please fix this issue. Thanks, Damien Cregan Hire an Expert
Problems importing related data
I have an employees form (167 records) that includes a sub form to position history (330 records). The forms work properly when I manually add test data through creator. But I can not get the data to relate on import from excel. I've tried uploading both forms separately, and I've tried combining excel files then selecting the option to upload sub form data on creator import. Uploading separately populates the forms correctly, but the data is not related. Uploading a combined file creates 497 records
No scroll bar in upper banner on edit mode
Hi Zoho, On some screens there is no scroll bar on the upper navigation pane in edit mode, so I cannot reach some of my pages, reports and forms. Screenshot attached: Ravid
How to access data from one application through a page in another application?
Hello everyone. I am stuck in a part here. I want to access data from one application through a page in another application. Please do voice out your ideas and fixes please.
Scripts for multiple subforms
Hi, I have multiple subforms in a form and want to sum up the score fields in each one. I am using this script b = 0; for each row in input.General { b = (b + row.Score); } input.General_Score = b; c = 0; for each row in input.Hygiene { c = (c + row.Score); } input.Hygiene_Score = c; But I get error Variable 'row' is already defined of data type 'ZC_SUBFORM_85' but trying to update 'ZC_SUBFORM_60' data type Any help is appreciatted Ant
Create dynamic survey based on responses
Hi, I'm trying to create an application that is based on certain data that I've collected. The workflow would look like this" First, the user selects their hardware they currently have (can select multiple) Hardware 1 Hardware 2 Hardware 3 Then, based on their hardware selection, it looks up the services that are offered on each hardware, so for instance Service 1 Service 2 Service 3 Hardware 1 TRUE FALSE FALSE Hardware 2 FALSE TRUE FALSE Hardware 3 TRUE FALSE FALSE and retains
Setting and clearing field values on button press.
Hi People, I seem to be having an issue setting values upon a button press (in a stateless form). Defining a field's value works fine if the code is run "On User Input" or "On Load" however "On Click" does not set values. An example line would be input.text_field = null; which would normally clear the field but if called "On User Input" does nothing. Is this intended functionality or a bug? In any case, would anyone know of a workaround that still allows me to use buttons to define/clear fields?
My Email is going in SPAM of Recipient Email box.
Hello Respected Members , I have an problem which is coming from some days, it is not come when i am beginning my application. The problem is that the Email function (Which is added to the Form). It is confirmation type mail which is delivered to the Form Submitted user. But these days every generated mail is going to the USER'S Email Spam folder, instead of Inbox. Now please tell me what can i do so my mail is go to the inbox instead of Spam folder Please solve my problem , my many users are report
default view filter and/or removing view criteria
Hello, I have a view that I want to be filtered by default rather than having to open the view and then select the filter from the dropdown. Right now I'm using view criteria to restrict what records are displayed, but I don't see a way to turn this restriction off while accessing the view. My only alternative, and correct me if I'm wrong, is to have a view for each criterion and not rely on filtering— problem is, this is pretty inefficient. Any ideas? Thanks.
Display Multi-Select Field in HTML page
Hello there, I'm trying to show/display a multi-select field in a HTML page. Below is the code i'm currently using. <%for each task in job.Task {%> <h4><%=job.Task%></h4> <%} This is how it ends up displaying: <h4>3094299000000125003,3094299000000125007</h4>But I need it to display like this: <h4>3094299000000125003</h4> <h4>3094299000000125007</h4> If anyone could point me in the right direction that would be smashing. Thanks, Giles.
formula field to create a dynamic, conditional link. is it possible?
I am trying to use a formula field to create a dynamic, conditional link. I want to check to see if an organization has any members and if so display the organization name as a hyperlink in a view that links to a summary page for that organization. If there are no members in an organization, the organization name should appear as simple text (no link). I can get each step of this process to work individually but putting it together doesn't seem to work. Am I doing something wrong or is this just
Limiting options in number field
I have a number field, and want to use it in a calculation. Is there a way of scripting to limit the input to 1-5?
sync existing data base with customer portal users
Hi, I have an empleoyee report, with the information of all users in the company, among this info there is an email for each person. Now I activated the customer portal, in order to create an user for each empleoyee, what I am planning to do with the same emails in the empleoyees records. It tis possible to sync the users I create with the info already existing in the report? So far, I created just one user to test this with no success. I create the user, set his profile to be able to view only their
purchase order and purchase request
Hi, I have a Purchase order form, that works really good. There is a subform in this purchase order with the following structure. Reference (lookup to Product Catalogue) Description Cost Quantity tax Total Cost Status (dropdown with 3 choises: approved, disapproved and pending) Now, I am working on a Purchase Request form that has a subform with this fields. Reference (lookup to Product Catalogue) Description Quantity Status (dropdown with 3 choises: approved, disapproved and pending) I would like
Relation between forms
Hi Zoho Community I need some orientation creating relations between forms in my app. I will explain you what I have and what I want to do. I have a Catalogue, where my products are. I have Purchase Request form (PR), trough this form all departments in the company request the products they need to the purchase department. this form(PR)has a subform (PR Detail), that has a Description field, which is a lookup field to the Catalogue. It also has quantity field and Status field (dropdown with 3 choises:
Barcode Scan Record ID
It looks like record IDs are 19 digit numbers. When using the IOS apps (iPhone and iPad tested) it will not scan barcodes that long. Most I can get it to scan is 11 digit numbers. Is there a setting to restrict the number of digits assigned to the record ID when created? Or maybe someone can tell me about the structure of the record IDs? We only have 140 records so far, but they all start with the same 14 digits. The first 8 digits being 3014701 followed by 7 zeros. This leads me to believe the
Is your software able to implement this case?
I have the synonym database, including 2 tables: words table: id (int) word (text) synonyms table id (int) word1_id (int) word2_id Several notes 1. Columns word1_id and word2_id are id-s of words table records. I know that it is not the best solution for this specific task, but it is just the example. 2. Synonyms table cannot include two records with the same ids of both words (at least in the same order). I want to have one or several softwares (or online services) which makes possible without any
Next Page