Cannot remove records from linked application
To help simplify the structure of my complicated application, I created a separate External Application to deal with a particular section. In the Main Application I used Sections and Pages that contain the forms of the External Application. They show up nicely, and I can input information. I also constructed a page containing all the views related to the external application to allow users to edit their entries. When I try to delete records from the External Application's database (via the Main
Calculating linked field
My application contains a form that uses linked fields to input information into the database as follows: Field A | --------> If Field A = x then Field B = y | --------> If Field B = y then Field C = z Field C is a percentage field in the original form and when used inputs the correct value in the linked form. So the data is correct. However, when I perform a Deluge calculation with the value using the value from
Remove Null
So I am using html view and I am inserting record variables into the view using the insert expressions tool. The problem I am having is that the drop down menus that have no data/value saved in them are returning "null" instead of just a blank white field. If a field does not have data i simply want it to be blank, not say "null". The worlds null all over my screen looks horrible. Is there a way that the dropdown menus do no return null if there is no data? The text fields seem to be working
Encode URL Question
I am populating a string field on a form via an email with some text from another system. I am then using a URL to open another form and default this data on that form. This works great EXCEPT when there are line feeds or other non-allowed characters in the initial string feed (e.g &). I have tried to use the encodeUrl function, but instead of converting the spaces in the string field to %20 (as I would expect) they are being converted to "+" and passed to the new form this way. Am I doing this
Duplicate Application Error
I am not able to duplicate an application in creator. I press duplicate, and the system says duplicating for a minute or so, but then no duplicate is ever made or displayed in the application list. Please help this is an urgent problem
Moving from easy database from Godaddy to Zoho
Hi there, I have been informed by godaddy that they are ceasing their support of the easy database system which I previously used. They recommended (on their website) that I re-start with Zoho. I am a bit of a novice with online databases but I was able to understand their system once I had a little assistance over the phone. I have looked online quite a lot to get some support on this however it seems that I cannot get through to their call centres which seem to be continually jammed and go to voicemail.
Add Buttons to non stateless form
I am requesting that you allow users to add Buttons on non stateless forms. At the moment it is not consistent because you can add them on stateless forms. I already have forms with complicated logic and I am not converting them to a stateless form. Can you please enable?
Issue with Sub-Form not linking properly
Hi there! I've created two views. Using this form: https://creator.zoho.com/reedmiller17/prisoner-profiles/#Page:Prisoner_Profiles Our volunteers can enter prisoner information, and then at the bottom, write a short letter to the prisoner. I have it set-up like a subform, so my expectation was that the prisoner's ID would show up in the Correspondence view: https://creator.zoho.com/reedmiller17/prisoner-correspondance/#View:Copy_of_Prisoner_Correspondance_View Similarly, under the Prisoner Profile
I need to link two forms together and make relationship!
I am needing to create a relationship between forms that will allow users to submit a form (embedded into website) that will populate data into another or have a view that can access both forms.
formatting strings in html reports
I couldn't find any built in function to format stings for currnecy For example a = 2.1; I want to display "$ 2.10" anything built in already for things like this? Has anyone wrong a function to do this already?
One entry per user / Date
Hi All , i have 15 fields , one of the fields has a Name Section and the other date , like the following: Name: Date: .. .. . i want to prevent double entries only when Name and Date are double. e.g. Name Date John 12-05-2013 John 13-05-2013 John 12-05-2013 this should be prevented thank you
I need help on a simple lookup problem
I do not know anything about coding so I am hoping there is an app or simple directions to do what I want to do. I just want to create an appointment process. I would like a form that I can add available appointments and a form that my student would use to select the appointment but once selected it would no longer be available for anyone else to select. Josh
Is this possible?
Hi all Would it be possible to call a creator form in the leads view ? What i would like to achieve is from with in the leads view call and calculate some values and the update the given fields without of having to call the creator form and searching for the lead and then submitting the creator form
SQL Querying between reports/views/tables on Zoho Creator
Hi Zoho! I would like to suggest integrating also the Query Tables from Zoho Reports into the Zoho Creator. I find it hard to produce an output whenever I use the "Lookup" fields in Zoho Creator. It just loads the Row ID without it's equivalent rows like description, etc. Customer Name is automatically loaded upon entering this form, but upon saving, I save the ID as reference. But when I create a report using this table/view, the Customer table is not included in the columns (Pivot table) unlike
Dropdown - filtering values conflicts with preset values
I have a form with a CUSTOMER dropdown lookup field and a SITE dropdown lookup field. The SITE lookup shows the SITE ID, SITE NAME and SITE ADDRESS. The SITE field has criteria CUSTOMER_ID == input.CUSTOMER_ID I have preset the form to the most common customer using the on load script. CUSTOMER_ID.Select("INT"); However,when I load the page, the SITE dropdown is empty even though CUSTOMER "INT" has SITES. If I change the CUSTOMER, then the SITE dropdown gets populated correctly. If I change back
How can I add a next button?
Hello! I want to add a new button which opens a form. How can I do it? Thank you
Script doesn't work in edit mode
Hi, I have an issue with the edit mode of a form. My form is loaded with a lot of scripts, both configured "on add" AND "on edit". It works fine, except in one case. I created a view to allow some people without login to edit some records. It's a search form, that opens a view with selected records through a "non login" link. In this view, users are allowed to edit records. The problem is there: in this specific case, the scripts doesn't work... Has anyone an idea ? Regards.
Zoho Creatot in Spanish, French, Chinese, Russian...
Hi, I need to translate our Zoho application to be used in Spanish, French, Chinese, Russian Languages... Any suggestions? There are actually 2 issues. One is the Zoho creator tools like sort, summary view, print, search, etc that are part of Zoho functionality that need to be translated and then there are the actual form fields and database that needs to be available in different options.
Can the user add additional fields as needed?
Hey all, What I would like to do is allow for multiples of select fields such as email adresses and phone numbers if needed. For example if someone has multiple email addresses you could fill in the first one then add an additional email address. It would be great if they could name the email with a tag of sorts like home, work etc. Is there a way to accomplish this? Thanks
Zoho is automatically guessing my domain name
I own multiple domains because I run a number of websites. One domain is attached to the email I used to sign up with and Zoho Creator seems to think I want to use that domain name for this account. Wrong! I want to use another domain name. I see no place to change the domain that you want to set up with the account. Help! Thank you!
Copy forms into another app
How do you copy a form or a section from one app into another app under the same account? Thanks, Antoine
URL Encoding Error
I am populating a string field on a form via an email with some text from another system. I am then using a URL to open another form and default this data on that form. This works great EXCEPT when there are line feeds or other non-allowed characters in the initial string feed (e.g &). I have tried to use the encodeUrl function, but instead of converting the spaces in the string field to %20 (as I would expect) they are being converted to "+" and passed to the new form this way. Am I doing this
How to make a condition in zoho creator
How to create a condition for example I create a checklist field and then when I select no nothing will happen but when I am going to select the Yes button I want to display below the checklist which is a single line "How many" and in that i can be able to put a number on that. Please help me.. or contact me in skype i need an answer skype: srepoyo
UpperCase all text
My client wants all data in zoho to be stored in upper case. What is the easiest way to do this? There is already data in mixed case and there are over 30 forms.
Edit Subforms: Does not save data properly
I have a CUSTOMER form with a PROJECT subform. When I go to my CUSTOMER View and Edit customer 123, I see 2 project rows. The first row should contain agreement 12 & the second row should contain agreement 22. After I change the agreement value and click update, I go to the view PROJECT rows but it did not save properly. However, the PROJECT agreement for 1 row is blank and the other is correct. Before I submit Update: (Expected) After I click Update: (actual) Why is the data not saving properly?
Extracting Account Name from CRM Contact Records in Creator
I'm building a Creator application where customers submit a monthly status report. I'm provisioning a representative at each customer as a Creator user, using the email address that is in that representative's CRM Contact record. Then that representative will log in to my Creator application after each month ends to submit a report. When a representative logs in to Creator, I retrieve the login email. Then I want to look up all CRM Contact records with that email, retrieve the Account Name for
Need a quick help - on delete row
Hi All, I have a form Packing List. In Packing List there is a SubForm "Block Packing List". When i select some item in "Block Packing List" and Submit, that item exists in the other form "List of Items" changes to 'Packaged' Status. When i delete some row in "Block Packing List" i'm changing back that item to 'Available' Status. Everything is fine upto here. Now the Problem is when i delete some row and do a cancel, that item changes to 'Available' Status and that row remains same in "Block
Facebook Connect Only Login
Hi, is it possible to allow users to login exclusively with facbook connect and not show the other federated logins ? (yahoo, google etc) thanks
Null error when saving html view
I have a html view called GLOBAL_SEARCH which I want to modify. I have tried adding in new code and I get a "null" message when I try to save my changes. As a test, I refreshed the page and made no changes to the script. When I clicked Save Script, I still get the "null" error. Why can't I save any changes?
Help with input data field- can you show a link to current entry?
Hi everyone, I know it is possible with input data fields to 'show a link to add new entries' Is it possible to show a link to current entry? So once you have dropped down to an entry in the field, a link shows allowing you to click on it and edit/ update the information? Thank you! Rachel
Open URL problem for Edit
In the Workfolw application i am using an OpenUrl for form edit like: Urlstr = "#Form:Job?recLinkID=" + input.RecID + "&viewLinkName=Inbox&zc_LoadIn=dialog"; openUrl(Urlstr, "same window"); It is working perfect when logged in as admin user and owner, but if i share the application with another user the Job form is not opened, but instead the first TAB /Dashboard in the application. The openUrl call is done in the function Forward. Application is Workflow, and it is open for support. Dan Andersen
Finding Records with an ID in a longlist field
Hi, Form A contains a multiselect lookup of the IDs of Form B. I have the ID of a FormB record and I wish to find all the Form A records that are associated. records = FormA [ ?? ]; Thanks,
Criteria for Lookup Field - Non-Consistent Results
I have a FORM called People, and consider it to have only two fields : NAME COMPANY Second form is 'CATEGORY' with two fields COMPANY CATEGORY NAME I have another FORM called 'Request', with the following Fields NAME - Lookup from form 'People' COMPANY - Single Line CATEGORY - Lookup from 'CATEGORY' using Criteria Category.Company=input.Company Request Detail - Multi Line I have some deluge script on 'User Input' for the FORM 'Request' whereby, I get the 'PEOPLE' record corresponding to the name
Time and Budget management- advanced lookup
So i have created an app in Zoho. It currently has 3 FORMS which are : Timecards, Employee Database, Phase Code Database The fields are : 1. Date 2. Project Name 3. Employee Name 4. Employee ID ( Should Autopopoulate from Employee Database) 5.Employee Trade ( Should Populate from the Employee Database) 6. Phase Code (dropdown from phase code database) I have gone through many forums but it just seems i am not able to get that simple autopopulate right. please advise on that. Also my eventual use
Carriage Returns without XSS security set to low
Hi all I have looked through previous posts to find out how to insert a 'carriage return' in a multiline text field using script and have tried using "<br>" and "/n" however to do this you have to set XSS security set to 'Low'. However I belive that it is now longer possible to do this. Has anybody else come across this and know how to achive this. Script below takes each record and adds two fields seperated by a hyphen to a string then adds the string to the mutiline text field followed by
This is how to display user messages from within functions
I found a useful way to display error messages to users from within functions. This seems to work in all uses of functions except in perma views. 1. Set up a form to store the messages: #Message_Number (Number field) #Message (Rich Text field) 2. Create a view for these messages and call it User_Message 3. Create records for each message you plan to use in your application. 4. Create this function (remember the 'void misc.display_message......' may have to be changed depending where you
Field types don't match?
Hi, I am trying to write a function that will go through a set of records and sum a given field (Field B) if criteria for another field is met (Field A). So if Field A = "Yes" then add Field B to a sum. Below is a function I use to sum all the values in Field B (Man_Months in this case): float TotalJobsCon() { countMonths = 0.0; for each r in JobCreationSchedule [Man_Months != 0] { countMonths = (countMonths + r.Man_Months); } return countMonths; }This works perfectly
create link for downloading
I am uploading a file as an administrator, and trying to share this file with a non-administrator, ideally without necessitating a login. I have found the link, and instructions on how to create it (thought haven't actually successfully used deluge to generated this link). However, when I try to follow this link (by using 'inspect element' in Chrome) I receive an error message: You have logged in as AdministrativeAcct. You are not allowed to access this view. Please click here to login as a different
creating a Link to the website created in Zoho.
Hi, I have a website created in Zoho. I would like to create a link in another website to which it will redirect the user to the Zoho website - to login and access it. So how do do you embed the link? Regards Shavendra
Avoid deleting
I have a form (Cuentas) with a subform in it (Actividades). I want users not to delete any record created in the subform, not just in the vires, i want to avoid deleting when editing the parent form. https://creator.zoho.com/pestrin/amd/#Form:Cuentas (allow support login) Any idea? thanks
Next Page