Apps & Adds-ons zoho app build custom apps
I have a Zoho Crm user.we use built custom field to make a new tab and new form but face a problem in send email field. after send a one or two mail its fields dont get response.please tell me the solution of this why its not responding after send a one/two mail?
Conditional field problem with Excel import
Hi Everyone, I have got a problem developing my application... In a form I have a first field to fill in : "ID appareil de mesure". If the value filled in is 0, some others fields take automatic values (Script in the first screen shot) : Bâtiments/Pièces, Surface en m2, Nombre d'employés, Données mesurées (In french, sorry but whatever) It works properly when I fill in the form manually but when I want to import data from excel, fields with automatic value remain empty (Second screen shot)... Is
Multiplication Problem??
Hello, I am working on a formula that is giving me trouble. I have been successful until I ask it to multiply based on a condition (highlighted)... any ideas?? (Staff_Requirement / 2 + if((Living_Situation == "Community"),1,0) + if((Intensive_Family_Involvement == "Yes"),2,0) + if((Split_Shifts == "Yes"),2,0) + if((Payee == "Yes"),1,0) + if((BSP == "Yes"),1,0) + if((Monthly_Medical == "2 or Less"),1,0) + if((Monthly_Medical == "3 to 4"),2,0) + if((Monthly_Medical
Help
I am new to Zoho Creator and I am having problems learning the scripting, is there any help with actually building the database.
Callback URL for Clickatell SMS API - Please Help
Zoho Staff/Developers, I have a few questions regarding the Clickatell SMS API the Zoho Blog were pushing a few years back. I have a two-way HTTP API set up (not the SMTP API as was detailed in that post, which doesn't allow for two-way as far as I know) with them and am I little disappointed at the ultra-lame incoming SMS reports that they have as the basic option and would like the SMS responses to be delivered into a form in Zoho Creator. I'll start with a few screenshots detailing where I'm
Why Import Data link is hide to shared users?
I would like to give permission to shared user to import data into one specific view. What I have done are: 1. In share Tab, the specific view (and form) are shared to one user. 2. In the view configuration, the permission to the specific view has been set to "create,edit,delete allowed". But still the user could not see the "import data" link under his "more actions". Is this functionality supported? If yes, how to set the permission properly. Thanks, Gino
Attachment not sent with Schedule for email
I have "email attachment" enabled in a schedule... but the attachment files are not sent. I have opened access to Support for this form: https://creator.zoho.com/lifengwu/moviesvillecom/#View:documents_View
reporting limitation with multi select lookups
Hello Is there a way that someone has sensibly worked around the above limitation an can offer some advice. I can't see I can avoid the lookup requirement and so that really needs to stay. At the moment I'm exporting out to excel but I'd rather just keep it in the app. Cheers Simon
Passing a set of values to a Parameter E.g. #View:SomeView?ParamID IN {1, 2, 3, 4}
In my application, I need to show a view of records which are determined at run time i.e. my logic identifies a variable number of records (code in an HTML View) and I need to display an embedded list view where I want to be able say that ParamID can have any one values from a set i.e. {1, 2, 3, 4} as an example. I have gone through https://help.creator.zoho.com/Functionality-based-URLs.html and I am unable to find any set operator like "IN" when passing parameter values. The functionality that
Exception reports for Zoho Creator
I'd like to receive a daily exceptions report for Zoho Creator. For example, I have a custom schedule executing every a few times a day. Once the monthly quota was exceeded, and only a few days later did I discover that the schedule had been stopped because the monthly quota had been exceeded. So I had to pay extra to upgrade the # of schedule executions per month, to fix the problem. I would like timely notifications by email of such incidences.
Change column/label width into Zoho Creator
Hi everyone, I attach a screen shot that explains clearly what I want. I want to resize the column of form's label into Zoho Creator. I looked for how to do but I found nothing. How is it possible ? Thanks ! Regards,
Can a field auto populate in a secondary form from a primary form?
I have form1 (aka: proposals) which collects... project number customer name sales rep & more... form2 (aka: orders) needs to have some of the same fields auto-populate when an existing project number is selected from a look-up... customer name sales rep IN SHORT: What script or how else can a field auto-populate the 'customer name field' of form2 with the existing data in the 'customer name field' of form1? Nathan
How do I validate an entry on my form?
I am fairly ignorant at deluge scripting or any coding for that matter; however, if someone would help me get the correct syntax for my field, I would be very grateful. The field is called Your_Company_Code. I want to be able to limit the entries in this field to values that I specify in the formula. In the formula below, these values are "OK0609" and "AU1325". Unfortunately, when I tried out my form, it did not allow any value at all. What should my formula look like? ((input.Your_Company_Code
Search across multiple forms?
I have 4 forms, in one application. Theses 4 forms all have records in them. I want to be able to search (say by last name) across all the forms, and for the results to pull up that record and tell me what form they are from. any ideas/
Registration mass send email to members
Hi I just startet using creator. I have created a table with all our members name and email addresses. Are there any smart way via creator that I can send a mail to these members?
How can i do a Report using two tables?
Hi everyone, I need to do a report with data that is content in two tables, i use work orders table, in this table i save the datas like date of application, date of creation, customer , contact and observations, then i have another table called Work Order Services, in this table i save all detail about work orders. Now i need to generate a repor using those tables. Thank's for your help. Regards,
Field Change Question
HI need some help! I have a field (Category) that is a drop down box with category names. (Kitchen, Bedroom, Garage, Garden) I have a hidden number field (Category_Code) which has category codes (001, 002, 003, 004) I would like the hidden field to be updated with the correct code based on the choice selected in the drop down category name box. So choose bedroom and category code will = 002 Can this be done with script? Martin
Sub forms
Hi can you help. I currently have to click add on the sub form and add the details manually. I already know when I want the sub form entry to be based on other criteria. Say I have 2 fields in the sub form. What script can I use on a field action in my main form to automatically click the "Add" on the sub form then fill in the 2 fields for me. Thanks Nigel
Unable to view subform data (Link is not showing up on the form view)
Hi, I have embedded multiple subforms on a form and for some reason I am not seeing the link to to view subform data on the Main form's view. Please see attachment for details. Thanks!
Unable to see subform data when link is clicked
Hi, I have embedded multiple subforms on a single main form. When I go to the main form's view mode and click on the link to subform, the subform information does not show up. Please see attachment for details. Can you check what went wrong here? Thanks! Vishal
calculate age based on two date
Hi, I have 2 entry Entry A = Date Entry B = Date How can I calculate age from these two entries (Age = Entry B - Entry A) Thanks
Freeze header row
Hi Zoho I'm pleased to see the header row is now frozen, however, the column headers don't align with the text once you get onto the next page. The header row stays in place but the text becomes compacted and, so, moves left. Can you do anything about this ? Thanks Paul
How to open a creator account without opening Google account login - Google Chrome
I have the following problem: I have 2 Creator accounts One is linked to the Google credentials. When I try to open creator on the second account I always (in Chrome) get directed to login to my Google Account. So instead of going straight to my second account, I have to fiddle around, closing the browser, start up on a new ... Of course it has to do with the cookies, but how do I avoid this - even opening it in the "Incognito" window does not help me. Any clues what to do? Poul
If statement in Loop (in my HTML view)
Hello, Can someone help me with the following code, it is inside my HTML view - there is a lot of code so I will just post the code I think is causing the problem. I am just getting the error "null" when I press Save Script. <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1"> <thead> <tr> <th scope="col"><span style="color:#a9a9a9;font-size:8px;"><b>ITEM</b></th> <th scope="col"><span style="color:#a9a9a9;font-size:8px;"><b>DRAWING NO.</b></th>
find address of webpage for embedded form
I have one form that will be embedded in two different websites. The functionality of teh form changes slightly depending on which website it starts from. Is there a way to detect information on the starting page such as the url? Thanks Herb Wexler
Passing a set of values to a Parameter E.g. #View:SomeView?ParamID IN {1, 2, 3, 4}
In my application, I need to show a view of records which are determined at run time i.e. my logic identifies a variable number of records (code in an HTML View) and I need to display an embedded list view where I want to be able say that ParamID can have any one values from a set i.e. {1, 2, 3, 4} as an example. I have gone through https://help.creator.zoho.com/Functionality-based-URLs.html and I am unable to find any set operator like "IN" when passing parameter values. The functionality that
Zoho CRM - Creator Integration
Hi, Is it possible to integrate CRM and Creator so that Creator automatically fetches or updates event records in more than one separate CRM implementations? Regards Anders
Search Across Multiple Forms
Any way to search for records across multiple forms? Within zoho, this would NOT NEED TO BE external.
Condition on time
Hi, I want to put a condition to hide the fields of a form if the currenttime is bigger than 5 O´clock, is it possible? Like a If ( zoho.currenttime >= 17:00:00) { hide input.Name; } Thanks.
different visibility/editing of data for different users
hi i have a amount of data for each entry (goods devilery order) in my zoho creator database. example: "id:date:name:address:phone:email:goods list:price1:price2:data1:data2:data3" how can i make different views of data for different users? with _editing functions_ example user1 can _view_ and _edit next fields "id:date:name:address:phone:email:goods list:price1" user2 can _view_ and _edit next fields "id:date:name:address:phone:email:goods list:data1:data2:data3"
Possible internal bug for list manipulations
I have two functions that both should do the same thing. Here's Function 1 int COUNT_BY_ID_ALT(list PRI_LIST) { //use samples CRA,BIR should be 263 n = 0; UNIQUE_ID_LIST = List(); for each element in input.PRI_LIST { ID_LIST = (SUBSCRIBERS[LISTS.contains(element)].ID).getall(); for each ID_element in ID_LIST { //makes unique list of ID's if (!UNIQUE_ID_LIST.contains(ID_element)) { UNIQUE_ID_LIST.add(ID_element);
error when sorting list
Hi! I am trying to retrieve the last 5 participants, introduce their names and performances in a list and then sort them and show the ranking in an HTML view. My code is the following: <tr class="zc-row-header"> <td class="zc-viewrowheader">Name</td> <td class="zc-viewrowheader"> Correct answers</td> </tr> <%index_list = {0, 1, 2, 3, 4};%> <%name_list = {};%> <%performance_list = {};%> <%for each index1 in index_list { row = Session_2_Water_and_jar [ID != 0] sort by Added_Time desc
Modify default table view - add data from another table?
Hi -- I've been at this for about a day now and I have not had any luck with this. Here is the scenario: Form 1 - Contains a list of Companies (e.g., Nike, Addidas, Reebock). Form 2 - Contains a list of store locations for each of the companies in Form 1. When displaying the table view for Form 1, I would like to display a new column that shows how many total stores are available for that company. I wrote a very simple function to query the data: LC = Locations[Company_Name == input.COMPANY_NAME].count();
using preinstalled image in form?
Hi i just make a working place for a employee. so, form with about 50 entities is divided in 5 categories. how can i in form for each category assign an image for quick orientation?
Problem when refreshing the HTML view from any button Click event
I have html view when I click on my button name is SUBMIT ,I insert the record and delete at same time via Delete.And after that I call Open Url and pass #View:Html_view .But here is problem that Adding record double i.e. value of my another view is double ,example:one date show twice.But if i am executing that HTML View by refreshing through URL it working correctly,No twice data. And in Button Click I only pass the URL. If Any one work on it please reply what is problem and solution.........
Sending an e-mail to everyone in view
I have a list of members in a view. One of the fields is e-mail address. How do I send an e-mail to everyone in the list? I know how to export data but it exports every field of every entry. all I want is the e-mail addresses.
Creator is Faster with Chrome latest versus FF latest
Just me or does anyone else notice this Chrome latest edit, views, all seem to noticeably faster than FF latest
Specific data in view can be clickable? possible?
Specific data in view can be clickable?
What is the Difference between the count function and Aggregate Record count statment
Maybe i am being slow today but under most conditions would they not return the same result and in fact serve the same purpose ?
Dynamic map key iteration
I am trying to dynamically populate four drop down fields based on a drop down selection. example: 1. The user selects a work type from a drop down. 2. The selection is passed to a function which retrieves four lists and stores them in key/value pairs in a map. 3. The map is returned to the form. 4. The keys are pulled and iterated in a 'for...next' loop. FORM SCRIPT WorkMap = thisapp.function(input.Work_Required);// this retrieves four lists with the keys set to the Form Field name WorkMapKeys =
Next Page