Import XLS
I'm sorry to be a nnob, but I can't find anywhere to import records from an xls into a creator db. I read that it was in settings on the live form, but I can't find this. I have admin proveleges. Thanks NT
Left field type is string, right field type BIGINT
Dear, I am trying to look up a value in a form field (field A), based on input in another form field (field B). In the "On user input" field of field B, I have the following code : varA = Status_action [Status_name == input.Status_name]; input.Status_ID = varA.ID; However, I get an error that the field type of the field on the left is String, where the field type on the right is BIGINT. (in reality, the field on the left is a lookup field, looking up the field on the right; hence I would think
If rate currency field is blank pull from a joined form a default rate
We have a billing form that contains a project id. We would like help in the following please. If the client rate is not entered in the billing form we would like to pull the rate from the project id form from a billing rate field. If the user changes the input it should not pull from the project id - billing rate field.
Make the browser tab text relevant
Like most people, I have a number of Zoho Creator tabs open on my browser at any one time. However, the text next to the tab icon is always the same. It would be really useful if the text next to the tab icon was the name of the view currently displayed in that tab.....thus making it easy to select the tab I really want.
Displaing text / comments to a form
Hi Zoho, In my form I need to be able to display a few text lines between fields, and also comments for a field. to make myself clear - these are text lines I write, not the user. How can I do this? Thanks Ravid
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
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
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
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.
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
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
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?
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()
Part of a form in a single column and part in two columns?
Possible? Thanks! Ravid
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?
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
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?
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
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
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?
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..
Next Page