How To Add Product Details into Invoice Section Of Zoho CRM using Map() ?
Hi, I am currently adding the data from zoho creator to the invoices section of zoho crm. I using the following process shown in the url below, https://kbase.creator.zoho.com/crm/push-to-zoho-crm I could able to store the data related to the Invoices like Account Name,Subject.But i am not able to add data to the Product Details Section of Invoice.I want the "Product Name","Qty","List Price" to be stored along with the invoice data. Below is the script i have written for mapping from zoho creator
Passing List Value as a parameter to HTML view
Hi, Is it possible to pass a list() as a parameter to a HTML view? If yes, please tell me how. Thanks for your help. V
predefined path in URL export of CSV
I have a form in which on submit i export a CSV file containing all the data for that entry, which is driven by the URL. I wanted to know if there was anyway i could predefine the path in which the csv is downloaded to. There is only going to be a single user of this form, so the path should already remain the same. Thank you
How to Send Email's Seperately for every user record using a Scheduler?
Hi, I am using schedulers which will send an email upon a given date in my application.The To Address is having the admin address and i am getting those mails. Is it possible to have the email sent to the the email address field associated with that record? Please let me know whether there is a solution for this.
Modeling a Budget Sheet
Is there any advice available on modeling a two dimensional budget sheet? I am planning a sort of bid and budget management platform for jobs. Here is an example created in Excel: The items in column A will be anywhere from 100-200 items and are NOT set by designer/contractor but by my company. Designers will be able to edit column B. Contractors will be able to edit column C and D. Administrators will be able to edit A, E, and F. I would like to emulate this look in both the form and the view. Is
Embed google gadgets in HTML view
I want to embed google gadgets like clock , calender etc in HTML View. How can I do it
lookup questions
Hello I've got a couple of questions about lookups 1) There appears to be a limitation about lookups if the field being searched on has a " in it. I am getting an error stating invalid entries found when trying to add a record. I have removed them and its all ok but can't see anything which states whether or not this is a limitation or whether there is something else. 2) I also have a number of lookups in my application forms and and created an number of views for the users to see the data included.
Problem with the Dropdown Show choices in alphabetical order
Hello, I am having a problem (may be a bug), where I have created a dropdown that onLoad gets all the account names from the CRM, I have checked off the checkbox that says "Show choices in alphabetical order", but it is not alphabetizing them. Is there a way to fix this please? Thank you for your time.
Can't find the error...
Here is my code following a tutorial on the forums about mapping variables. I have followed line through line of the code and am getting an error with the "void" function. In the script editor, the error reads: "Encountered "void" at line 17, column 1., Was expecting one of:"if" ..."for" ..."delete" ..."insert" ... "inserthtml" ..."share" ..."unshare" ..."%>" ... fields=getFieldNames(); form_map=map(); for each field in fields { value=getFieldValue(field); form_map.put(field,value); } void
ZC Mobile - HTML view
Hi guys, Am new to ZC. Is it possible to set 'native' views and forms to be visible to mobile only, while the desktop user will see only HTML views? Appreciate your prompt comments, Gidday Idan
combining string records
I have two string records, "first name" and "last name", and I want to group them together to make a single "full name" string. How can I do this? I've tried assigning variable, but it doesn't seem to work.
Edit Permissions Only visable fields hides note fields
Minor problem. In a view when the Only visible fields option is selected in the set permissions section note fields are also hidden. These fields should always be shown. They do not contain data but are used to help the users fill out the form.
Over Limit notification for Developer
Two of my clients had problems with their applications last month because they had gone over limits. One hit the limits of records in their account. The other had executed more than the allotted schedules. I assume an email was sent to the application owner when they neared their limits. Can you also send a notification to the email address listed as the developer on the Applications Settings page? Herb Wexler
Summing days to a date field
Hi, how I want to send a email if the present day is due 10 days from the "Data_de_Registo" when the form was inserted, the problem is I can´t define the 10 days here, as it gives me the next error. The Left expression is of type TIMESTAMP and the right expression is of type BIGINT and the operator + is not valid here if( Estado == "Avaliação") { if( zoho.currentdate >= (Data_de_Registo + 10:00:00)) . How can I develop this? { sendmail [ from:zoho.adminuserid to:"xxxxxxx@xxx.pt"
Deleting record from lookup fails to save selection
I'm trying to use uses a form "choice_remaining" to present users with a list of items (Say a list of cakes for a pot luck) I've setup a form called sign_up that lets them write their name and using a lookup field pick an item from the list. As each submit record makes a selection, I want to remove their choice from the list of possibilites. Eventually the lookup would be empty. All this works well except the selection from the lookup field (input.Selection) is never saved in the sign_up
Select/Deselect use
If I understand correctly, Select/Deselect of multiselect fields (including linked multiselect) can only be used in the script section of the OnLoad and OnEdit of the form. If that is true, how can a record be modified via script from a custom action button, for example? If that is not true, what is the syntax for its use? Can anyone provide a sample code?
service outage
Zoho Creator is currently not responding (our internet connection is working fine). Please advise ASAP.
Unable To Delete Data From CRM Invoice ( Enterprise Edition)
Hi, I am presently storing some data in ZOHO CRM Invoice (Enterprise Trail Edition). Data is getting adding correctly but when i am unable to delete records.it is just showing a blank page after clicking on delete button. Is this due to a problem in zoho. Please resolve this problem.
Display Count Data in a Table
Hello, Sort of a newbie here, so pardon me if this is a bit simple. I know a little html, but not so much with deluge syntax. I work at a school and I am trying to display the number of the student laptops and the number of teacher laptops that exist in my building in an HTML view. One of the fields in the form is "Type" and the two choices are "Teacher" and "Student". I need to count the # of laptops marked as each choice. I am trying to display a table with this data (two columns, three rows -
Need a permalink to an unfiltered view
In the course of working with our application, we are constantly applying different filters to data in our views. With the recent UI changes, I find it's now a two-step process to see an unfiltered view. Whenever I click on the link to the view (https://creator.zoho.com/username/application/#View:MyView), I see the data limited by the last filter I applied, with the message Displaying Filtered Records. Show all Records This is very frustrating and slows down my workflow considerably, because I
Embedding application script to my website
Is it possible to embed a copy of my application on to my website so my employees and customers can access it via web browser?
Disallow entry into database if payment not received in Paypal
Hi, I am working on a form database that will allow the user to fill out a form and then pay for the inclusive of this information via Paypal. Everything works fine except that even if you back out of submitting the Paypal payment, the information entered on the form still is added to my database. I think it must be easy to fix this, but for now I can't figure it out. Thanks, Rich Baxter
Corrupt form?
Dear Zoho Team I have only one form in one of my applications. When I open an existing record, the onLoad script does not fire. When I add a new one it does. Furthermore, if I add a Notes field to the form, it is only visible when adding new records but not when opening existing ones. Please advise. Regards, Filip PS: the app in question is dsm; edit access is granted
dialer
additional assistance requested Hi, You can create a formula field and place the call link of the Phone as "<a href='callto://" + input.Phone + "'>" + input.Phone + "</a>" Ruben Zoho Creator Support 0 Best answer Comment gorlando5 Re: dialer 1 day ago thanks ruben, i just created a form and view and it does create the call to but nothing happens when i click on it. how to link up to dialer? thanks
Edit records using Stateless Forms
Could someone point me to where I can find out how I can use a stateless form to edit a record? I feel that this must be such common requirement in most applications that there will already be some documentation on line, but I haven't spotted it yet. What I envisage is that once the form is open there would be a way to launch a script (a button On Click?) that will fetch data from a record and populate the stateless form. And then, of course, when you 'Submit' it needs to update the existng
If then script
Hello. I am trying to figure out the Deluge Script in Zoho Creator. The result I am trying to generate is this: Through inputting, these variables are defined. vs (this is a percentage) Week_Gross (this is a decimal generated through a formula by adding several previously inputted numbers) Guarantee (this is an integer) In plain speak, the result I want is If vs * Week_Gross is greater than Guarantee, then output vs * Week_Gross, otherwise output Guarantee. I have generated the following
new calendar view - drag and drop - time zone problem
When an event is dragged and dropped or when the duration handle is moved the edited record jumps to the wrong date/time - apparently because the feature does not adhere to the application's time zone setting.
Setting Permissions
Hello, I am working in ZoHo and I have a Permissions question. Basically, is it possible to control the permissions of each user based on what I need them to be able to do? For example, I have an "Application" form, and I want to allow my HR department to be able to accept and reject applicants using the appropriate drop down fields, which I, as an administrator, have hidden. Currently, I am the only one who can accept or reject these applicants. Does anyone know how I can
Creator added auto-filter on pre-existing applications automatically
As of yesterday I went back to check some pre-existing applications and noticed that auto-filters were applied randomly (and automatically with-out my input) to my various applications. On top of that some of the views will not show up and I get the following error [ServletException in:/jsp/edit/view/viewedit.jsp] null' Please look into this problem and get back to me Thanks
Pulling information from two forms
Is there any way I can have a report that pulls information from two forms? If not, how can I auto-populate a field in one form with information from another form in the same app? I tried to use the instructions here: https://kbase.creator.zoho.com/records/populate-one-form-with-data-from-another-form, but it did not work for me.
Styles for Embedded Forms: IE issue with blockquote CSS
In Internet Explorer, the blockquote shown below is white. In Chrome, it takes the color of the form. Can this be fixed? I'm using style url attributes to control the appearance of these i-framed forms (ref). Cheers, John Whitney
Popup window reported a bug
Hello Zoho Support team and Developers, I am added a problem here which i am encounter in my application, i am add many clickable icons or links in my HTML view and all of them are opened in popup window. now the popup window encountered a problem. when i am click on the clickable link i am see a popup window appear now i am close the popup window by click on cross icon on the popup window. as i click on the cross icon of popup window the popup window is disappeared, now when i am again click on
Add Data by Email Issues
Shared to support https://creator.zoho.com/buzzap/form/209/edit/ I have a custom gmail account authorized to forward email to the form linked above. It worked a couple times but now it's not. Cheers, John Whitney
convert xml response (from ZohoCRM) to simple “key=value” pairs (for SurveyGizmo) using php or Zoho Creator
Hi there, This deals with exchanging data between CRM & Gizmo. I'd like to Creator (or php) to convert the response. SurveyGizmo posts (insert) data to ZohoCRM. After insert, Zoho responds with xml that includes an ID of the inserted record. Gizmo needs that ID for subsequent updates. The problem is, Gizmo will only accept a response in a simple "key1=value1,key2=value2" format.I'd like to have ZohoCreator receive Gizmo's post, pass it through to ZohoCRM, receive the xml response from ZohoCRM,
HTML VIEW
Hi, I want to embed 3-4 views on a single HTML view and I want to set criteria to each view by passing a parameter via a form embedded on the same HTML view. Example: On the form, there will be a drop down to select a name from the list. This selected name should be used as an criteria to show specific record on each of the embedded views. Can you please tell me how this can be done? Thanks! V
Add row to subform in other application
Hello! I'm new in ZC. I have Application 1 and Application 2 with subform. In Application 1 i have Lookup field wich show name of records from Appl. 2. I need to add new row in Appl.2 subform, when i chose data in Lookup field of Appl. 1 and save it. Row in Appl.2 subform contain some data from Appl.1 Can you show me example how to do this? I try to use bedirectional relationship in Lookup field wich add to Appl. 2 subform, but it not add new row to subform when i chose data in new record Appl.1,
Any man can do what they want in my database... (embedded view ) HELP!
Hello! I have a database. The database is private. I have put the address on my home page and clicking on the address the user enters the page, which needs to connect to database... (https://creator.zoho.com/ (My username) / (database name) / write-Permian / (My database name) _View /) Database viewer entering database with facebook.com account. Why he can add, delete and edit entries in my database? It is not normal! Any man can do what they want in my database... This is very
Create incremental Number in SUBFORM if requested by "radio field" in the same subform record
Hi We use a lot of incremental numbers around our application for various things, however, I haven't had much experience with placing them in subforms on success of the parent form. This is what I've tried to write so far, and it comes up with errors: if (input.SUBFORM_NAME.RADIO_FIELD == "Increment required") { x = MaxValueHolder [ID != 0]; input.SUBFORM_NAME.SUBFORM_FIELD = (x.highestval + 1); x.highestval = (x.highestval + 1); } ERROR: expects = on line 16 I'm sure its simple,
Creating a "Two Step" Form in ZOHO Creator
Is it possible to create a "two step" form in ZOHO Creator enabling a salesperson to "edit" a existing entry in a ZOHO Database/Table? Here is an example of what I need the form to do: STEP 1 | Enter the invoice number (ex.123456) in the "Invoice Number" field. Then click on the "Submit" button ---------------------------------------------------------------------- Sales Entry Form ---------------------------------------------------------------------- Invoice Number: _____123456______| ----------------------------------------------------------------------
Is there a good way to create random passwords
I'm trying to create random passwords for users, but there is no random function. Yes I can use input.var = zoho.currenttime.toLong() 00; to generate something similar based on time, but try running this serveral times rapidly to choose characters in a list and you'll get similar numbers. Just as a test I tried: random1 = (zoho.currenttime.toLong() % 1000); random2 = (zoho.currenttime.toLong() % 1000); random3 = (zoho.currenttime.toLong() % 1000); random4 = (zoho.currenttime.toLong()
Next Page