Converting to a negative number
I'm working on a trial basis so please forgive me on the simplicity of my questions. I would like to convert the amount entered based on another field. So... If TYPE = "expense" I want the AMOUNT field to be negative or else positive Thatnk you
Position of OpenUrl Window
Hi, Is there any way to I can Open the popup Window (openUrl Task) in the Middle of Browser now it seems always opening in the upper left hand corner ? Arfater
Publish Deluge script on own server
Is it possible to host the deluge scripts on my own server? Oliver
Execute Zoho Creator App without credentials
Is it possible to publish a Zoho Creator App in such a way that it can be executed without the need to log in? I'd like to use Zoho Creator to develop an app for my website that all visitors can use. Thanks Oliver
New Field in Existing Form is not showing up!
Hi Can anyone help please? I'm new to Zoho and my husband created my database and forms, but I've added a new field to the form. When I want to create a relationship from another form to this new field, it doesn't show up in the field listings? Very strange considering I can see it in the Form and the reports too. Any ideas? Many thanks, Nicky
Who is the best partner in the south of the UK who really knows Creator?
I am considering a project that I think needs to involve creator so I would like to talk to somebody who really knows its capabilities
Subform field details in email
How do I include subform details in an email? When I create a record summary to attach to an email (using senmail function) to display details of both the form and subform, the subform fields appear to be empty. Please help!
Form Automation not working on script update of decision box!
I'm trying to dynamically limit the number of subform rows allowed based on number field in form. I have setup form automation to hideAddEntry in subform on a decision box. This works when I manually click on the decision box. However when I use scripting to update the decision box, form automation does not work. Is this default behavior? Damien Cregan Hire an Expert
HTML image view issue
Good day I have an HTML output where I need to display a image for a signature, I already have the link for the signature but when I display with the HTML img src I can't show correctly. for each x in FetchRegistro { link = x.Firma_Url; LinkFirma = "<img src='" + link + "' alt = 'test' height='30%'/>"; output = output + "<tr class='rowVal'><td>" + LinkFirma + "</td></tr>"; } If I replace link with a sample value of the Firma_Url it works LinkFirma = "<img src=" + "https://creator.zoho.com/czambrano1/recursohumano/Firma_Diaria_Report/2357982000002871223/Firma/image-download/1426707525078_signature.png"
Currency cannot handle commas
Hi. Extreme newbie here- Made forms for a client and LOVE using Zoho creator but having a hard time finding a fix for one issue: Have a field set to "currency" specifically "USD" , but if someone types in 100,000-- the form will not take the comma at all. Since this is for real estate, we will be dealing with larger amounts. Is there any way to have a number field, specifically currency, that will handle commas? Thanks
Wrong Language Dates
Good day, I setup my application in Spanish and in settings I set the following date format (spanish tag) The problem is that in my reports date appear in English (all the app is in Spanish), I already check if there is any wrong translation but everything is Ok,
Using "Fetch" In Script Builder
Zoho wrote this script for me to Fetch information from one form and pull it into another form. rec = Freight_Schedule[ID == input.Freight_Schedule]; Invoice_1=rec.Invoice_Number; Invoice_2=rec.Invoice_2.toLong(); I tried to add to the script using the "Script Builder" and I came up with this script but it doesn't work. rec = Freight_Schedule[Carrier = rec.Carrier]; I tried to changing it to Carrier = rec.Carrier; but it still doesn't work. I'm using "Workflow" "Field Action" "On User Input" Any
Creating a group and sub-items
I would like to create a form that will allow me to enter a group, and then enter items in that group, which individually also have their own attributes. Each group can have one ore more items. What's the best way of doing this inside one form?
Want to make a public form
Why cant i make the form i made public? It will only allow me access to private sharing. I'm not sure what to do.
Using formula data to create another formula
Hi.. thanks for reading and hopefully pointing me in the correct direction. I have a simple formula with a field name of "Actual Buy Price $" The fields include: Regular Buy Price and Discount The expression: (Regular_Buy_Price - Discount) This works fine and as intended. What is needed now is a conversion inserted into a different field named "Actual Buy Price ₱" based on the result that is displayed in the field "Actual Buy Price $". Basically I need to multiply the result from expression (Regular_Buy_Price
BUG: "Users" type field cannot be referenced
Hello, It seems "Users" type field sometimes can and other times cannot be referenced. My app contains a form called Users, having one field of being type "Users" and named Username 1/ "User" type field cannot be used in list The code below create error UsersList_SelfLookup = Users[Organization == LoginUser.Organization].distinct( Username); UsersList_SelfLookup.sort(true); Trips_Approver:ui.add(UsersList_SelfLookup); 2/ "User" type field can be used while fetching record "On User Input" but
Passing values in the URL
I've done this before in PHP but just can't seem to work out how to do it in Deluge. I have a form called FormA. It contains a field called ID_name. When submitted, I want this form to send the user to another form called FormB, with the value of ID_name written into the URL. THAT MUCH I can do. It's working fine. I use a questionmark between the URL and the ID-name value. However, I now need the second form to read this value (ie what follows after the question mark) and to use this as input
Calculating Grand total from subform subtotals
Hi, Ive created a form that calculates the grand total. This grand total adds the values for each new row in a subform. Here is the code ive been using Quantity_Ordered on user input: row.Subtotal1=(row.Quantity_Ordered * row.Unit_Price); Total_Due=0.0; for each item in Items_Ordered { Total_Due=(input.Total_Due + item.Subtotal1); } I keep getting an error message Error details: Error in executing On User Input script of the field, Quantity Ordered Error Error in executing For Each
URGENT! error when buy add-on
hi try to buy +500 schedules there is error. please solve.
more than 5 records per page for mobile applications
Hi, is there a way to show more than 5 records per page in a summary view when oppened in a mobile device? I saw a post about this with a negative answer but that was a few years ago. Perhaps something can be done now? Mobile usage is key these days. another question, the "next" page button shows in the header of the view. Is it possible for it to show also at the bottom? Thanks Luis
Unique requirement from client to create a product module
Dear Anbu, I have a unique Requirement from my client. Client is Using EE CRM and we can't customize the Product module so I want to go with Creator and please give me some suggestion related to this Unique Requirement. I have attached the screen shoot for your consideration and When i click on the add product in CRM..Frist screen shoot.I need to get all the products with line items(product name,Product code,Product family,Category,Ad sizes/Special Ops,Position, Currency) when we select the products
Populate subform from unsaved parent form
Hello, I'm getting my feet wet with Zoho creator. I want to create a rudimentary parts management system that will have records for manufacture, testing, orders, RMA, etc. I am trying to create a form for orders, consisting of a PO#, date, and customer (which is a lookup from the customer form). I have an order item subform that includes PO lookup from the parent form, a lookup for the item part number from the 'item' form, and quantity. The problem is, the PO# can't be looked up until the parent
errors running zoho creator native app on iphone6
We have written an app that required users offsite to use, and therefore need to implement a robust mobile platform. Problem so far is we are having different errors appear over various platforms. Is there a known issue with the zoho creator native app running on iphone vs android vs mobile browser ? Also, what is the most reliable mobile browser to use on either apple/android if we wanted to run the application via mobile browser rather than the zoho app ? Getting very frustrated with inconsistencies
hide print option
Hi, I am trying to hide print option in the view. I was trying with below code but it seems it is not working <div elname="zc-component" viewlinkname="MVPD_Channel_Form_Report" params="zc_Header=true&zc_AddRec=false&zc_EditRec=true&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Print=true&zc_Export=true">Loading View...</div>< See below output result: Can anyone please help me Arfater
HTML Close Table Borders
Good day could you please tell me how do I close the borders for this table, (bottom and right border) HTML output = output + "<table class='tableSize' align='center' frame='border'><tr><td style='width:20%;vertical-align: top;'>"; output = output + "<table border='1' align='center' cellspacing='0' style='border-color:#EEE;width:95%;margin:0px 0px 0px 0px' id='billingAdd'>"; output = output + "<td class='rowHead'>Consecutivo</td><td class='rowVal'>" + AvanceDiario.Auto_IDStr + "</td></tr>"; output
REST API Response
Hi I got the following response from REST API call. var zohochandrasekhar.kview54 = {"Welcome":[{"ID":"1205836000000077129","Image_Url":"https://pbs.twimg.com/profile_images/459764305567576064/ILQOFcfh.png"}]}; Can you please let me know why the string "var zohochandrasekhar.kview54" is added before the JSON response. Thank you
Zoho.userloginid to variable
I have an application that gives our clients access to complete questionnaires. Since I want them to have access only to their records, I setup views that display records according to the zoho.loginuserid. The views work fine, however the html pages typically display an error on the first attempt, then after refreshing the browser, it works. The same happens when trying to print the page...first attempt gives an error, then second attempt works. The only thing that may make a difference is that
Open Form with Lookup Value as a Parameter
Hello - I'm working on solution that will send email notifications on a scheduled basis to customers to fill out a survey via a link to a Zoho creator form. The survey form data needs to be related back to the customer form, so I've placed a lookup field on the survey form to accomplish this. I need a way to include the customer ID (the value of the lookup field) in the link so that the survey form can be related to the customer without prompting for that information. Using the standard "?customer_lookup=000000000"
Deluge script to new entry to a sub form
I want my subform to auto-populate with data when a option from a dropdown in the mainform has been selected. For instance, if "Jack" is selected from the dropdown and he has 3 kids, I want the subform to replace all the existing entries in the subform with 3 entries for his children. If "Mary" is selected from the dropdown and she has 5 kids, I want the subform to remove the existing entries in the subform and add 5 that are populated with info about her kids. I found many similar posts, but I couldn't
When will normal creator apps be able to carry over to Mobile Creator?
I'm excited to see syncing between normal creator and mcreator. Any idea when this will happen?
zoho.loginuserid in criteria
list Team_Events { displayname = "Team Events" show all rows from events [team == members[email == zoho.loginuserid].team] ( ... ) } team == members[email == zoho.loginuserid].team returns the correct BIGINT. If I set team to that number statically, it filters the correct data. Why then does this not work?
overriding report permissions
If I set the permissions for a report to allow add, edit & delete the following code in an openurl will cancel these options. "/view-perma/Board_Minutes?zc_EditRec=false&zc_AddRec=false&zc_DelRec=false" However if I set the permissions to NOT allow add, edit & delete the following does not allow these features. "/view-perma/Board_Minutes?zc_EditRec=true&zc_AddRec=true&zc_DelRec=true" Is this the way it should work or do I have a problem with my syntax. Note this is for a Customer Portal user.
Indicate that a field is different than a previous record
I have a flat database and associated form where, among other data, the user fills out his address. I also have a question as to whether the person's address changed since their last entry. Frustratingly, my users can't figure out how to fill out the "has your address changed" question accurately. I would like to add a hidden admin field that I can include in a report view that looks at the address the person enters, compares it to all the previous records, to see if the address was there previously.
Pictures
Hi there Is there a possibility to download several pictures uploaded by our countries at one or do I need to download every single picture of every clipping? Thanks for info! Samira
Digit Grouping for Zoho number fields
we'd like to see digit grouping feature for Zoho fields like Numbers, Decimals and currency. We have an application that generates bills and printed on invoice, but ZOho currency fields are not able to display digit grouping for the values. eg: we'd like a feature that would make USD 8346073.66 appear like: USD 8,346,073.66 Any help will be appreciated
Using checkbox as workflow automation
Hi, I am using a checkbox as a means to automate the process. As of now, I have 7 different selections in the checkbox. Each will have its own email sent out after it has been marked as checked. As of now, I am using IF statements to attempt this but i get an improper statement error. For example, the 7 checkbox choices are: (1) Awaiting Approval (2) Approved/Denied (3) PO placed (4) PO confirmed (5) Receipt received (6) Shipment received (7) Payment issued If I want to send an email after "(1)
Is't possible to move Form to another app
It will be very useful to have ability to move form and all assosiated views to another app. Now I have 4 app, which are full of different data, and they are using all, but sometimes it's nessesary to change architectury of whole application and I need to move some forms from one app to another. By hand it's very difficult to do. I understand that there may be some problems with openUrl function, which are using "#Form:.." or "#View:" navigation, but may be you can do something. I think it's possible
Area greyed out after selection
Do you have any suggestions on a form, that a area is greyed out after selection? The greyed area cannot be selected again.
How to NOT display "null" in empty fields
I have a form called "New Request" and a stateless form called "Update Request Status". In Update Request Status, I have a field called "Task Pending Notes" - here, the user will fill in the notes and upon submission, this will save the notes into "Task Pending Notes" in New Request, along with a timestamp. This happens every time new notes are submitted, and they are saved, collectively with each note and timestamp in "Task Pending Notes" in New Request. This is also auto-populated into Update Request
Sendmail - Email sent to multiple persons
Hi, I have used similar code on a related form and it worked, but it doesn't seem to be working here. So, what I want to do is say, there are two email address fields - one is called Email Address, the 2nd is Email to CC. I want the form to send out a certain email and cc the 2nd email address IF IT IS NOT NULL. This is what I have: if (((input.Task_Completed.toString() == "Completed") && (input.Request_Type == "Create new SKU")) && (input.Email_to_CC == "")) { sendmail (
Next Page