How to create a Form with a variable number of fields?
I want to create a form where the number of fields can be specified by the user. For example, I want a form to ask how many children I have. After telling the form I have 3 children, the form should present three fields to collect their names. Is this possible?
Dropdown values
Dear Coleagues, I am new user of ZOHO (just started today). May you share ideas how to make such thing. I have 2 forms: Customers and Products. In the third form "Problem report" I need to enter Customer name from Customer form (I used lookup) and Product name (I use dropdown). Product name dropdown list should contain products names which choosed customer has. May you explain how to do that? Thank you! Evaldas
Adding records using REST API gives error
When I make the following request I get error code 2899 response with the xml file. I have shared the application and have obtained a valid api key from the server. Any idea what the problem could be? <?xml version="1.0" encoding="UTF-8"?> <form method="POST" action="https://creator.zoho.com/api/xml/sensor-test/form/temp_and_time/record/add/"> <input type="hidden" name ="apikey" id="apikey" value="MY-API-KEY"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="text" name="humidity"
Wrapping in multiline
Hi I'm creating a form in zoho creator. I'm creating a multiline box that is shown only if a button is checked. I prepared a text that always has to be shown in the multiline box, like following: if ( input.test("yes") ) { show Info_test ; Info_test = "first line: ,second line" ; Now: how can I have a wrapping text in the multiline box ( Info_test),as this: first line: second line: ....: ....: Thanks
Make the result of a subform were in the same form a
I would like to make the result of a subform were in the same form as the application : Order management . I have the following codes, and it works, but I can not transfer it to the form. row.Total=(row.Piezas * row.Precio); itemtotal=0.0; for each Sub_Total in Articulos { if(Sub_Total.Total != null) { itemtotal=(itemtotal + Sub_Total.Total); } } Total=itemtotal; ------------------------- for each Item in Articulos { input.Precio = (input.Precio + row.Total); } Thanks!
Affilate program
Hello, Do you know how to organize and start affilate program in Zoho CRM? How can I do this in Zoho >>> https://www.youtube.com/watch?v=46lW5iLTI1U Thank you
Error in logo and footer
Hi, I published my website 2 days ago but the logo and the footer are not visible. Only code. I didn't change any code and simply used zoho's features to upload the logo and create a footer. I'm not any IT specialist so i would appreciate any help ... Thanks
Backup shared app(s)
I have certain apps shared to me in zoho creator. I would like to perform backups of the apps and try to export some of the data to a .CSV file, but unfortunately the backup app isn't available for apps shared to me. Any help would be appreciated.
Image field and File Upload field in stateless forms
Image field only takes image links in stateless form and we cannot create a file upload field in the stateless form.
Error Executing Workflow On User Input script
so i get this message when trying to convert from native price to euro in lookup to single field - Error Executing Workflow On User Input script Price (Euro). - Error occurred while executing the workflow. please contact support@zohocreator.com failing code: euprice = Price_Native_currency1 [ID == input.Price_Native_currency]; if (euprice != null) { EuValue = (euprice.Price_Native_currency.toLong() * 0.10836).round(1); input.Price_Euro = EuValue.toString(); } And if im not doing "if" then
Link auto number across forms
I want to use a lookup field to link two forms. One the first form I have an auto number field, as well as a single text field. I would like to use the text field as a lookup to another form, and to have the auto number auto populate on the second form in order to maintain data integrity. How would I get the auto number field to auto populate? Thanks
How to insert a chart in XPATH?
I need to add a Xpath code that be displayed as in the chart below where varibles replace values. Whether this is not possible, I would like to create graphics as it is in HTML or any format that supports Zoho to use variables such as values, and was told that was impossible, or use different forms within the same graph. <?xml version="1.0" encoding="UTF-8"?> <chart> <title>Población</title> <subtitle>Fuente: INE (2004)</subtitle> <name_value1>hab</name_value1> <type>bars</type> <header_height>80</header_height>
I Can't access my Zoho Recruit information to populate in Zoho Creator
Dear Support, Please could you verify what is wrong at my script? I'm following the instrutions on help but I can't have success. I include some alert to debug, but the end doesn't show anything for resp. I include some printscreen to help you to understand the sequence that I'm doing. Thanks. Paulo Miguel. script: moduleName = "Candidates"; condition = "(email|=|" + input.Email + ")"; fromIndex = 1; toIndex = 20; resp = zoho.recruit.searchRecords(moduleName, condition, fromIndex, toIndex);
How do I duplicate entries more than once?
Hi. I am trying to put together a raffle which gives the user the option to purchase more than one 'ticket'. What I would like to do is multiply the data entry based on the amount of tickets purchased e.g. if the user purchases 3 tickets, the form would automatically create another two entries. If anyone could help me with a way of doing this, it would be much appreciated. Thanks
How to do an "Or" param on an HTML View for a View Link
Hello. I'm trying to do a View criteria parameter that uses an "Or" condition. Here's what I currently have: <div viewlinkname="Orders" params="Entity=<%=Entity%>" elname="zc-component">><div> - which works correctly for providing a View that contains only the "Entity" name that I want. This is what I'd like it to do: <div viewlinkname="Orders" params="Entity=<%=Entity%>" OR "Added_User =<%zoho.loginuser%> elname="zc-component">><div> I'd like the view to give me all items for the correct Entity
Exporting schedule backups automaticly
Hi guys. I have scheduled a backup creation daily for one of my databases. I need a way to store that backup every day without having to go to the website and downloading it manually. Is there any way I can do that with CURL or using the API or something?
Pivot Charts work as a Creator USER but not a customer portal USER
Can someone explain why I get beautiful charts ( even if my form data is multi-select) as a Creator USER ... but when I access the Chart as a customer portal user - it just won't work? Seems to me that if I can create a chart and view it as the administrator - I ought to be able to make this available to my portal users - ( or am I being totally unreasonable?) Thanks in advance for your response, Craig
Calculating the number of days between a date field and the current date
Can someonce check my formula I am looking to count the number of days from the current date - back to a count field Here is my formula ((zoho.currentdate – Initial_Contact) / (1000 * 60 * 60 * 24)) Initial_Contact - is a date field entered by the user. I modified the formula found on this page - https://www.zoho.com/creator/help/fields/configuring-a-formula-field.html#Script_Actions Thanks in advance
Deluge, not easy?
Hi all, really looking forward to getting more into this product, its great so far! I am definitely struggling with scripting though. The help manual says the following "Should I have programming experience to code in Deluge? Definitely not. Zoho Creator/Deluge primarily addresses the needs of a large number of people who have a requirement for a web application but do not know to build it on their own. You need not be aware of Java, JSP, PHP, JavaScript, HTML or CSS. You just need to have a clear
Where are my apps
When logging into Creator I am presented with only a blenk screen of "shared apps". My apps are not shown. The apps still work via iphone app and URLs but I can not get to edit any of them. I am just gone live with the first app and now am completely stuck. HELP!
Maximum Authtokens
Is there a way to increase the amount of tokens for an account? I'm getting an error that the maximum amount has been exceeded. Zoho should take into account how many PAID for services per account are being utilized . I currently pay for CRM, Creator, Campaigns, Invoice and Projects. I also use Docs. Factor in the iphone / ipad apps plus the service to service integrations and you see quickly you need many more than 10. I need at least 10 for Creator alone. I'm at a standstill right now in Creator
Help with data fetching
Hi In my application, the user can add new clients while looking at existing clients. Currently I am having trouble with fetching client information from the same form. I've had a look at these links but I'm not really sure how to implement/use these to make them workable in my application https://www.zoho.com/creator/help/script/fetch-records.html https://www.zoho.com/creator/help/script/fetch-a-value.html Thanks :)
Record locking mechanism?
I'm making an application that is essentially going to be a community queue where users grab individual records and when make a decision for it. I need to make sure 2 users cannot open the same record at the same time. I'd like some kind of record locking mechanism that checks if someone else has a record open in which case the 2nd user would receive an error message saying the record is locked already. Is this possible? Has anyone done this before?
calculated forms values before submit
when I need suggestive value of the field ItemID is calculated based on the form values specified for the Model and Serial# I use this : on add { on validate { input.ItemID = input.Model + " " + input.Serial# it is work to add record, but I need see the value as suggest before submit, because I want to modify before submit Omar
How do I know that email is bounced?
Hi, how could I know using Zoho Creator that my email has failed? Have you any solution to know that some of send emails were bounced by email server?
Bug in getDayOfYear function
I have found an issue with the subject function. For my testing I have the following: The values are: input.Loan_Date = 12-16-2014 16:00:00 input.Claim_Date = 02-16-2015 and I have the following code. input.Number_of_Days = (input.Claim_Date.getDayOfYear() - input.Loan_Date.getDayOfYear()); The result: input.Number_of_Days = -303 I have run a few test data and it seems this bug occurs whenever the year are different. If it's the same year then the getDayOfYear function works Ok. Has someone encountered
How do I associate a Customer portal login with an account ID?
I want the database entry form accessed by the customer portal to pre-populate with an account number assigned to the customer logging in ... how do I do this?
Report View
I have my database set up and want to view it by item # in a report view. However, when I look at the report for each item, the rows are so spread apart that the report runs over to 3 pages. I want this to be single spaced so that everything fits on one page. Any idea how to do this?
Creator Icon Images are gone
Dear Zoho, Over the last couple of weeks something must have changed in your Creator backend infrastructure as the majority of the UI images are gone. Images like https://creator.zoho.com/platform/helpdesk/images/app/spacer.gif now report a 404 If I go to the Admin page in order to add technicians the following screen (see attachment) shows up, and it looks bad. Could you please fix this? Thanks, -Jaap
"sharing done with selected users"
I have 3 more opening for users yet I keep getting this message. When I send a invitation the recipient receives the following link and not a invitation. How do I fix this so the recipient receives second invitation below. Invitation # 1 Hi, Check out my ' US-CAT ' application in the below link. https://creator.zoho.com/inovacion/us-cat/login/zc_email=jcolburnus.cat@gmail.com Have a nice day! inovacion Invitation #2 Hello and welcome skutzkeus.cat Thank you for registering with Zoho Services.
Need help defining a reports criteriia
I have a form "Site_Directory" that contains information regarding customers sites - including the managers name, his email, the stores location and location name etc.. Using the customer portal - The manager logs in ( using his email address as a login) - and is presented with a form to enter asset data. Within this form, by using deluge script ( on load) - I can identify which store etc. he belongs to, which helps pre-populate the form called " Asset_Management" where data regarding the stores
Can you allow editing in a multi-text field in a stateless form but not delete previous input in that field?
I have two Forms - one is called New Request, and one is called Request Status (stateless form). Employees will fill out the New Request form when they are requesting something from the Purchasing department. The requests are then emailed to the appropriate Purchaser upon submission. I have placed an Auto Number field in the New Request form, and a corresponding "Request Number" number field in the Request Status form so that upon receiving the request via email, they can enter the Request number
URGENT! how to disable export entries for users?
hi need to disable export permissions for all users except account administrator how to make it
How to create a Customer Card?
hello, I'm new to the world zoho. I'm trying to create a database of clients, connecting multiple tables. I would like to create a page: 1) with a drop down menu where you can select the customer by Username; 2) extract, by query, all the necessary information about the client from the join of multiple tables ; 3) print to video information (i.e. photo, name, phone Number etc ...) Can someone help me? thanks a lot Giuseppe
Switch statments
HI I am in need of using Switch statement in deluge script for an application which i build. by switch i refer to this statement in PHP: $i switch $i { case 0: Do something case 1: Do something else } Is there such a statement in deluge? if not, can you add this functionality? Thank you Tal
How to fetch date data from completed form
Hi I am very new to this software, and would appreciate some advise I am building an application to log maintenance on a variety of hydraulic and mechanical equipment. I have created the forms, that include all required information fields, including the date that the work was completed. What I would like to do is have a field on the form, that will automatically fill with the date that the last maintenance was completed on. I think the fetch data is how I need to do this, but I am pretty lost trying
CSS HTML Image Holder Align
Hello, I have a CSS holder for an image but I cant align to the center I have the following script: CSS .holder { width: auto; display: inline-block; } .holder img { width: 30%; height: auto; } HTML output = output + "<div class='holder'>"; output = output + "<img src='IMAGE.jpg';/></div>";
Application Loss of Formatting
Me and several of my users have regularly been loading our creator app but instead get a format-less page. Has anyone else had this problem and know the fix? It happens with explorer, chrome and opera with several different user accounts and computers but never consistently. Sometime a refresh fixes it, sometime not.
Add a date restriction to a Zoho Creator date field?
Here's a quick video that describes my question. http://screencast.com/t/fb3oCO5JCHEc I want to add a restriction on the date field to not be able to choose a date unless it's three days into the future. Any assistance is appreciated!
Tooltip on Forms not working
OK - maybe it's me, but the Tooltip function is not working for me. Is there a secret trick?
Next Page