Possible to have multiple admins and/or transfer admin role to a different user?
Is it possible to have multiple admin users and or transfer the admin role to another user? If not, please add this as a feature suggestion.
Duplicate Error
I cant get one of my applications to duplicate. There are no error messages to show you.. Can anyone help me to sort this out ??
Views Enhancements
1. Change the email field to a Icon instead of the entire email address 2. Relocation option for the Custom Action Columns 3. Make Lookup field a link to view the respected form 4. Change the file attachment field to an Icon instead of the entire file name 5. Add an option that the view link will always show all fields. (or add a column in "Column Properties" to show or hide the field in View)
Unlimited users plans pricing question
I am a bit confused. At this page http://www.zoho.com/creator/pricing.html there is 5000 records add on for $10. On the other side, I saw that in my account at https://creator.zoho.com/home#yourplan (Unlimited users plans) the records addons are $5 and $10 (depending on the Express edition) for $1000 records add on, so the price/record is 2.5 to 5 times bigger than the price for non-Express editions. Which variant is real? The one from here http://www.zoho.com/creator/pricing.html - where is not
iframe snippet embed issue
Hi We have 4 separate applications which have worked perfectly for several months. The applications are exposed within an iframe with form and view snippets. Suddenly all 4 applications come up with the following error message. Error details: Error occured while executing on user input script. Unable to update variable Error occured. An email has been sent to support with snippet details and access to one of the applications concerned. The applications are currently unusable. The coding has not
Create an RSS feed that will display in Google Calendar?
Does anybody know if it is possible to create an RSS feed based on the date field that will show as a google calendar? I have tried taking a copy of the URL for the RSS permalink using the export feature but have had no luck :-(. Anyone know a trick to get this working?
Enable Height and Width for Zoho Creator Form Fields
Hi all, Height and Width attributes can now be set for individual fields(if applicable) in a form from the 'Edit this Field' option. This feature is not yet open to all. If you would like to avail access to the feature, click on the following link and submit the form to request for enabling the feature for your account. http://creator.zoho.com/creatorteam/creator-feature-enable-request-form/form-perma/HeightandWidth_Enable_Form/ Regards, Mukesh
Logial way to check each colum in a row
I may have asked this before, not sure if anyone has found a better way. Lets say I fetch a row into a collection called "therow" I need to now check each column in that row, so I make make my way left to right if "therow.C1"........ if "therow.C2".... if therow.C2" I have 50 columns what i need is a "therow.C1+ 1 next column statement or to have therow.C1 replaced as a variable which i can build Any ideas from anyone ? thanks
Need help defining function for referencing fields from other apps
What I am trying to do: I need a form in my remote app to filter a lookup dropdown field based on the records from another master app. Ideally, it would work exactly as my on add and on edit scripts work in the master app. The current script used for that is: if (count(Tour_League_Division_Conference[Series == input.Series]) == 0) { clear Tour_League_Division_Conference_Name; } else { rec_TLDC = Tour_League_Division_Conference [Series == input.Series] sort by Name ; Tour_League_Division_Conference_Name:ui.add(rec_TLDC.Name.getall());
Update Record clear check box values
hi In a function i have retrieved a record, now i want to update the record and clear some check boxes which are checked cant seem to figure out what value to write to the record.. do i have to build a blank list first maybe ? Thanks
Issue with zoho.loginuserid == null in Formula field ?
Hi, I need to use zoho.loginuserid in a formula field, but <Expression 2> is not used at all. For example : if((zoho.loginuserid == null),"not logged","<a href='MyLink'>logged</a>") This is used in a public view, when we "sign in" the value doesn't switch to "logged"). Any ideas please ? Thanks.
excel formula to deluge ..base-10 logarithm of a number
my formula in excel reads =5.8-(1710/(273+$C4))+0.67*LOG($H4) $C4 =Operating_Temp_C, $H4 = Fugacity_CO2_(kPa) which becomes 5.8-(1710/(273+Operating_Temp_C))+0.67*LOG(Fugacity_CO2_(kPa))but I can not get the LOG function to work I have tried log() …….Format:<numeric>.log()……. Returns the logarithmic value (LogeN) of the specified number. 5.8-(1710/(273+Operating_Temp_C))+0.67*log(Fugacity_CO2_(kPa)) but with no luck and LOG10 …Returns the base-10 logarithm of a number…..LOG10(number) ……Returns the
Bug Tracker feature requets - filtering by, and reporting on custom fields
Zoho Bug Tracker currently supports filtering bugs by custom fields. The out-of-the-box bug form doesn't meet our need, so we ended up adding a number of custom fields. However, we cannot filter bugs based on these custom fields. It would be useful to be able to filter bugs based on custom fields. Also, Zoho Bug Tracker only has a limited set of canned reports, based on the predefined values of only the out-of-the-box fields. It would be useful to be able to define custom reports. A custom report
More Fun with Lists
This is a continuation on topic https://help.zoho.com/portal/en/community/topic/proposing-a-new-function-for-lists-remove-duplicates In this case, I'm attempting to find the intersection of two lists. For example, List_A = (a, b, c, d. e) and List_B = (c, e, f). The intersection of List_A and List_B is List_C = (c, e). In PHP, one can do this: $List_C = array_intersect($List_A, $List_B) But we do not have such functions in Creator. Now imagine a database where we have 100's of "List_A" records that
Application layout rendering issues in Zoho Creator
One of my clients is facing issues in rendering of the layout for a Zoho Creator application, with the views getting nested somehow on his browser. I have given below the screen-capture of the application screens below. On wide-screens.. On iPhone : Personally from my account and from another, I do not face issues when testing the app from wide-screen devices. Kindly let me know why this might happen when my client accesses the app and how to avoid it. Thanks & Regards, Z.App.Maker
Reports not updating
My reports aren't always updating when the information has changed. It will be working fine and then all of sudden, it won't update again. I have to create a new report to have the changes reflected. Is this a known issue? Am I doing something wrong?
"Add Notes" - having url links open in another window
Hi! I added notes (Add Notes) in my form but the notes I added are URL Links. It works fine but it opens in the same window as my application form is. Is there a way to have the links opened in another window? Please advise. Thanks a lot! Regards, Queenie
Sub-Form help required
I need some assistance please with the new sub-form facility. I need to create an application to record jobs, and be able to allocate those jobs to certain people or vehicles. I would like to be able to view a certain person or job, and have a sub-form display the various jobs allocated to them, I would also need to be able to re-assign jobs from one person or vehicle to another if required. Can anyone tell me if the above scenario is possible, and if so give some pointers as to how it can be achieved.
Question about updating records
I am creating a Mileage Tracker for my motorcycle group. I would like for the application to update existing records when a user submits new data. Let's say I have 3 fields: Name Email Mileage If User1 inputs 350 miles one day, then comes back next week and inputs 225 miles, I want to have the app check to see that User1 already exists as a name, so add the new mileage data to the current record, instead of making a new record. To keep a running total of mileage per user. Does that make sense? I
dynamic picklist problem
Hi, I have just noticed a problem in my dynamic picklist recently, let say I load a Vehicle No picklist from form B with the criteria of matching date. The vehicle no in form B is not unique and it can show up in different date. Supposed I selected a vehicle no ABC 1234 of 4/12/2011, this vehicle no ABC 1234 also showed up in various date before. When I clicked the link to view the record in View mode, it will show the vehicle no ABC 1234 from another date, instead of 4/12/2011. Is this a bug or
Popup a verification screen from the function?
I have a function that is called as a Custom Action on each row of a view. The function makes a change to a field in the corresponding record. I would like to display a message for the user giving them a choice of OK or cancel. Something like this "You are about to change information for John Jones. Press OK to continue or Cancel to not make the change." Is there a way to popup a verification screen from the function? Herb Wexler
FIELD UPDATE WHILE FILLING FORM
Dear Sir / Madam In my form, There a some checkbox, I want when applicant start cliking the check boxs, one another fild start counting number of checks. based on the number of checks I would apply a formula in another field. Please help
HTML View: Sort by parameter passed through URL.
I have an HTML view in which there's a for each record in form loop. Now I'd like to sort these results by a parameter passed through the URL. For example, if ?sort=name is passed on with the URL, I'd like to execute the loop for each record in form sort by name. Is there any way to implement this directly instead of performing consecutive if - else loops containing the same piece of code, except for the sort by parameter? E.g. for now this is implemented like this : if ( input.sort == "name" ) {
Is there any way to make a Creator Form act like a Web to Contact form
The Creator is ideal to organize new leads, but if I have to manually re-enter all of the form data into a new contact, that is redundant. I would greatly appreciate any assistance. (I'm not looking to have the creator form operate on a website like a Web to Contact page, just integrate the data)
contains() function inconsistencies - case sensitive in some cases, not in others
Hi, There are two other threads discussing this situation but I am not seeing any responses from Zoho support so I am consolidating these discussions here. My original post generated this thread and led us to include this other thread in our discussion. With some thorough testing Gaev discovered that, "Looks like .contains("xxx") is NOT Case Sensitive when applied to Collections ... otherwise it IS !!! Please respond to this. Thanks again for your excellent support. John
contains function is case sensitive despite documentation stating otherwise
On this help page:https://help.creator.zoho.com/Built-in-Functions.html ...the following is stated: A function is a set of code, that takes a finite number of input and optionally returns a value. None of these functions are case-sensitive. However, it turns out that the "contains" function is actually case sensitive. This caused me to waste a lot of time debugging the wrong parts of my scripts over the past few days! Anton
help with case conversion and contains string functions
Hi, Is it possible to do a case conversion and search a string for a substring in one step? For example, I have tested: for each title in Books [Title.contains(input.Title_search)] - works but is case sensitive. for each title in Books [Title.contains(input.Title_search.toLowerCase())] - substring is converted to lower case successfully but obviously I need to convert the Title string as well. for each title in Books [Title.toLowerCase().contains(input.Title_search.toLowerCase()] - problem with
Customizing look and feel for multiple page forms
Hi there! We are in the process of creating a multipage form. The first form we embed - which is the lead form - looks fine when we embed it in a website. But all subsequent forms result in the default look and feel. See this example: http://www.jessweiss.com/testing/brandeisinfo/index2.html How can I keep this from happening? Thanks!
views and hidden fields
2 questions: 1. I duplicated a number of views based on a view that appears under the View button. For some reason the duplicated views are appearing under the Forms button when using the application. How can I change the views so they appear under Views? 2. I have a form where I have hidden a number of fields. But when I run the application, they appear on the form. Why is that? Is it because I am the admin? thanks, Ray
TABLE CREATION
Dear Sir/Madam I making a Application form, where I need a table in which the applicant will key-in the data. Please advice how I can create a table. I created a table thru Add Note but after creating the applicant unable to key-in data in that table. If I create table thru Sub form then type of matrix table not possible like 9FT 20Ft 40FT own - - - hired - - -
Disabled RTF the grey box appears below the field
I have a disabled RTF after several fields that are hidden. They grey shading that indicates the field is disabled appears 2 inches below the field. This is about where it would be if the hidden fields were displayed. I have the same result in FF and Chrome. Herb Wexler
Logo in the Forms or at Header Level
Dear Sir / Madam Please advice how a company logo can fix at header or inside the form I tried copy paste thru Add Note but unable to do Please help
User Forwarding Once Form Is Submitted?
I would like to forward my users toa thank you page once they have submitted my form, how can i do this? Thanks, Cal.
Multiple users of same permalink - non-login version
alsingerzohorecruit 1 - seconds ago Does the use of views provided by permalink (the version NOT requiring a login) allow for multiple users accessing the same permalink form at the same time? For example, lets say there is a stateless form that is shared with a number of users by NON-LOGIN permalink... The form asks the user to enter two fileds of data which are then checked against a file to return a certain value.... Can multiple users be executing this one permalink form at the one time - without
automatic calculation
hi ! i did a form where my users site complete the result between two fottball team , and i want to showing them a view based on result : win draw or lose , the points of that teams . For example : Team no 1 vs Team no 2 ends up 2-1 for team no 1 . Team no 1 will have 3 points and the team no 2, 0 points. In the second match the score is 0-0 , and team no 1 will have 4 points and the team no 2 , 1 point. and so on . This is my form : https://creator.zoho.com/adiman/rezultate/form-perma/Rezulate_inregistrate/ and
Re in view of the number in the format
Hi How can I format numbers in view? I want to the format like 12,345,678.00,but the format always display 12345678.00 in VIEWS even the field is "$currency" also can't with a thousand digits,so it's not easy to read large numbers. I knew that in form and function in a format function can be used to solve this problem, but I do not know how to solve this problem IN views. Thanks Stanley Guo 2011-12-22
Backreference in replaceAll()
Is there a way to refer back to the search statement in the replace statement of the replaceAll() function? For example, I want to search (case-insensitive) for "abc" in a given string and replace it by "<0>" + found string + "<0>": "xxABCyy".replaceAll( "(?i)(abc)", "<0>\1<0>" ) ---> returns "xx<0>ABC<0>yy" "xxabcyy".replaceAll( "(?i)(abc)", "<0>\1<0>" ) ---> returns "xx<0>abc<0>yy" In other programming languages this is realized by creating a capturing group using round brackets
Adding multiple records to different forms based on calculations from initial form
I have a form (called ServiceRequest) that collects input for services that we provide. The input includes "Start Date" and "End Date". From this, the "Duration in Days" is calculated and a price is quoted (column name = Quote) What I would like to do upon submission of this form, is have it calculate the number of weeks in the duration (Duration_in_Days/7). Using this value, the equivalent number of records would be written to the table named (ServicePaymentCalendar) passing with it prorated
Can create a form that would allow web users to search my spreadsheets?
I would like to create a form that would allow team captains to search my database of players looking for a team and see a list of players that meet their criteria. Is this possible? How would I start this process?
loop through records and display them a certain number per page
When I perform a for each on records I can access all my records. But what I would like to do is say: show me the first 25 records. Then I want to access the next 25 records. And so on. I read some forum postings with solutions about adding an extra field to my records for this but when using criteria to filter records this would lead to strange results because the number of records per page would be different. And also I would think that this is a feature that Creator should support. Creator's
Next Page