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,
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
Next Page