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
Add data to a view using Custom Actions without having to select a record
Hi, I need to load data in a view using custom actions. So for that i don't have to select any record. Is there any workaround to achieve this??? Thanks
Mapping DNS for Custom URL
Hello, I have set up my domain account, created my custom sub-domain, and tried to map my DNS. My domain is hosted by Bluehost and this is how I attempted to map the DNS. Let me know if this is wrong: 1. Went into DNS zone editor. 2. Added DNS record: Host Record: mysubdomain.mydomain.com Type: CNAME Points To: customer-creator.zoho.com 3. Waited 24 hours and tried to go to mysubdomain.mydomain.com, but it only brought me to mydomain.com. Am I doing something wrong?
Problem with fetch
I have an employee database and puting in employee information in another form. So obviously i am looking to autopoulate ID field automatically when a name is selected from a dropdown. So after watching a few fetch and set variables tutorials i am still unable to find out what the problem is with my form. I am unable to give the condition employee name==input.employeename because employee name is in numeric field. I am not sure why this is the case because it is a string field. Please help. It
Translate formulas from Excel to Zoho
So I have this excel file with some formulas. I was wondering if there is a way to translate them into Zoho. Not really sure if they will be a calculated fields or a script...I'm guessing a script. Formula 1 - Cuts text at character 80. If string exceeds 80 characters it is cut. Excel: LEFT(IF(A1),80) Formula 2 - Combine two fields into one. Text Field and Numeric Field. Excel: "TEXTFIELD1"&A1 Example: TEXTFIELD1 = Forum A1 = 13 Result: Forum13 Thank you for any suggestions. I really like Zoho. Mike
Saving & recalling MAP variables
Is there any way by which a map variable defined at any stage of form can be saved and later recalled for use ? For example on load a map variable is created and saved. The same map variable is recalled in form when other function such as submit or any custom button script is evoked.
Zoho.currenttime 1 more day??
How to use zoho.currenttime 1 more day to a field in the form? Thank you! ------------------------------------------------------------------------------------------------------------------------------------------- Solved! Used as follows: data_fim = (zoho.currenttime + '0W:1D:0H:0M:0S') It worked perfectly. Thanks to all!
API Name for subform rows
Hi From where do we get to know the API names for the fields of different rows in a subform. For example, if there is a subform called "Items" and it has fields "Item Name", "Item Price" and "Quantity", how can i assign the input value of these fields to CRM fields? For example: I have fields in CRM as "Item Name 1", "Item Price 1" and "Quantity 1, "Item Name 2", "Item Price 2" and "Quantity 2", "Item Name 3", "Item Price 3" and "Quantity 3", "Item Name 4", "Item Price 4" and "Quantity 4"? How
captcha/verification code not working - Firefox & Safari
Hello - I'm testing a form I created and embedded into my webpage using the following browser applications: Firefox 3.0.7 Safari 3.2.1 On neither one am I able to successfully submit a form because the form returns the message "Please enter the correct verification code." I can't find a resolution to these problems on your forum. Please reply with a current solution. The verification code capability is the reason I chose your service.
Creator timeout
I asked this a while back have had no reply. Come on folks, it can't be that hard! I just need to know how long it is before Zoho Creator logs you out or drops the connection, if you load a form and then wanter away for a cup of coffee. Is it half an hour? Ten minutes? More importantly, can this setting be tweaked anywhere? I have some people that need to run training courses, and the last thing we want is for the system to time-out before the clients click Okay!
Next Page