Lookup and display current information on forms and views
My Zoho Creator database has a one to many relationship of one skater to many tests passed. In several views, I need to be able to display the highest test passed of three different test types (Moves, Dance, and Free) for each skater. I have successfully created fields in the Skater Information form which are populated on form success. The script in the form looks for the highest test of three different test types and places the high test number and name in fields in the form. I can display those
App sharing
I am the admin of an app. I shared the app to a "developer"-type user, but this user can't edit the app..... do I need to do something additional?????
Pivot Chart generated from Creator subform column
Hi How do I make a pivot chart auto-regenerate when the underlying data in the subform it is based on is updated? If I have a pivot chart that is created from a main form it auto-updates the chart when ever I add new data via the form but if my chart is based on a column in a subform I can only get an updated chart by manually clicking on "regenerate" option. Thanks EDIT: Actually the chart based on the subform data will update automatically(synchronize) if I submit the subform data by using the
Create an estimate from Soho Creator
Could someone provide a sample code to create an estimate using Soho Creator's Deluge script? The following script doesn't work. For the XMLString, I copied the sample that is given in the Soho Invoice API documentation for adding an estimate into a map. What am I doing wrong? mymap = map(); myURLXMLstring = encodeUrl("<Estimate><CustomerID>3000000000338</CustomerID><EstimateDate>2009-09-06</EstimateDate><ReferenceNumber>121</ReferenceNumber><EstimateItems><EstimateItem><ProductID>3000000000332</ProductID></EstimateItem><EstimateItem><ItemName>Sample
Expense in Zoho Creator
hye there, besides creating new invoice in Zoho Invoice in Zoho Creator, is there any way to create an expense in Zoho Invoice (expense) through Zoho Creator? may i know, what's the function invole? zoho.invoice.XXXX? thanks..
On Add Row in Subform, Lookup field pre-fills automatically with data from previous row (unwanted behavior)
Today we are noticing that when we add a row to a subform, the first lookup field pre-fills automatically with the value entered in the first row of the same subform. Other fields in that row are scripted to auto-populate depending on the value chosen in the lookup field. ex. given Row 1 Lookup field = X, several fields in row auto-populate according to a script using X as an input Add row Row 2 Lookup field pre-fills with X, incorrectly, auto-populates other fields incorrectly That lookup field
Update count
Hey, I'm trying to use the Fetch and Update records to update a count/total number of items. eg I have an inventory form with toner cartridge with a count, eg I have Model: "lexmark T644" Cartridge: "black" number: "3" And so on for each item. In another form, when people input they changed one of these, how can I update the count from 3 to 2? eg minus 1?
Missing Feed URL tab
I would like to generate an RSS feed on my database, so i can import 'm in Google Reader. On this webpage https://help.creator.zoho.com/Import-and-Export-Data.html i see a FEED URL option, but i can not see/ enter this tab.
How to use openUrl to act like the built-in edit record behavior
Hi i have used customer action to call forms to update records in popup window but i encounter some problem while closing the popup window if using openUrl("#Script:page.refresh", "same window") the view page reloaded to default setting, all search/filter are gone if using openUrl("#Script:page.close", "same window"); popup window closed, but the newest update is not shown in view page how can i make the openUrl act just like the built-in edit record behavior? remain the search/filter
Can Invoice pass "paid" status to creator?
is there a way to pass a "paid" status to Creator from Invoice. If the customer has made a full or partial payment, can a custom variable be passed to a table in Creator to reflect it that a payment has been received?
How to make fields required by default?
Is there a simple way to do this? In our forms, almost every field is required. It would be much easier to make everything required by default rather than having to click 'Options' and then 'Required' for every field in a very long form.
Ticket ID: 934663 (7 Days A go)
Dears, I send 2 mail but no any answers. I am still waiting... Rgds CTG
How do I paste the contents of one field into part of another field?
Hello - In my database I have a field called "subdomain", and then I have six other fields called "URL Europe", "URL Alaska", URL Caribbean", etc. The six fields have exactly the same content for every record, with the exception of the subdomain. i.e. - http://[subdomain].europe.myvacation.com http://[subdomain].alaska.myvacation.com http://[subdomain].caribbean.myvacation.com I would like these fields to auto populate once the subdomain has been entered. What is the code to program this? Also,
Workday function
I am familiar with solutions from here https://help.zoho.com/portal/en/community/topic/calculate-number-of-business-days-weekdays?reply=true But I don't understand how to use it. I have formula field named "Day" with this formula: ((zoho.currentdate - Start_Date) / (1000 * 60 * 60 * 24)) "Start_Date" is data field. I want in output to exclude weekend days (Saturday and Sunday). In other words I want formula only to calculate business days. I am happy to pay consultant for help.
creating a pivot table or report which contains text
Hi I am new to Zoho - I have created a database which contains statements - goals to be exact, that are filtered by a number of sub categories - I want to present the data in a pivot table so the views can be easily changed. however I can only get the pivot table to show numerical data - is this correct? is there a solution? Any help would be greatly appreciated. Sophie
Re user management and app share..
Hi 1, Re user management, hope add a user nickname and department, because the user is described only by mail, if the user can more difficult to identify, so difficult in share form or view. 2, when share form and view by group, it is best to be able to see the group members name, and now can only see the name of the group. 3, if the administrators to all users according to the current can drag and drop create a group and can change the group members, will facilitate administrators to quickly deploy.you
Help! My public forms have disappeared my on public website
I have really got myself in a twist - please help! It was all working OK then my two Forms have disappeared from my web site: http://www.gare.co.uk/gas/submit.htm The problem started when I created a number of new reports. The real issue is in the sharing tab as I cannot get the forms or many of the reports set to Public mode. They stay stuck at Unshared no matter no matter how many times I click the Make public to all visitors over the web button. The only items I want to be private are the two
How to export to Excel
While the help topic says to go to live view and there will be a drop down menu of more actions, and then select export data. On going to more actions I do not see the option "exprt data". Can any one help ?
Need to create a hash based on email adrdess or zip code
I would like to create a unique hash for a public user based on email address or zip code or some other field. Any idea how I can do this easily or point me to a coding or function solution? Thought there might be a .hashcode() function somewhere. Chris
Delimiting Multi Select field with Line Break instead of Comma?
Is there a way to make multi select fields put each new entry onto a new line? Rather than delimiting with a comma delimit with a line break? I want my multi select field to put a carriage return after each selection so that when it shows up in a view it DOES NOT LOOK LIKE THIS.. 09-Jul-2010 - First Sale - BC Boxing - Strategic Edge, 13-Aug-2010 - Meeting Room Rental - Best Western Duncan - Strategic Edge, 29-Jun-2010 - First Sale - Raemar Restorations - Strategic Edge, 12-Jul-2010 - First Sale -
Specifying constant time for date-time field, not supported
"Error in scheduling parameters: Specifying constant time for date-time field, not supported" This is the error I received when trying to save a Schedule. What does this error mean?
If condition upload field in subform
Hi, I've problem with script that on validate Alert that it's necessary to Upload a document in field3 (of subform). //if (((input.Field1 == "Option") && (input.Field2 == "-Select-")) && (Subform.Field3 == "")) //{ // alert "Insert a upload document!" // cancel submit; //} The script don't run, Any help. Thanks. Mic
Will not graph a calculated field
I have created a simple graph that plots two simple number say x and y - all OK. When I create a calculated field y * 100 it will not plot and says data is unavailable though the calculated data can be seen in the data view OK. I can see no reason for this so tearing my hair out! Chris
---> !! ---- > !! . How to have drop down choices stay selected and not reset to top after submitting a record ?
So here is the set up.. The way my form works right now , is teacher picks from drop down their name, then their location from the second drop down. Then the teacher enters name of a student in one "single-line" box, and the students email in another single line entry box. .. then they press submit.. Only to then repeat the process, each time re-picking their name (instructor drop down) , location (drop down), then entering student, name and email into single lines ... So my thought was, could
error when updating dynamic pick lists
Hi, I have a form where I have subsecuent pick lists being updated dynamically based on the previous one selection. The issue I have is that when the user updates the first value, the script moves through the whole chain of picklists until the an error is issued based on the null selection of values. in other words, when a pick list is assigned with values, the script considers that as a user input which triggers the next pick list assingment. This ends up with a mistake at the end of the chain.
Spreadsheet feed not importing some data
Hi, I have a problem with my View CMC RSS Cardstudio CartdoDia, because when I capture the data with Excel (spreadsheet feed) a column called "Pacom válido até" still no importing data and display a blank column. Thanks Mic
Stateless Form Submission and input.ID
I have a stateless form that submits data. Part of this data is a url link to the record created by the stateless form. The problem is, in constructing the link in the stateless form OnSubmit script I'm using "input.ID". This value is being assigned null in the record. I was under the impression that creator might hold a value for ID in case the stateless form called for it. I guess not. Now I'm left with having to script and assign my own "ID" to reference this record. Am I totally wrong, or is
Create a form and view by anyone is not free NOW !
Why ? I use zoho creator during 6 months. And now, when i want to use form to anyone, the option "To access the form without login" is not allowed ! Please go back ! I need it !
Need help for sort in view custom action drop-down button
Hi Can I sort in view custom action drop-down button, I tried to not do the sort, is there a way can be done? please check attch pic but when I browsing the view it's not as the sorting .. Thanks Stanley Guo 2012-2-27
Date format
Hi, anyone know a on input/script to automatically insert slash to separate dd mm yy. I explain, I need facilitate the life of the user and transform a date inserted as a number like 010212 in 01/02/12. Also I need ignore the date when people choose to insert it in the correct mode like 01/02/12. Is too complex? Anyone use similar script? Thanks in advance. Mic
Maximum Concurrent User Tickets Limit Exceeded
Hello, I'm relaunching my application a lot during development work and have hit this API login problem after about four months: "https://accounts.zoho.com/login" with the correct parameters set returns: "# #Thu May 19 04:30:10 PDT 2011 CAUSE=Maximum Concurrent User Tickets Limit Exceeded RESULT=FALSE " I can't find any reference to this error. I assume it's because I'm logging in very often. Normally I wouldn't login so often but am relaunching and re-logging in every time during development. Is
Grid view does not work properly.
I can change the display view from List to Grid OK in "More Actions/View As", but I can't set it to be the default. If I choose Grid to be the default Display Type, it shows in List format.
General error, message from server: "Got error 139 from storage engine".
Hi, I had a form working fine for quite some time. Today I've added two dozen text fields to it and tried to modify entries, and got the following error - General error, message from server: "Got error 139 from storage engine". Googling up showed that the error is with MySQL InnoDB max row length limitation. Is there a way to fix it, to make text fields blobs for example ?
Need Zoho creator programmer to help customize application
Hi I am looking to find a zoho creator programmer who will work under a Confidentiality Agreement as a consultant to assist in customizing application. Interested parties please contact me at ecamastro@impaxlabs.com Eric
Any good Zoho people for hire in London?
Hi, we are an SME that uses Zoho and wants to use it more. We usually have an in house resource for this but work is so busy we haven't got any spare time for him to work on it and a list of things that need to be done. Are there any freelancers out there that could spend a week in our office and help us make our Zoho system better?
'Duplicate' record button in Grid View
There doesn't seem to be a 'duplicate' button when viewing in Grid View, the 'duplicate' button only appears in List View. For my app, I sometimes need to duplicate records very often and change some fields for each duplicated record. Normally, what I've done is to select the record in List View, click duplicate record, then manually edit each duplicated record. Ideally, if I could duplicate the records while in Grid View, I wouldn't have to manually open up each duplicated record to edit the fields,
Sharing with large number of users
My app has about 100 users and that number changes. I'd like for all user to be able access the view, but don't want non-users (public) sharing. Is there a way to allow a view to be accessed by ALL users without having to enter them individually or maintain a group?
Data collection and input with restricted access
Hi, Just a quick question. I am looking for a data collection application much like microsoft access in which variables can be edited and submitted by my clients, however they are unable to view other individuals data. This is vital as the data I am collecting is confidential. Is thia possible on Zoho, or is it only possible to allow the individuals full access by making the file public? Any information would be gratefully recieved, Kind regards, Andy
Problem editing and deleting entry
Hi! I have imported data into Zoho Creator and all seemed to go well. However, i noticed that I cannot update or edit the updated data. When I edit an imported data, it first said that "Data Updated Successfully" but then later I got this error message: Error occured while on Update script. In the subString function length of the parent string is 0 but the end index is given as 2. Please also see attached. I don't understand this because I don't get the same problem for the manually entered data.
no response from support after 3 days
I am still waiting for a reply to an email sent 3 days ago...
Next Page