Calculation of Values
Calculating values from 2 forms I have searched high and low for examples on how to calculate values from multiple forms. Im trying to calculate a running total from a staring balance field + deposit amount field + withdrawal field from 3 forms and display it in a Control Page, im in the process of creating an application that hopefully i can roll out to many members in the future and the formula above is an example of how majority of my field values are calculated. If i can get an example then it
How to Find a Field in Deluge Script
I want to delete a couple of fields, but I am not sure where in the deluge code it is referenced. How can I see where a field is referenced in deluge? And what if I don't want to delete a field, how can see where in the code a field is referenced?
can not add user to Zoho Creator
Hi, I had two users attached to Zoho Creator but deleted one so that I could add someone else. I added her to Zoho CRM and she can access that but when I attempted to add her to zoho creator - which we have two user permissions for and only one showing it says both are being used and I need to buy more. This is clearly not the case, what is going on? I have left it a day to allow the system to clean out and it has not worked.
send post url
Hello, i need help for some questions. I need to send data from table (For example: from row1 the sum of the all values, from row2 the sum of the all values etc) to web merge url. Url is: https://www.webmerge.me/merge/54626/7irksc Test data: ?&initial_users=My_sum_values_from_row1&growth_rate=My_sum_values_from_row2&arpu=My_sum_values_from_row3 But i really don't understand, how i can do this. So what i want to create [button], after clicking on this downloaded webmerge file from my data Thanks!
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
Is it possible to make a lookup from a multi line??
Hi zoho fans, does anybody know if it is possible to make a lookup from a multi line field?
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
subform field won't trigger
Hi, I am trying to get a on user input script to copy information from a emergency contact form into the join table that is part of a subform. The master form is Call_Sheet, the join table that is part of the subform is Emergency_Contact, the form where the information is held is in Emergency_ContactsINFO. Basically the alert doesn't trigger which means my if isn't working- and I don't know why. Another user has suggested that it is a zoho area. if (Emergency_ContactsINFO[ID == row.Emergency_Contact].count()
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
Form type icons in Form builder
Hi, Could you put the type of field that each field is into the form builder on the right hand side of each field (just put the icon if you want) so I can see at a glance what type of field I am looking at? It would be really helpful when I am making join tables
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?
Increase Column Width in Record Summary
I have a number of large text fields in a record summary and I can't see a way to increase the column width. My report comes out 3-4 pages long because the column is only 25ish text columns wide. How can I utilized the whole page? Thanks
Calculation of Values Through Mulitple Forms
Hi i have been banging my head over and over again for the last few days and i seem not to be getting anywhere, apart from building forms and hiding specific fields in deluge scripting thats as far as i have got. I have read that this is supposed to be easy and everytime i try to create an application i'm hitting the same wall and keep wanting to go elsewhere to create applications. I get replies for my posts saying if i need help then follow links to professional developers! hold on a minute if
Gmail Invite from Creator
Is there a way, based on input from a Creator Form to send an email invite to a gmail account for input in the gmail/google calendar upon saving the Creator Form? I have search and read the forum and support pages, but am confused. I was hoping someone could point me in the right direction or answer the question with some guidance. Thanks! PS And yes I've read this Topic - https://www.zoho.com/creator/help/script/create-event-in-google-calendar.html
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
Refer Fields link deprecated?
I logged in yesterday to my account to continue doing some app development work and I could no longer find the "Refer Fields" link on the top right corner of my free flow scripting window. I emailed support asking what happened to "my window" and here is there response: "The "Refer Fields" option in the free flow mode has been deprecated. The names of the forms and the fields would be auto populated when you start typing the script in the free flow mode." So I tried today to see what they meant by
Is Zohopublic down?
Dear All, Is there any problem with the zohopublic domain? Is it down?
Post to URL Xml Json $50 for solution
I have a formwith basic contact data - first name , last , address , age etc I need to post info after submitted to my db to external site as XML or JSON - I have tried everything all I get back for response is Bad data type errors . I got 50 bucks for who ever gives me a working solution - Instructions below- Our services follow RESTful standards fairly strictly. A successful api call is indicated by a http response code in the range: >= 200 and <= 299. Any other http response code is a failure.
Does anyone know where a non coder can learn deluge script? Deluge for Dummies
I just get so frustrated being dependent on developers to do everything for me in my apps. I have absolutely no idea of how one would go about learning deluge script. The platform that is made to teach just makes me feel totally stupid as I have no idea what I am doing. I can't get beyond the first 2 or 3 exercises and the ones I get right, I have no idea why they are right or wrong. There has to be a way to learn this supposedly easy language. Does anyone have any idea to share regarding this subject?
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.
Creator New pdf creation engine?
Hey, is there any info on what this New pdf creation engine for creator enhances? I'm most interested to hear if it allows for page breaks or page numbers? Thanks
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
Getting a list of the contents of a field for all rows of a subform
Hi, I want to make a field in the parent form which lists of the product names fields in all the rows of a subform So if someone has bought a TV which is one row, a stereo which is another row and a microwave which is another row the parent form's field would return "TV, Stereo, Microwave" How'd I do that - I can't think of a search that doesn't use the word 'list' which gives me the wrong sort of answer thanks
Test User can not access database
Hi, my secondary user can not access the creator database I have created. When it attempts to log in to the creator site and select the application the messages says you have logged in as vicandreuben@gmail.com. You are not allowed to access this application. But I have selected them in the user settings to be able to use it. When the user attempts to use the apps through Zoho CRM, which is how they will be using it when it is live, they can view the forms I have linked to, they can see the test
How to hide fields in subforms based on input in other fields in the same sub-form?
I use a subform in my mainform that contents a row with 4 fields. How can I hide some of these fields in the row based on the input added into this row-fields?
Insert an image (created QR Code) in to a form or report from a url
I currently use a formula to generate my QR codes in excel through goo.gl which is : =if(isblank( A4 ), "", image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="& A4 )) in the above code if A4 ( which is th item name or number or code or what ever) is blank then the cell with the QR code is blank. if there is text then a code is generated with that text. my question is can i set a field in a from or a Deluge task to display the same ? thanks
getting information for a Subform join table
Hi, I am trying to get a on user input script to copy information from a emergency contact form into the join table that is part of a subform. The master form is Call_Sheet, the join table that is part of the subform is Emergency_Contact, the form where the information is held is in Emergency_ContactsINFO. Basically the alert doesn't trigger which means my if isn't working- and I don't know why. if (Emergency_ContactsINFO[ID == row.Emergency_Contact].count() > 0) { emginfo = Emergency_ContactsINFO
Next Page