Sending XML in a form
Hi, I'm new to sending information to Zoho. I am testing a html page to update a Zoho form. Here is the form I'm using: <form method="POST" id ="foo" action="https://creator.zoho.com/api/xml/write" > <input type="hidden" name ="authtoken" value="my token"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <textarea name="XMLString" > <ZohoCreator> <applicationlist> <application name='App'> <formlist> <form name='Test'>
View not displaying correct value
Application: essistmgmt/assets Form: PRODUCT View: PRODUCT_View Field: PORTFOLIO I have a PRODUCT form with a PORTFOLIO_ID field. The PORTFOLIO_ID field is a lookup of the REF CODE form with criteria 'REF_TYPE == "PORTFOLIO"'. The Advanced Display Option is set to REF DISPLAY NAME When I view the REF_CODE View & filter on REF_TYPE == "PORTFOLIO", the only values I see are C CLOUD SERVICES D DATA SERVICES F FIELD SERVICES M MANAGED INFRASTRUCTURE SUPPORT SERVICES V VOICE SERVICES When I view the
Hiding subform formulas
I have a formula field LOGISTIC STATUS in my ASSET form. I have a form CONTRACTED ASSETS that contains the ASSET subform. I want to hide the formula fields from the subform in my CONTRACTED ASSETS form. Note, my requirement is that I want some forms to view the field and other forms to hide the formula. I do not want to turn it off for all forms. When I try the following code, I get an error. Note, I obtained the field name by viewing the form definition. How can I hide the subform formulas? hide
Sharing bug
I have a section that I want to keep private. For some reason, it has been made public. When I click on Make section private, nothing happens. Can you please investigate? The application is located at https://creator.zoho.com/essistmgmt/assets/share/edit/# is available for support edit access.
Report: 0 number of rows
View: https://creator.zoho.com/essistmgmt/assets/#View:CONTRACTED_ASSET_View Report: https://creator.zoho.com/essistmgmt/assets/#Report:test I have a view with 8 rows. I created a report based off the view and when I generate the report in the editor, I see results. However, when I view the report, there are 0 results. Can you please investigate? Note, the application has been shared with support.
Field Null Validation not working
Hi All, Here is my code: varLeadTime = ((input.Coaching_Start_Date - input.Entry_Date) / (1000 * 60 * 60 * 24)); if ((varLeadTime < 7) && (input.Why_now_Compelling_event_and_timelines_ == null)) { alert "This is less than 1 week notice. Please complete the 'Additional Information' section (Why Now?) to help us prioritize."; cancel submit; } Basically, it is a calculation of how many days notice someone provides for a request. If it is less than 7 days, the user must complete
Isolating date part of date / time variable
I have a date / time variable declared in a form. I am using it's data entry from a calendar view such that both date and time info is input to the variable which is called 'sched_time'. I want to show a grid view of today's records from the form called 'Case' and have attempted to use the criteria as below in the view script. show all rows from Case [sched_time == zoho.currentdate] This does not work and no records are ever shown using this format. I have tried to use combinations of some
Assign Task Code
I have a code which is put in the View Code/Script Editor of the form of the Contact. It creates a Task and puts in the TextBoxes of the Task form, the Values from the ComboBoxes or TextBoxes from the Contact that the Task is created from. So in the form of the Contact, there is the new CommandButton4 that when I click on in the Contact, it creates the Task and the brings the Values from the ComboBoxes or TextBoxes from the Contact that the Task is created from to the TextBoxes in the Task created.
Zoho Creator Deluge Script for Dummies ebook
I'll love to learn more about Zoho creator, I've looked at the manual and actually printed it out, but seems that is going to take some time to really become a pro on the subject. It could be great the create a dummies type manual or ebook with lots of examples about the Deluge Script. Also it could be great to have a dedicated Deluge Script Forum where experts and newbies like myself can meet. Please let me know when you have something available. Thanks, You guys are doing an excellent work. Ed
Invalid character set on confirmation email
I'm having an issue when submitting confirmation emails with a custom record summary. All "spanish characters" or characters typed using an spanish keyboard (such as : or - which are placed differently than the english keyboard) come with weird characters (as in "A4: Aviación" or "1:500") on the custom record summary I have set to be attached to the confirmation email. And that only for the values submitted using a subform, characters from labels and paragraphs look ok. So it looks
Using the API to access a Creator DB.
Hi. I and a coworker have spent quite a bit of time looking for info on this and haven't been able to find anything that works. Here's what we're trying to do. We signed up for the free ZOHO account. We created a DB using Creator. It consists of names and addresses. The only way we want to use ZOHO is as a front end for entering data into this DB, kinda like Access. We want to then use this DB to fuel other web pages. So, if I have an entry in this DB named "FirstName", I need an example of how
Adding Formula results in blank form page
I added this formula to my form: and it results in my form no longer loading:
Error creating reports
Application: https://creator.zoho.com/essistmgmt/assets/reports/new/ I get errors when I try and create a report. Can you please investigate? Note, the application is shared to support for editing.
"Data will be stored in Zoho Creator"?
When I caret new form in new Form Builder, last checkbox ask "Data will be stored in Zoho Creator". What it mean? Nothing happens if I uncheck or check this checkbox...
View filters bug
I have a view with 1649 records When I Search a column for "Is Empty", I get 1645 rows. However, when I save the view, I see 0 rows. Why does the view not show any records?
HTML page...can one view force a refresh of another view
Title speaks for itself. I have an HTML page with multiple views incorporated into it. If a record is changed in one view, can I force a refresh of another view?
Example of validating log in
Hello How can I use log in form to open specific page for user, I know there is using for in success and rest of script, but need example, Thanks ?
Email Notification Sent on specific date
Can i send email notification to user exactly the date he/she inputs in the date field when submitting the form? I need to make a reminder form to remind user to do something in organization. please advise.
Problem with getting SalesOrder ID BUG??
Hello I am trying to access Product Details in the Sales Order form and trying to do it through Sales Order ID. I put a Zoho CRM field on my form called SalesOrder Name and I was expecting to have a SalesOrder_Name_ID provided to me in the Deluge "Refer Fields" list but all I get is a field called Zoho_CRM_ID. So I tried it: crmresp = zoho.crm.getRecordById("SalesOrders", input.Zoho_CRM_ID); input.SO_ID = input.Zoho_CRM_ID; Nothing shows up in SO_ID field on my form. Can you help my understanding
Employees to access Lead From
Hi All, Currently we are developing Application in Zoho Creator with Free version. We have one form, through which we want all our employees, to enter Leads information. When i created a Lead form and share the form with all employee id (10 emps, with their email id), the Zoho Creator considers it as User. The employee should login with given username and password and then enter the lead information. Is there any way, we can retrict users in Zoho Creator, but give access to this functionality to
how to add my form in wordpress page
I am using wordpress.so i have this form, how do i put or add my form in my wordpress page?please
Grand Summary Formula Column
Hello. I want to put a formula in a summary row, and have no formula elsewhere. Specifically I want something that does this. See how the Three-Day Average Column has 350 in the "My Movie" Summary line, and is determined by dividing 3-Day Gross / Screens. I've tried everything I can figure out to try. I won't bore you with what I have tried. What works? Title Venue Three-Day Average Screens 3-Day Gross My Movie Astor Theatre 1 567 Average Theatre 1 133 My Movie 350 2 700 Grand Summary: 2 700
Currency Decimal on Edit
Hi, i put a currency field with 2 decimals, like 0.00 When i am in the report, and edit the value of the field, like 8.45 it will not update, but if i edit and fill with 8.00, it will update. There is a problem with updating fields with currency type?
Live updates to a form
Hello, I am creating a form for our team members to access. I was just curious if one of our team members updates something in the form will it update live to the other members in the form at the same time? I tried testing it but relaized it will only show the update if you refresh the browser page. Thanks, Darren
Can't edit Message field when setting up a "send mail" function
Setting up a "send mail" function on a form, I click Edit to edit the From, To, Subject, and Message. I can edit the first 3 fields fine, but cannot edit the Message field. Clicking on the text box does not show the "xxx Mode" tabs and does not allow changing of the text. This happens to be for the Form Action "On Edit" | "On Success". I did just now try the Free Flowing Script option, and that does allow me to change the script, so that is a work-around. So this problem is just in the Script Builder.
Lookup Setfilter based on another field on the form
Hello, I came across your tool just today. Seems interesting but i would expect a lot of improvments before i spend money to buy it. Please help me with this situation. I have 2 field for names on the form. I get to choose a name from the lookup of Names for the first field. For the second one i will want the same look up minus the name on the field field. 1) My thoughts. I should be able to filter it out 2) I should be able to create a list after the first name is entered ( Everything
What are some options for other Custom Reports
I want to be able to use data from my Zoho Creator database to generate custom reports that are formatted in a particular way that is not supported in the reports feature of Zoho Creator. Does anyone know of some other options for creating custom reports with the data from Zoho Creator? For example, is there a way to link to data in Zoho Creator from Microsoft Access so that you can use Microsoft Access's reporting features? Or is there an on-line report generating tool that can pull data from
insert/add a record
How can I add a new record to a 2nd form when using deluge scripting When I add a record to table 1 (detailed data not suitable for display) , I want to add a record to Table 2 (presentation information). ramona
warehouse development
Hi guys, nice to meet you. I'm finishing the development of a company application to manage our warehouse. To create a selected list for product, i've arranged following script: lisart = List:Int(); for each y in magazzinos [(((stock_colli > 0 && deposito == doc.deposito2) && data_scadenza_lotto >= zoho.currentdate) && (protocollo_magazzino is not null))] sort by articolo { if (!lisart.contains(y.articolo)) { lisart.add(y.articolo); } } The problem is that "magazzinos" table
I want to map all CRM Leads into an Array in Deluge
I want to map all CRM Leads into an Array in Deluge so that I can access each record (lead) in a FOR loop. Any suggestions? Looks like so far I can only get records by ID.
Access to report - User specific.
Hi All, We are developing our CRM using Zoho Creator. We are basically Pharma company. We have created a form called "Leads". This forms as all required fields along with MR Number. All Medical Representatives (MRs) should log into system and enter Leads information. The Drop down menu in Leads form will show MR number, so that they can choose his/her ID while submitting Leads information. Later Business user can see, who has submitted how many Leads on a given day/week etc.,.. The Issue is with
Currency Symbol in Reports
Hi Sorry if this is a silly question - I am a newbie user. I have created currency fields in my database to be shown as GBP. The £ symbol shows fine in Forms but default sback to $ (USD) in reports, Is this a bug or sonething I am doing wrong? Many thanks Mike
creating application
i'm making an inventory system.. is it correct to make separate one application for the entries/forms database, and another application for the reports?
Simple Currency Related Formula Not Working
I seem to be missing something with currency related formulas - I'm trying to do the following: "input.Assessed_Land + input.Assessed_Structure" Both fields are currency - it gives me the following error: "com.adventnet.ds.query.QueryConstructionException: Datatype [CHAR] of the column [t_693811000000018081.Formula_693811000000025013] can " The error is cut off in the window - I cannot see the rest. What am I missing? Thx
Merge 2 fields
I have two basic forms .... one one (Contacts) I have the basic Contact Info and on the second (Opp's) I have the opportunities that have been identified for each contact. On the Contact Form are two fields ... First Name and Surname ... on the Opp's form I have a look-up to pull in the business name from the Contact form. Is it possible, and if yes, how do can I based on selecting a business from the Contact form pull in and merge the First Name and Surname from the Contact to the Opp's form.
Creator App Duplication Failed
Hi Zoho Teams, We are a IT consultancy team and zoho creator paid users. We aim to promote zoho to our local SME as it's a wonderful tool. This is our app: https://creator.zoho.com/luyiheng/ucdemo It's a demo for our client. However, when we want to deploy this to our client, we could NOT DUPLICATE this app. After click "duplicate", nothing happens. Also, we could NOT EXPORT this app. Please Help! Thank you very much! Best, Yiheng
Is it posible get data from IMDB to creat a Zoho creator database?
Hi everybody: I am a new member of Zoho comunity. I would like to create a database for my movies and wondering if there is any way to automatically extract data from imdb to complete my own database. Another way of asking the question is: Can I create a script that extracts data from IMDB to complete my own database?. Thank you very much.
Access Request/Zoho Privacy Policy
When accessed using the URL http://creator.zoho.com/[USERNAME]/[APPNAME], the user is not presented with an warning. But then, we've converted the primary account to a domain account, added a sub-domain to point to ZC. So when I use the URL http://[MYSUBDOMAIN].[MYDOMAIN].COM/[USERNAME]/[APPNAME], the user is presented with a warning that reads like below: --- By clicking 'Grant Access', you give Zoho permission to enable [MYSUBDOMAIN].[MYDOMAIN].COM to access all your user data available with Zoho
Can I make a app in Zoho Creator for my database in Zoho Reports???
I want a quick way to make apps for my database that I have created in Zoho Reports. Would like to use Zoho Creator, but cant see anyway of doing it?
Tips on how to embed a mp3 player for a uploaded file
Hi, I'd want to embed a mp3 player in a HTML view based on a Upload file. I've tried couple things (simple and complicated) without success. Anyone has a tip on that ? Thanks, Pascal
Next Page