How to make a hierarchy?
I am designing a HRMS and I need to know how to make a hierarchy so that I can allow people to only access information they are privileged to see. Is there anyway I can do this? Any help would be greatly appricated. Thanks, Michael
Mailing List App
I'm looking at options to improve the user experience for a mailing list (announce only) service. Right now, my organization is using Mailman. It seems to me that the Creator platform could provide a very nice mailing list service with features only available on high-end mail apps. For example: a newsletter could be personalized with "registered" user's names personalized "un-subscribe" links could be added to the bottom of each email (url encoding to stateless forms) user's could have a dashboard
form does not save records on submit.
Please help. I have a form that works....except it doesn't save records!!! I will share this to support.
Renamed application still appears with old name for shared users
I renamed an application that has shared users, but the old application name still appears in the list of shared applications that users see. When a user clicks on this, a message appears saying application does not exist. I had to remove the shared users from the new application name and reassign them again for the new application name to appear in a shared users list. The old application name however still appears. Is there any way of removing this old application name from the shared users list?
Currency
Would it be possible to add GTQ currency for Guatemalan Quetzales?
Formula Scripting help
So I feel like this is probably a simple answer, but I can't find reference to it in Help and it's taking me a really long time to figure out: When I'm defining a formula, how do I refer to a value that's in another form? I know I need to do Fetch Record, but everywhere in the form definition scripting that I try to put it seems to be wrong.
How do you add a button on a form?
I would like to add a button but am not sure how, could somebody enlighten me. Thanks, Michael
How can I add new values/items in a lookup field?
I know lookup fields can be used to create a one-to-many relationship between 2 forms. I have a "Company" form (the "one" of the one-to-many relationship) and a "Issue" form (the "many"). When I am editing an "Issue" record and discover the necessary Company name is not in the lookup filed, I would like to be able to add the new Company name without leaving the "Issue" form, adding a "Company" record, and coming back to a "Issue" form. I've seen several posts about limiting/filtering the values in
Email having data deleted.. pl. help
I have created a questionnaire (form) for collecting data. (Perhaps accidentally) I deleted the email (received in my Gmail account) having the data (filled questionnaire). (even I could not find in Trash and Spam). It was very important for me. Please help.
Linking Creator forms to Spreadsheets for accounting?
Hello, My organization uses Zoho for a funding request system, where we manage about 140 different groups, giving out money to them using a form-submission system of approval for purchases. We already use Creator for our forms and keeping track of where a submission is in the process (Submitted, Pending, Approved, or Denied). However, we want to take it a step further, so that the dollar amounts that have been approved can be automatically added to spreadsheets, that could then track groups' spending
Copy Record To Another List
Lets say I have two lists(forms): Leads and Clients How can I add a button to each entry in the Leads list that would say "Copy to Clients" and copy that record into the clients list The lists are formated like this: Leads Name - Phone - Email Clients Name - Phone - Email - Address Thanks for any advice or info!
Linking Forms
I have an input form which I have created. I would then like another form to be created where the first field would be say - Job Number. Based on this job number, fields would be populated with details entered on form 1. Additional fields would then be completed as necessary. I would want an automated form of look up based on a condition where the job number = xxxx. Any help much appreciated.
removing "View Log Details" from a form after submission
please tell me how to do this.
Embed in website not working?
Hi I am new to this product (it's great so far!) however, when I try to embed the form I've created in my website, I don't get that as an option in the drop down for "More Actions" in Form view. Any suggestions? I'm using it for free at the moment - not sure if this makes any difference as to the functionality....Thanks.
Application Design
I am looking for a bit of help designing an Application for Creator. Basically its a message taking application, but rather than setting up an application for each person, I want to created a drop down box which will be who the message is for, then when I submit the form, it emails that person. Can anyone help with the script that would be needed?
2nd condition being ignored in validation script
I have a form with 2 fields "Region" and "New Region" Region is a look-up field from another form and New Region is a Single entry text field. When I use the following script to validate that there are entries in both, the first condition is evaluated and submit is canceled. However the second condition is not and the form will process even when the second field is null or empty. if ((input.Region == null) && (input.New_Region == null)) { alert "enter a region"; cancel submit; } If
URL field not working correctly
I have a view with a list of records and each record has a URL field. All of the URL fields work correctly; when I click on the URL it opens in the same window. This is the way I want it to work. But, when I click on the URL field in the last record, it opens in a new window. This is NOT the way I want it to work. Why does the last record in a list behave this way, when all of the other records work correctly.
Error
Error occured, please contact administrator, for 2 weeks now. Email pjmitchell@rocketmail.com or account holder, herndon.tim@gmail.com
Create a view or report based in diferent forms
hello, how can i create a view or a report based in different forms. Example: I have different forms for different product sales. In the end of a day i want to have a view, or a report, wich give the result of the sales of that day, including the summ of the sales. can you help me please. Kind regards, José Pedro alvarez
Validation of 2 conditions fails when 1 is a look-up field
To see the whole discussion see: http://help.zoho.com/portal/en/community/topic/2nd-condition-being-ignored-in-validation-script I have a form with 2 fields "Region" and "New Region" Region is a look-up field from another form and New Region is a Single entry text field. When I use the following script to validate that there are entries in both, the first condition is evaluated and submit is canceled. However the second condition is not and the form will process even when the second field is null
How can your get a link for an application that can be embeded in a website? Application was created by uploading an excell document.
How can your get a link for an application that can be embeded in a website? Application was created by uploading an excell document.
Show related views on one screen.
I have an application with several related forms. There is the client details form then a form for the details of each of the clients children, then a form for each of the clients automobiles, then a form for each of the clients pets. The forms have many to one relationship with the client. Is there a way to show all this information on one screen? What I envision is a list on top of the screen showing the clients. When a client name is highlighted the lists of children, automobiles and pets show
Cycle 3: Review the Features and Cast Your Vote!
The voting application can be found at this link http://creator.zoho.com/niskypto/cycle3/ Please review the proposed features, which now include comments from the ZOHO Creator team. To vote, you will need to sign in to your ZOHO account. Votes will be collected from 13-JAN-2010 until 27-JAN-2010.
Formula to calulate days until closing
I'm trying to calulate the number of days until a project closes. So I need to take the closing date minus now to get the number of days so I can write a rule. This is what I have but it shows nothing. Datecomp(Now(),${Potentials.Closing Date})
Can you or how do you get the contents of the form (in Zoho creator) sent to you via email once somebody has filled it out?
Can you or how do you get the contents of the form (in Zoho creator) sent to you via email once somebody has filled it out? Many Thanks!
I Get a Blank Page When I Go to Edit Form
I am no longer able to edit my form as it doesn't show in edit mode. The form is "VarietySlotting" under the PDdbMobile application. I have given support access. Please let me know if I did something wrong to cause this so I don't do it again. Thanks!
Auto assigning values to fields based on a pre-defined criteria
Hi Guys, I use Zoho Creator to run a runner ranking program. The idea is that runners submit their timings for a particular distance (they can choose from a total of 6 different distances). For a given distance, i need a 'rank' assigned to each runner. Right now, i do it manually i.e. export the data and sort the entries and then assign ranks (which will be displayed through a view). I know i can auto-assign serial numbers (by using counters), but can't seem to get a solution for assigning ranks
Lookup Criteria
I have this form to match individuals already matched with project onto a second project. So I've based a lookup on two criteria, both of which must be met, that reads something like this: (Match != null) && (Second_Match == null) I just KNOW there are records in my database that meet this criteria, the form selected is right, but no matter what I do, the dropdown is empty. why won't it work?
Filling a field with On User Input
I'm having a bit of trouble getting one field to fill in based on the input of another field. Here are the details: I have one form called Part_Types. In that form there are only two fields: Part_Type (single line) & Part_ID_Number (decimal). The Part_Types form is completely populated with all of its needed data. The second form is called Parts. In the Parts form I have, among others, a Type field, which is a drop-down list based on on the Part_Type field from the Part_Types form and a Part_ID field
Undeterminated Error
Hello, I'm getting this error when i include a record to a form: Duplicate entry '' for key 2 there is no aparent reason for this. Here is the code of the form: form Funcionarios_Dependentes { displayname = "Funcionarios Dependentes" must have Funcionario ( type = picklist values = Funcionarios.Nome_Completo sortorder = ascending ) must have Dependente ( type = picklist values = {"Conjuge", "Filho/Filha", "Pai/Mãe", "Irmão/Irmã", "Outros"} ) must have Nome ( type = text ) Observacoes ( displayname
Error Code 2892
Yes, it seems Zoho Creator has a problem recognizing my application's name. This (API key and ticket crossed out for any security reasons): <form method="POST" action="http://creator.zoho.com/api/xml/read/apikey=[edited]&ticket=[edited]"> <input type="hidden" name="zc_ownername" value="hjdoyle"> <input type="hidden" name="XMLString" id="XMLString" value=QueryRequest> <input type="submit" value="Get List"> </form> ..always returns 2892 - "Specified application name
Criteria - Show only if date field is older than one month
How would I write the script for the criteria on a view that only shows records that have a Date field that is older than 1 month from the current date? In other words, I don't want a record to show up in a certain view unless the Date field on that record has an entry that is older than one month from the current day.
Any way to hide image name in my application?
In my application MNMemebership, is there any way to hide the image name in the view of the form but still have the image show up in the view?
Form is Scrambled on Mobile
Hello Zoho Team, One of my forms ("Trial") is scrambled on my mobile device. It is the only one with this problem. The form is in perfect order on the PC. Zoho currently has full access to my application. mobile format: http://creator.zoho.com/mobileForm.do?zc-mobile=true&appLinkName=pddbmobile&formLinkName=Trial&link=true&deploy=true&sharedBy=smspdd PC format: http://creator.zoho.com/smspdd/pddbmobile/# Thanks for your help.
html views are rendered into blank PDFs
Hello Zoho Creator Team All my links to PDFs (created by Creator on the basis of html views) give me blank PDF Files. Example (adjusted slightly for confidentiality reasons): https://creator.zoho.com/username/MyApp/pdf/Print_Asset_English/&recID=373791000000813031&zc_FileName=Asset_XYZ&zc_PdfOrientation=portrait&zc_PdfSize=A4 Regards, Filip
Item Reported to be Fixed ... but it is not !!!
On this page ... http://help.creator.zoho.com/Feature-updates-and-bug-fixes.html ... amongst the list of items reported to be fixed for ... Friday, Jan 08, 2019 ... is a line that says ... In a view containing many columns, when search is clicked, for the operator "Between". the search text boxes were very small. Fixed ... but it appears not to have been fixed ... see attached image. Gaev
Export data from a long form
Hi, I've done this form https://creator.zoho.com/simona_landi/questionario/#Form:Internet_form it's a long form... Now I need to export my data in a spreedsheet (excel), I don't need a view. I've tried using a view but the number of my colums (138) are too much, if I reduce the number of displayed colums when I export data I cant't get all the form data. Is there a solution? Thanks. lorenzo
Internet explorer problems????
Hi, My users are having problems since january 2010. Problems: - when submiting they dont receive the confirmation message and the internet explorer opens an pop up suggesting to download .do file... - the data field is not opening, they have to write instead of using the calendar pop up I use a mac os with safari, and I dont have problems is it a internet explorer problem?? Please fix it to me.... thanks
Is there any way to link Zoho Creator & Zoho Invoice?
I am trying to come up with a better system of collecting purchase orders and book orders from retailers that we work with. It would be great if I could create an application with fields necessary to placing the order and have that translate into the invoice ability. Is it possible to link a Creator app to Invoice, so that I can invoice each entry as it is entered in? Thank you! Ashley Ainley
Does insert command fail to execute if null values are encountered ?
Hi Team, I have a Parent From with foll fields Exec Name Designation Company Name (Drop down with list of existing companies from company master populated at runtime + "-Not in list- " Address City State Website When CompanyName = "-Not in list- "is selected, a text box is shown to the end user to enter the company name Other details are filled.. and form submit. On Form submit, I have Insert command for if(CompanyName =="-Not in list-") { [ insert into CompanyMaster Company Name = input.companynametextbox
Next Page