Returning BIGINTLIST from a function
I have a field in table A that is a multi-select lookup to table Y I want to convert the values in that field to a multi-select lookup to table Z and put them into a field in table B. Because this need happens several times, I'm trying to write a function to do this. I've written the function to return the result of the conversion. The function returns a value of type list. But when I try to assign the value returned by the function to the field in table B, the compiler says I need to have a value
Schedule in the database
Hello, Is it possible to add scheduling or aka email notification in Zoho Creator. Example if I wanted to create a database with action dates. When a date in the database is today send out an email automatically without having to log into zoho creator. Basically I need reminder emails when certain records with certain dates come up. Thanks. Iram
Function not returning correct value
I have a test function not returning the correct value. int temp.temp8(int digits) { powernum = 36.power(input.digits); return powernum; } When I input 4, I get 1679616. When I input 5, I get 6 but am expecting 60466176 When I input 6, I get 4 but am expecting 2176782336 What are the number size limits or is there a problem with the power function?
Shared Apps listing in Home page is not up-to-date.
Even after an application is not shared anymore with a user, the Shared Apps tab on the Home page continues to list it. -Varun Yagain.
Use subforms for multiple entry
I want to add the production tools of our customers to a database. So a database with machines linked to an account in Zoho CRM. I have one form (MachineEntry) where you can describe all the specifics of a machine (name/type/year). From another form (MultipleEntry) I want to add multiple machines at once by using MachineEntry as a subform. Both MachineEntry and MultipleEntry contain a ZohoCRM lookup. When you add a line from MultipleEntry in the MachineEntry subform, it automatically fills the
Marketplace issues
I can't get the demo to run without pre-loading it with records that I don't want to transfer in the install. When shared or made public the app works fine. As a demo it won't work. What exactly is the demo? Is it a copy of the app? Could my problems relate to certain code that doesn't copy well? I can't delete Screenshot images...only upload additional images. Removing the app from Marketplace doesn't clear anything. Any insights are welcome...please help.
Street address
Is there a way to set up a form to accept the following? Address: Apt/suite: City: State: Zip code: I would like to be able to validate that the address is a real address. Currently I'm using a text field but I occasionally get something other than addresses when users input to this field.
Set variable not working in the custom button of stateless form
User Name: kumar.n Application URL: https://creator.zoho.com/appbuilder/kumar.n/reportissue Access To Support: Granted -Neeraj
Email Data and field deluge name
I am trying to add a record by sending an email to the forms's email address. I am using a specific format to populate the fields. However, not all fields are populating. I have a field in the email called CallNo#. When i enter that into the field deluge Name field the system automatically replace the # with an underscore. I assume that i cannot use a # because on its use in URLs. Can somehow fields be mapped? I cannot change in the email field because they generated by a Commercial Computer Aided
Configure field actions - Zoho quick start guide error
Hi All, I'm new to Zoho and am following the quick start guide to build some sample apps and forms. I'm having trouble with an exercise in the Configure Field actions part (https://www.zoho.com/creator/help/getting-started/quick-start-guide.html#field_actions): While I'm trying to use the fetch deluge task to assign rec variable the value of the record to be fetched from the Product form, I use the expression: rec = Product[Product_Name == Input.Product]; Following all the instructions in the page,
Update records in Zoho forms - bug or error?
Hi, I'm trying to build a simple app that just adds points to students based on the type of networking events they attend. The following are the forms/reports used: 1. Students - list of student records with id, name and e-mail (and points accumulated) 2. Events - list of events with event_id, name and points 3. Event attendance - Form where I will select an event and enter student ID so that student gets the required points In the event attendance form, once I submit the form, I want the students
Subform: On Delete successful
I have a subform and it is very important to know when rows have been deleted from the subform. As a result, I have actions on the On Delete Row in my script There is a bug when user click the "X" to delete a row from the subform but do not click update on the main form because they change their minds. The actions on the "On Delete Row" still get performed even though the row was not successfully deleted. As a result, I am getting unnecessary notifications. If the row does not successfully get
Can This be done?
Hello all, I run a Heating firm in the north and need a database system to suit my needs but struggle to find any software or online databases. The only software i can find that suits my needs is from a company call commusoft. The software looks great but the costs are really to high to merit using it. So the question is can i make a zoho creator database with such fictions as customer details, postcode look up facilitys, Service reminders, appliance database and fault history? The website for
Fetch records from drop down
Dear all, I would like to fetch a record from a drop down field in the main form to a text field in the sub form. can you tell me how to do it? thank you, michael
User hits Submit button and goes to next page...?
Hello, I am new to Zoho Creator, and to scripting. I have created several pages of forms, and would like the user to click submit and go to the next form. How can I customize the Submit button for that to happen? Perhaps the bigger question is related to what I am doing. I am creating a database that tracks a Site, the Collections in a site, and then the Objects in the Collections at the Sites. I'd like the user to fill out the Site first, then tell me about the collections in the site, then the
Table pointing to itself
Am I right in thinking that you cannot have a field in a table that's a lookup to another field in the same table? I'm thinking of implementing a Glossary in Zoho and it would be nice to have 2 or 3 "see also" fields which users could click on to show other entries. A bit like a Wiki! (But I don't want to use Zoho Wiki .... just in case anyone was going to suggest that idea!) Alex
New App Builder: Set Filter on Lookup is not supporting a criteria based on another input field.
The editor basically just lies about succeeding to save but in the end, the criteria is not applied at all. I'm referring to criteria that include another input field e.g. SourceColumn == input.FilterValue -Varun.
Online Store login process
Building on your new feauture for payments, what is the best/suggested way to have customers login in order to be able to create an order. Note that I am using also Zohosites and I am trying to integrate everything into a decent online store application. I expect the customers to be able to browse my views with product details without loging in i.e. using public permalinks/frames. But when the customer wants to place an order then I need him/her to login in order to asign customer information
Login option based on database of registered users
Hello, I think I have read everything about login page which dated far to 2007. I wonder if any suggestions or changes been made so far? I am trying to figure out the way how to use the database form and allow users to enter their email (as username) and password ( as they chosen) to access a web page link. I believe it should be not as difficult, as database is there - form should recall and compare the data entered into fields to data in database and if correct send to web page. I think it should
Parts average price/cost
Dear all, I have a form to enter parts used with the cost/price and kilometer in another form, I would like to have a historical average price and kilometer off all a particular part the question is: 1. how can I pick only 1 part from many parts, get the prices, then make 1 average price. 2. I also want to have a historical average kilometer used, based on the kilometer when they change the part. for example. maybe they change a radiator at 1000 km. then another at 4000 km. then the difference is
Issue: Getting schedule to start based on subform variable
My application allows users to request invoices from our accounts department in the Client view by creating a record in an 'Invoice Info' subform. Currently once 'Update' is clicked in the main form, it determines whether a new entry has been made in the subforms (simple tally of records before and after the Update) and if there is a new record it sends an email to our Accounts Department with the relevant information on the client and invoice (from the sub and main forms). I am trying to extend
Problems with nested functions
In my script, under a previous working version I had the following code and it was fine Version 1.0 temp = thisapp.udf_history.get_field_changes(input.HIDDEN_FIELD_CHANGES, "POSTCODE", ps.POSTCODE.toString()); However, when I made changes to my script, I kept getting errors so I was forced to use Version 1.3 postcode_string = ps.POSTCODE.toString(); temp = thisapp.udf_history.get_field_changes(input.HIDDEN_FIELD_CHANGES, "POSTCODE",postcode_string); I think zoho creator has issues with nested functions.
Field actions and math error - Zoho quick start guide
I'm new to Zoho and am following the quick start guide to build some sample apps and forms. I'm having trouble with an exercise in the Configure Field actions part (https://www.zoho.com/creator/help/getting-started/quick-start-guide.html#field_actions): I'm getting an error in the app when I put the following: Revenue = input.Units_Sold * rec.unit_price; I tried with Revenue and input.Revenue The script is accepted without error, but when I run the app, the revenue field throws the error: error executing
User selection of what record to display on an embedded form
I have a simple requirement but can't figure out how to implement it. I want to display, within a page, a record from a table, and some values from associated records in other tables, I want the user to first make a selection from a drop-down to determine what record gets displayed. A simple example is: - User selects Client Name from a drop-down - The page then displays key information from the Client table for that client, and - Details of each Site that the client has, from the Sites table, and
link to ManageEngine
Is there a method to get data from ManageEngine? On my creator form I want to have a drop down of information that is stored in ManageEngine. Thanks Herb Wexler
Multiple versions of a record
Hi all, I have an application where the user fills out a form. Based on that form, an estimate/quote is generated. The process dictates that the user can go back and make changes and have the quote regenerated. I would like to be able to maintain a record of the last 5 quotes, but I can't figure out how to do this effectively as there doesn't seem to be a deluge function to copy a record. On a previous post, someone suggested passing the ID of the parent form and pre-filling a new record based
Add record in related list with deluge script
Hello, I have in contacts module a related list of products, it is possible to insert products in the related list of contacts by deluge script for example using zoho.crm.updateRecord (), how would the syntax. Thanks
Formatting single record view/report
I have a view/report created from a standard form. It can be set to show 1 record per page which is what I want. Unfortunately the formatting of the page is extremely primitive unless I am missing something. It only seems to show as a page split right down the middle with the labels on the left and the data on the right. Is there any way to adjust this, perhaps to move it all to the left side of the page? Perhaps to add a background colour or a Title? It does seem possible to un-click auto for
Unable to publish app on MarketPlace
I consistently get an error message that reads - "An error has occurred. It has been reported to Zoho Creator Support. We will look into the issue. Sorry for the inconvenience caused". -Varun.
Getting the ID of an inserted record
I'm inserting a record in Deluge using insert into Contracts [ Added_User = zoho.loginuser Engagement = input.ID Instigated_By = "Other" ] What is the best way to get the ID of the inserted record? I've tried changing the insert command to rec = insert into Contract [ .... etc. ] but that fails on saving I've also tried: rec = Contracts [ Engagement == input.ID] and for each rec in Contracts [ Engagement == input.ID] { } both of which don't return an ID. In the end, this seems to work: for each
Hide public section from authenticated users
Hi, I have an application that have a section that is displayed as public for let external users edit some records. It works wonderfully but when I enter with an authenticated user this section (that basically have public view from the views that auth users can access) are showed. I tried to restrict them for auth users using the control panel but the only option that is available there for public shared views is to make them private. I want to hide this 'public' section from authenticate users.
go to next url iframe issue
i have searched and cannot seem to find an answer to my issue so i hope someone can assist... i have four forms and wanted to go to the next after each is submitted. i set go to next form (form 2) in form 1 etc. when i embed that form as an iframe and submit the form it does not advance in the iframe. it says data submitted but the iframe stays on the same form. the only way i have made this work is to take the next forms, like form 2, embed that in a separate webpage and then on the form submission
View Records in View
I have built my first application with one view, added a number of fields, and also added 3 records. Within Zoho Creator the data looks fine. I then registered an API key and used the API sample to get a ticket. Then I tried to use the REST API > View records in View but I keep getting the following error: "An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused." I have tried to "Share" the application to myself but still
how to compare values or look values Using zoho creator
Hi I am a Master Dealer from different CELL PHONE companys. I have this situation: In my position I can not follow my activations per Resellers. My Master Agents only give me at spreed sheet of Activations serial numbers. But I dont know which reseller activate x -serial #. I want a data base of my Clients Resellers where I can assign serial # inactivated. Then when I received my excel activation report. I want to upload the excel activation report to my zoho data base and run a report that
GET request to view records not working
I'm using the free version of Zoho to try to get records but I keep getting the error : 'There is no such view in Zoho Creator' or 'an error has occured. It has been reported to Zoho support.' My GET looks a bit like this: https://creator.zoho.com/api/xml/UploadOfferForm/view/Sheet1_View?authtoken=********&scope=ZohoCreator/creatorapi&submit=View Records The view and application names are both correct as far as I can tell. (and I am re fetching the auth code at every requesty) Can I use this stuff
How to receive undelivered email notifications sent through SendMail Deluge script
If I send email using the SendMail function of Deluge script, is there a way to receive undelivered email notifications? Example: sendmail [ from:zoho.loginuserid to:bad_email_address@bad.com reply to:zoho.loginuserid subject:"Hello" message: "Hello" content type:HTML ] I want to receive the undelivered email notification at zoho.loginuserid.
HTML <input type="password" ....> equivalent possible?
Would any one know how to hide characters in the user input (say with an 'asterix' like in a password or a bank-account-number field) on any field? Many thanks. -Varun.
Username and password
So I have installed a zoho form on my Wordpress website using the plugin. The form requires a sign in using a zoho username and password. On a previous screen I collect user information in a Client form. Is there a way for me to collect a username and password from my clients and pass that to zoho so they can sign in on the next screen? Thanks.
Prevent Creator using https
Hi My app has been working for fine for years at the following URL https://creator.zoho.com/rsoftley/ast/view-perma/FINAL/ but now I've discovered Firefox and IE are causing massive problems with secure pages that mix secure and insecure content. Whenever I go to http://creator.zoho.com/rsoftley/ast/view-perma/FINAL/ it redirects to the https version - is there any way to stop that from happening or another way to fix my problem? Thanks Robert
change order of forms displayed in section Forms
Is it possible to change the order that my created forms appear in the Forms section ? Every form I create goes to the bottom of the list. Thanks
Next Page