Script to create a new record with a subform, and populate data
Consider this example So what would be the code to create a new record? insert into Class [ date_field = zoho.currenttime (?) insert into Student [ name = "Billy Bob" ] insert into Student [ name = "Jane" Doe" ] ];
restrict characters in single line field?
Is there a way to prevent users from using, for example, spaces in a single line field? If not, is there a way to replace spaces with, for example, underscores during the submission process? Thanks.
Looking for a Developer or Programer
Hi I have running a Mobile phone Retail and service Bussiness. and i need a programer to design or create a online SaaS program for my bussiness. first this software has to log at least 10 users in same time and it has to install on our domain ( windows server dedicated and SSL certificate) it should have following modules. Sales-Sales return. Multi Currency accept- Split payment Purchase - we do direct purchase only. so we need to enter directly purchase invoice. items has to enter by category
remove 'home' link on non-admin acct
Can I remove the 'home' link at the upper right of a form for a non-admin account? Thanks.
Need help
Hi Ayisha How write the RegExp code in the matches () function to determine whether A string in the capital to capitalize A to Z？ like this ？ if(input.string.matches("(?([A-Z])")) == true) but try many time is failure... Thanks Stanley Guo
How to attach pdf document of record in Email templete to send these attachment on a custom action in zoho creator ?
How to attach pdf document of record in Email templete to send these attachment on a custom action in zoho creator
Doy you plan to make function calling in filter criteria of Views
Hello! It will be great to have this functionallity to have ability to use functions in filters criteria of Views (in Advanced Mode) For example, now, I have such a task: Our company have many business Partners (Form). Each business partner have several zoho accounts (each account represent some role in our application). Some Forms contain lookup field (linked to Partner Form). I need to have ability to filter Views, when Partner logged in this way: View: criteria field: where partner==thisapp.to_which_partner_belongs_logged_user(zoho.loginuserid)
Make each user only be able to view records that apply to them.
I have a form that customers fill out and Users/Sales Reps will have access to the records. What I want to accomplish is for each User to only be able to view the records that apply to them. I have chosen a User ID field to be the identifier/filter for this, but I'm not sure if this is the best way to do it. Also, I'm not sure how to set it up on the backend. Would there be custom DS involved in this? Any help on this would be much appreciated. Thank you, Mike
I can't edit my application
Hi, The app I'm trying to edit is https://creator.zoho.com/zohocreator/cobe123/zc-tutorials-15-0. It was working fine yesterday and all of a sudden, I can't edit it anymore. It gives me a blank page. Someone please help. Thanks
link does not load and application is restarted
Hi all! I am trying to develop an application for data collection for a master thesis. I have a form where people have to encode some words according to a rule in a certain amount of time. After they submit their answer they press Finish and should get to a form that would show them their score. I built an HTML view that loads 2 Zoho forms, one with the encoding algorithm and one with the exercises. Since I couldn't built a timer in Zoho, I had one built and stored at a certain web address. All Zoho
Please help me solve this GENERATEJS_TASK task error
I am trying to fetch a record and update a stateless form with the results. I have been getting a cascade of errors; Error in executing On Add-On Load script; Error; Error in executing IF rule: Error in executing If block; Error in executing For Each Record task; and finally Error in executing GENERATEJS_TASK task. The section of the script that is causing the error looks like this; if (input.Email1 != null) { for each myPhys in X_Physical_Profile [Email1 == "xyz@gmail.com"] //hardcoded the
Tooltips on buttons in new editor not saving with FF or Chrome
Here's a video demonstrating the problem in Firefox 20.0.1. The same problem exists with Chrome 26.0.1410.64 m Thanks, Jeff
Please help a newbie
Hi, I'm trying to create an extremely simple registration form to embed within my moonfruit created website. I need to capture basic name email which is fine, but I also need to get people to select from a pre populated list of schools. As there are over 16,000 in the UK I need people to be able to to first click on their county. This will then bring up only schools which are within that county. Can someone tell me how to do this?
show action in view header
I recall a discussion of always showing custom actions on top of the view for actions that are not record specific. Currently they only show if the user clicks on a record. Since the action is not record specific the user has no reason to select a record. Is this on the roadmap? Herb Wexler
Has the validation on eMail field Changed ?
My users have been successfully using my applicaiton for over a year, but last week, an error message started to be displayed : Enter a Valid Email address.... The address it doesn't like has an apostorphe in it (example john.o'reilly@domain.co.uk) An apostorphe is a valid character (if it occurs in the name, prior to the '@' symbol) Please advise if the checking routine has changed, as this worked and has worked for one year ! Thanks Neil
URGENT! Filter on lookup field not working!
Hi, I use filters on lookup fields as follows: Lookup A = Company Names Lookup B = Items by Company (filtered by company name) Lookup C = Item type (filtered by selected item) I was able to add the filter to Lookup B without any issues, but no matter what, as soon as I move to another field and come back to Lookup C, the filter I add disappears. Please Help!
Purposely update only the first in a collection of records
I'm trying to build a simple inventory management of printer resources for my school. One table contains the Inventory of our printer cartridges; each individual cartridge has its own record - so, for example, there are three records, one for each of the three Q1234 cartridges in stock. I want to be able to update only one of those records - when a patron "checks out" one cartridge of that model, the records matching that cartridge number are fetched (multiple records), but only the first of those
how get linkSubViewCompId
Hi I want to open a summary view when click Decision box,I saw your system sample code as bellow: https://creator.baihui.com/lg8888b/jk/record-summary/view1/72686000000012866/ZC_REC_ID=72686000000012866&linkSubViewCompId=72686000000081256&linkedViewAppLinkName=jk&linkedViewLinkName=view10&isSubFormLink=false but I don't know how get the "linkSubViewCompId=72686000000081256"? if know can I open the summary view? Hope your help Thanks Stanley Guo
Purposely update only the first in a collection of records
I'm trying to build a simple inventory management of printer resources for my school. One table contains the Inventory of our printer cartridges; each individual cartridge has its own record - so, for example, there are three records, one for each of the three Q1234 cartridges in stock. I want to be able to update only one of those records - when a patron "checks out" one cartridge of that model, the records matching that cartridge number are fetched (multiple records), but only the first of those
How do I check if an input field is visible?
Hi, I'm trying to using Deluge script to evaluate whether a field is visible or not, but not sure of the syntax. Is it something like input.Field.visible = true? I basically want to write, "If field_x is visible, do this; if field_x is invisible, do this." Any help is appreciated. Thanks.
Error while getting values to a dropdown from Reports table through api call.......
Hello I have a problem in fetching data from reports in dropdownfield in a stateless form , i m getting this error ("unable in executing set variable task and error evaluating string expression ,invalid xml/json format") i have attached the same code below <with wrong password and username and api> // Gets the authentication for your account. ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=123456&PASSWORD=abcd")); ticket = (ticketDetails.toString()).subString(((ticketDetails).indexOf("TICKET=")
CATASTROPHIC FAILURE - All script dropped from my Form and not present in Version or Trash. It.Just.Disappeared.
Planning to demo to my manager tomorrow as a means to sell the product into the company as a viable enterprise-level product. I am currently on evaluation and have built an app to automate some of my teams more arduous tasks. Making some finishing touches to roughly 2 weeks worth of work, when I access the application and none of the scripting appears to be functioning. Back into Script Builder and Zoho has dropped ALL code from one of my forms. That's several days worth of work in validation and
REST API - List Applications
Hi guys, I tried to follow this: http://www.zoho.com/creator/help/api/rest-api/rest-api-list-applications.html In here: <form method="POST" action="https://creator.zoho.com/api/xml/applications/limit=20"><input type="hidden" name ="authtoken" value="************"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="submit" value="List applications"> </form> How can I make this get/post request? I tried variations of: requestMap = map(); requestMap.put("authtoken", "valid authtoken ************");
Unable to save notes field with new App Builder
I switched to the new Creator interface - wow! I really like it! I think I've encountered a bug with notes fields. After I add it to the form, then edit the properties by adding text into the notes area, the "Done" button doesn't do anything. Thanks, Jeff
Auto number generate based on lookup/customer type
I've added an auto number generator to my form based on http://kbase.creator.zoho.com/application/auto-increment-field-values. However I need to go a step further as the job number that will be generated in my app need to be based on which franchise the customer belongs to, so I've renamed and duplicated the 'MaxValueHolder' form/view so that 'fr1valueholder' starts numbering at 1000, 'fr2valueholder' starts number at 2000, etc. My confusion is how to implement changes to the validate script(s) to
Doc link not loading in Creator
Team, This seems to be an ongoing issue. When linking a Zoho Doc link in creator the file does not show. Several blogs over the years attest to that bug. I was hoping that with the new DOCS 3.0 upgrade, this bug was addressed. I'm not an expert in Creator but I can't make a Zoho doc doc file link download. I placed a blog with the DOC team hoping a team approach could fix this bug Team, You have done a great job upgrading this platform. I have been testing for the last few days and most features
sendmail - sending a email coded as HTML
How do I sendmail as HTML code rather than just plain text, I have added my HTML code, script just rejects it DC
how to itterate through items of a multiple select list on related form? help me understand for each with lists
I have a Child form, with fields Last_Name and first_Name Parent form has from called Children which is a multiple select list .. picklist to Child form In Data form, drop down field to select Parent, and a Notes form called listOfChildren to display list of Student names. listOfChildren = myParent.Children gives me a list of Child ID's like 12234233, 1231342 I need the children's names John Smith, Jane Smith (given that John is First_Name and Smith is Last_Name
zoho.loginuser to show full name instead of username
Hi, Can the command zoho.loginuser show full name instead of username. I have several field which i want to default to the user that can then be changed to other users (full name) that are in our system. We are using our system internally so the users will be set up by an admin therefore there wont be users accounts that doesn't match our list. Thank you in advance!
An If statement based on the difference between 2 fields.
How would i go about writing an if statement to says if (x is +/- 1 or more of y) { Do this action } else {}
Upload files to Writer.
We know that Creator is not integrated with Writer,Sheet,Show, so if I want to upload files to Writer via Creator Upload field and Writer API, how should I do then ?
Line numbers are wrong in HTML view error messages
Hi Zoho, I want to alert you to an issue with the error messages for HTML views. The line number reported in the stack trace is incorrect. It seems to reset every time I break up deluge script with an %> It makes it very difficult to debug code in HTML views.
User Input with digits and letters?
Hello, i have this code: if (!(input.Galileo.toString().matches("^\d{3,4}$"))) { alert "Office ID Galileo should be between 3 and 4"; // cancel submit; } but it only work with numbers, how can i get him with letters and numbers? regards Carsten
Need help with a very long form
Hello We are creating a form to be able to capture all the educational history of a few children we take care of, but the form is getting to long and hard to complete. Is there a way for us to create different forms to update the same table and the forms should be launching one after the last one is complete. For example we have inside the form the following sections: General information, Parents information, Education, Psychology results, Etc. Can we separate all this forms and at the end be able
zoho calender events created in zoho creator
so using zoho.calendar.createEvent to create events, but what if I need application to be able to modify or delete events? is this updated? https://www.zoho.com/creator/help/script/create-an-event-in-zoho-calendar.html
I dont understand or fail to cURL to postUrl
Hi, I have this [PayPal] example of cURL: curl https://api.sandbox.paypal.com/v1/oauth2/token \ -H "Accept: application/json" \ -H "Accept-Language: en_US" \ -u "EOJ2S-Z6OoN_le_KS1d75wsZ6y0SFdVsY9183IvxFyZp:EClusMEUk8e9ihI7ZdVLF5cZ6y0SFdVsY9183IvxFyZp" \ -d "grant_type=client_credentials" I want to use postUrl and did the following: headersMap = map(); headersMap.put("Accept-Language", "en_US"); headersMap.put("Accept", "application/json"); detailsString = "grant_type=client_credentials"; responseMap
Script New Views ?
Can we script a way to create new views when we add record or contact. As I add new customers I would like to have their view and share set automatically . Form A has data in column x is customers name. I am currently making all customers zoho users but I only allow them to view and edit records that pertain to them . When I add new customer in Form B is there a way to automatically create their personal view and add them as a user or do I need to do that manually every time . I have 125 to add
The new application builder is missing the Payment option
Hi, I couldn't see this functionality http://www.zoho.com/creator/help/forms/accept-payments-through-forms.html#Creating_a_Payment_Form available when using the new builder. Where is it located please? Cheers,
How to display images in HTML views?
Hi there! I am creating a list of items with images. The "summary" view is inadequate, so I am working on creating an HTML view that will nicely list the image and a few other fields for each entry. How would you go about displaying images within HTML? Here is my HTML/Deluge code: htmlpage testpage() <%{%> <%totrec = Illustrations.count(); for each r in Illustrations {%> <%=r.Name%> <%=r.Image%><br/> <%} }%> Resulting in displaying the content of the "name" field correctly but
ZC app new builder interface
Hey, I couldn't find any public discussion on this matter. Please leave your comments here or re-link it to the older thread if exists. My first comment is that I find it too difficult to pop over between my forms and views. e.g. I have about 40 views and 25 forms. With the current builder I really need to -left-click twice. click on "views" or "form" and click on the element im after. With the new builder I either need to scroll down the list [limited] or do a search and click. Much more tedious.
Next Page