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 =
help zoho support
this is the message in the view We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com why ? i lost my view because of this
Assign Point Values
Hello, I have a form that asks questions of the user, and I would like to assign a "score" to their answers behind the scenes. For example, I have a drop down field called "Licensing" that asks for the users license type and then there is a drop down with the following selections: N/A, Med 1, Med 2, or Med 3. I would like the following scores to be assigned to their answer: N/A = 0, Med 1 = 1, Med 2 = 2, Med 3 = 3. What kind of formula will work for me? Thanks
how to clear application view?
hi how can i delete unused (and deleted) forms from application view? see upper dark-grey row in attachment and how delete views in light-grey row an bottom?
Locations of Forms and Views
Hi, I made a mistake and put a couple forms and views on the wrong tab. Is there a way to change that? (e.g., Applicant View is on the Form tab). Thanks! Q
Headers and Footers in HTML
Hello everyone, Just wanted to share something I have found, using the following link / code: http://www.w3schools.com/html/html_layout.asp I was able to create headers and footers which you can use to make professional PDF files for customers, etc. A few people (myself included) have been asking how to do this, and the above link is the code that you can use to do it :) Feel free to ask any questions if you need some help Many thanks Ben
Delete a subform entry by clearing the Parent ID Relationship field
Hi I have my subform form with an existing relationship field showing so i can see the parent form ID which is written every time a subform entry is made from the main form Can I and is it safe to delete main subform entries by writing a null to this field. This would give me a way programmaticly remove subform entries. (in may case delete a booking record if date expired and deposit not received) While i am thinking about it, is it safe and smart to programmaticly add entries to the subform form
how to display 'added time' as number of days since that date
hi for the field added.time we would like to display it in our 'view' as number of days since that date. ie. 4 days. so anytime someone uses this view it will show them the current days it has been since the added.time what do i have to do to get this working? or do i need to use some kind of report/schedule? cheers Lathan
Using Script Builder "No rows found for the table PersonalityConfiguration in this DataObject" when updating a variable
Hi, Seems to be an issue with script builder and subforms as follows in an On edit on success section when i write this script 1) abc = "test"; 2) for each put_dates_in_patient_info in input.v3booking_form { } 3) put in a command to update a variable example abc="test"; for each put_dates_in_patient_info in input.v3booking_form { ************** abc=put_dates_in_patient_info.Added_User; ***************************************** } the command abc=put_dates_in_patient_info.Added_User; will give
search indicator
After the records have been fetched... why is it that the search indicator" still rotating?
When editing a report show the report name on top
When editing a report show the report name on top. Also if there is room show the View the report is based on. Herb Wexler
linking my customer contact form to product form
I have two forms, already populated with many data entries. One form has client contact info (Customer Contact Data) and the other (Lift Data) has details on the product or products they have purchased from us (handicapped accessibility lifts), including serial numbers, install and warranty expiration dates, and date of last service, etc. Both forms have a field called "Full Name" and I want to be able to connect the records with matching content in the "Full Name" field in both forms together.
Alert pulling data from input sheet... not sure its even possible!
I'm creating a purchase order form. I've imported the PO numbers to be assigned to Column 1 of the data sheet. The other columns are blank. What I would like is for the data from the form to be saved in the next "available" PO number row (if that makes sense) AND for an alert to come up and tell the person filling in the form what the assigned PO number is... does that make sense?!
Background
My website background color is blue but when I embed the form, it doesn't blend well. How can I change the background color of the form to different color or make it transparent?
how to make visual edits to form
I want to add static labels to different parts of a form- how can I do this? For example I want a portion of the form to say "Mailing Address" then I want to add actual fields like street, city, state, zip, etc.. under it. Thanks, /db
Next Page