Set a rule
If I have two date-time fields in a table say mileage_log_start and mileage_log_finish. How do I ensure the entry in the finish is greater than the start field?
Image issues
New to Zoho , but I am having difficulty using the Image fields. I can not get a report to show images at any other size than small, I have applied different sizes to the form, different sizes to the report, made sure they were the same. What I really want to do is use the record summary option to customize the layout and size of my images on the report but they don't even render when I go this route. Am I missing something simple somewhere in my configuration
Video From Cellphone
The functionality to add a photo from a cellphone is really great, but can this be tweaked to include a video too? Thanks
BIG PROBLEM: Can't access my own Zoho Creator projects
Hi Zoho Support/Community, I'm testing out the free version of Creator which should allow up to 3 users. I've been working a lot in the last few days to finish a new application, and finally yesterday night I've done the first usable version. So, I was began to test the access the users access possibilities (3 at maximum at free version), and I've introduced a gmail address from a personal account. But I've found that gmail address is linked with my main zoho email (as secondary email), and now I
Subform images in report only showing first two images
I have a main form with a sub form which is used to attach images to the main form. I am try to create a report showing the details of the main form and then display all the images from the sub form. I can get everything to work as it should for the first two images but after those the third is displayed as an image icon and not the image itself. AM I missing something that is limiting the number of images displayed?
is the parameter of pageSize available in rest api view record ？
hi zoho ： is the parameter of pageSize available in rest api view record ？
Best approach to convert numbers to text in a pivot chart; if(minimum(field) == 0, 'No', 'Yes')?
I would like to show what a number means instead of the number itself. I have a survey with groups of questions. If all questions are answered 'Yes', then the answer for that group is 'Yes', otherwise the answer for that group is 'No'. Right now, each item has a score (No == 0, Yes == 1). I am taking the minimum of the score and placing that in the Color field in the pivot chart. The data is properly plotted on the chart, but the legend on the chart shows '0 and below' and 'above 0'. I would like
is there .notContains function?
hi try to check for variable - is it contain value when save script - system write that there is no such function why?
Deleting subform data with "Delete Record" task...
Hi All! I have used the "delete record" task many times by now and everything seems to be working fine. But I have encountered a problem on this spot: When this form is successfully submitted with an ID, I need to delete the record with that ID from a specific form. So far so good. But this form has subforms, so I need to manually delete their records too. I have tried the following: if (input.Form_Name == "Insurance01") { delete from Insurance_Sub[ ID == input.Rec_ID ]; Project_Name_Here
OpenURL during OnDelete -> OnSuccess being ignored
I have the following code in the On Success section of the On Delete action in a form: openUrl("#View:AQ_Report?ParentID=3007035000000362036", "same window"); It doesn't work there but the same code in the On Success section of On Add does work. Is there some way I can open a report after a record is deleted? My use case is that when the last record that matches a particular filter is deleted, I'd like to take users to the same report with a different filter. Thanks!
Pivot Chart
Hello all, I am trying to create a pivot chart to display predicted versus actual savings based on a month or a timeframe. This chart would also be able to display based on one initiative, multiple or all. It seems that you have to have your data sorted in a particular fashion in order for pivot charts to work. I have placed screen shots below of the form that I am using. The Predicted and Actual savings fields are currency fields. The "Entry Date" field only shows the date the info was placed, it
Convert Excel formulas to zoho creator automatically
Hi Is there a way to import formulas from Excel to Creator? I am trying to create an application based on an Excel sheet. The calcs are using basic addition, multiplication fields.
Filter not working on updating record
I have a field called devices_room which filters the look up based on input.devices_site. This works fine on a new entry but not when editing a record. Any ideas?
Variable as field in fetch item?
Hi Zoho, Is it possible to fetch an item with a variable as the field given? for example fields = {field1,field2,field3};%> for each EachField in fields {Current_Fetched = Form1.EachField;%> <%=Current_Fetched%><br><%}%> And I'll get the data from the 3 fields? Thanks Ravid
Organizing form
Hi Zoho community, I created a form for empleoyees managment and it has 48 fields. I would like to have this fields in smaller groups, like Basic Info, Education, Health Insurace, Social security, among others. is it possible to arrange them in tabs or something similar? I do not like how it looks like if I use subforms or having a very very long form to scroll up and down. is it possible? any idea or can someone refer me please where in the user guide should I read. Any help will be appreciated.
data submitting issue
Hi all i have a peculiar issue.I am developing a application for my business using a developer who is working a lot to sort out the issue bt he is not able to find a solution.SO now seeking a help from you all I have a order Form- which holds the data for the orders received I have a Trip Form where the actual order dispatch details are entered . along with these forms there are many other forms. My problem is when i try to enter a Data in Trip Form- there is lot of delay in submitting data and most
add entry via email - is there any field for sender's "from:" email?
hi! add entries to form via email https://www.zoho.com/creator/help/forms/email-data.html#Adding_form_data_via_e-mail_in_user-defined_format there are system fields ZC_Subject and ZC_Content is there any field to capture FROM email field? field of email sender
Show/hide with multi check boxes
Trying to show/hide 3 fields (17, 18 and 19) based on checkbox values. So far I have the following, which works fine if one box in field 16 is checked but hides all 3 fields if more than one check box is ticked. Is there a better way to do this? if (input.intake_form_1_question_16.toString() == "Completion Date") { show intake_form_1_question_17; } else { hide intake_form_1_question_17; } if (input.intake_form_1_question_16.toString() == "1st Fix Start Date") { show intake_form_1_question_18;
how to add record from anyone via stateless form?
hi! need to make next logic: 1) email from anyone -> 2) public stateless form -> 3) private zoho creator form task what i need to solve - every email that was sent to email "order@myemail.com" will be as unique entry in my private zoho creator form there are - private zoho creator form (yachting_zayavki) - public stateless form (email_data1) in both forms there are same fields ZC_Subject and ZC_Content how to make linking from fileds of public stateless form (email_data1) to fields private zoho creator
Fetch details from Contact module of the CRM to a form in Creator
I've used a lookup field (CRM) in the Creator form to get the contact name. On selection of the contact name, I want the form to auto update the Account, Email, Location and the number of the respective contact. Can some share a code to perform this operation?
Testing and deployment practices for Creator Applications....
I'm coming from a world where we deploy changes to a test site (via a migration), and then once tested we deploy to a production environment. What are the best practices for doing this in the Creator world? I appreciate your help in advance.
Custom Action executes only on one record
Hi, I configured a custom action in the report header. The code is only one line, updating a field in a record. void WalkIn.OrderManager.MarkTasksPaid(Task_Subform t) { t.Payment_Status = "Paid"; } I don't understand the help document: https://www.zoho.com/creator/help/script/custom-actions.html#Configure_the_function_as_custom_action_-_in_View_Header n the Execute action for each record, the custom action will be called for each record. This is supported for functions with any argument type.
How to stay informed about changes to Zoho Creator
I've noticed some improvements to Zoho Creator Free flow Workflows lately. Is there some way I can find out about recent changes and planned changes? The roadmap showed up blank for me. Ideas in progress seems to have items that have been completed but are still marked in progress. Ideas implemented doesn't reflect the kinds of changes I'm seeing. I imagine there are new functions and perhaps functions that will be changed or removed. There may also be changes to the interface for end users. I love
Is it possible...
... to dynamically update a selection field, say Multi Select from another table? For example, If we have a table of Room Names. We want to be able to have a Multi Select question that states, "In which rooms..." and populates the options with the names of rooms from the Room Table.
Disable "Switch to Plain Text" on a Rich Text Field
I have a rich text with all the toolbar options disabled. I do this because on load I am setting some default values that utilize html tags to create a predefined data entry template/guide for my users. Is there anyway to disable the "Plain Text" toggle option? I just essentially want a multi line field that can render html tags such as bold, pre, etc
Make parts of mult line field read-only/un-editable?
Hello, we have a multi line field in one of our data entry apps that pre populates with a "template" of sorts that guides/reminds the user of certain things that must be present in the multi line field. We must use a multi line field because the info varies too much for us to dedicate specific fields for each. My question is, is there any way to make certain parts of a multi line un-editable or read-only? Problem we are facing is sometimes users will delete the parts of template on accident or get
Large numbers on html page display as exponents
Hi Zoho, On my form I get large numbers values (millions, billions...). when displaying those numbers on my html they are automatically displayed as exponents (350000000 displayed as 3.5E+8). How can I make Zoho 1. display the full number 2. add commas for thousands ? I'd like to have 350000000 displayed 350,000,000. Thanks Ravid
Submit form without PayPal if total is $0
I have a registration form created in Creator that has several free and several paid choices. If a registrant's total is $0, how do I set the form to bypass PayPal to complete registration? Here's a link to it: https://creator.zohopublic1.com/heather.hare/event-registration-hsg-2016/form-perma/HSG_2016/TvrjweWR219CJ9PWr6zO3HnVbtZE5CJhgQrq3GTm245p9FF2gJVUeBnE8A2A51YP3HBJZDYQBeV4DhzkG7rUJmtx2YyN6Urb8jzz
Trouble with the total value of a subform.
Hello, I am working in a purchase order form with the following structure. Purchase order: date - date company - text provider - text email - email subform total order cost - currency Subform (in purchase order): reference - lookup to product catalog description - text cost - currency IVA - number cost plus IVA - currency quantity - number final cost - currency I wrote this code in the subform_quantity on user input section. if (row.cost_plus_IVA != null) { row.final_cost = (row.cost_plus_IVA
How do I hide the 'Add' button on reports?
When I want to allow users to add records, I need to copy information from a parent record in the same table. I can do this in deluge using a Custom Action button on each form and the Record ID for the row where the button was. Having the built-in Add button visible at the top of the page is confusing since it should not be used. Thanks!
Deludge script to modify all records in database
Hi, I have added a new field to an existing database and need to populate it based on the value in another field in the same database. New records aren't a problem, but I'm not sure how to run it on all the previous records that already exist. Specifically, I have a new 'Grade' text field (that is empty in the existing records) and an existing 'Standards' text field. I want to loop through all existing records and extract the portion of the 'Standards' field that precedes the '.': Example: 'Standards'
is it possible to embed a subform into a stateless form
Example I would like to create a stateless form to basically create header information for a timesheet application. I would like the information from the stateless form to be applied to each row in the sub form (not stateless) with the add row function. Does this make sense?
CRITICAL - Permalinks and Embedded Links Are Not Functioning
The permalinks and embedded form code are not working on all of our Zoho creator forms. Here is a screenshot of the embedded form code - http://cl.ly/1J1p2w1q3V2F
Is Zohopublic down?
Dear All, Is there any problem with the zohopublic domain? Is it down?
Trouble with decimal numbers
Hi, I am working in a form that has de following structure: Purchase Order Detail (form) Reference (lookup field) Description (multi line) Unit Cost (numeric field - currency) IVA (numeric field - porcentage) Unit cost with IVA (numeric field - currency) Quantity (numeric field) Total Cost (numeric field - currency) I set all numeric fields to not allow decimals. Also in the lookup related form. So when the user select an option in the Reference lookup, the Description and IVA fields auto populate
Auth Token
Hi, I try to get an Auth Token on both ways suggested in help but without success. for this: https://accounts.zoho.com/apiauthtoken/create?SCOPE This is the server answer #
#Wed Apr 13 16:07:34 PDT 2016
CAUSE=EXCEEDED_MAXIMUM_ALLOWED_AUTHTOKENS
RESULT=FALSE I am logged in that browser, so that cannot be an issue. Could you please advise? Thanks Balazs
Auto populate fields in a subform
Hello, I am working in a purchase order form with several fields for purchase details, like date, company, provider, among others and a subform with the details of the products to purchase. I have a Product Catalog form, from which I want to bring in some information to the subform. so I have this forms: Purchase order: date - date company - text provider - text email - email Subform (in purchase order): reference - lookup to product catalog description - text cost - currency IVA - number quantity
Getting Login exception (CLISession) while making session with SSH enable device with non admin user(Without root user)
Hi Team, I am getting issue in when I am making the connection with ssh device with non admin user. its working fine with root user. We have a device which is SSH enabled, In this first make the CLISession for port forwarding and then connect the device. We are using the CLISession API to make the ssh connection with device. We are getting below exception: com.adventnet.cli.transport.LoginException: Login Parameter incorrectRead timed out at com.adventnet.cli.transport.ssh.sshv2.SshToolsProviderImpl.open(SshToolsProviderImpl.java:879)
Change font size on data entry?
Hello I have a multiline field and my users are asking if there is anyway to increase the default font. I am referring to the size of the font as they type in the field. Some are having trouble viewing/navigating a large multiline fields on their phones.
3 showstopper problems - Function, Formula Field, Loading
I am facing 3 serious problems as I approach a Go Live deadline. Has anyone ever experienced any of these 3 issues: (btw, we switched to the new UI 4+ weeks ago and can't switch back) A. Ghost function: I am trying to delete an unnecessary Lookup field and I can't because Zoho claims it's used in a function that does not exist, what I call a Ghost function. 1. Event.Staffing_Status_2326100000001224424() I had a function called Event.Staffing_Status (without the ID). I deleted the function,
Next Page