Sent mail with the content of Lookup field
I have this code to the sendmail the value from the lookup field: TorneosForm = Torneos_Form [ID == input.Torneos_MDE]; ContactosForm = Contactos_Form [ID == input.Nombre_Arbitros2]; sendmail ( To : input.Correo_Electronico From : zoho.loginuserid Subject : "Cambios en la Asignacion" Message : <%=TorneosForm.Torneos_MDE%> ) Receives this error : Error at line number : 6 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Pass Custom action Form Object selected records to html view for loop?
I have a custom action that executes for a collection of records. (ie, I select several records in a view and execute the custom action.) This uses a form object with record ID's. My function is as follows and it opens an HTML View: void Shipping.Order_Batch(Purchase_Request_Form ID, int Order_Number) { openUrl("#View:Order_Batch_HTML&ID=" + ID + "&Order_Number=" + input.Order_Number, "popup window"); } I want to pass the list of record ID's into the Html view and use the selected records as
How to import data into a page
I want to use zoho to fill out a contract automatically if we choose a customer (name,e-mail,address.etc.). I made the contract as a page. I've added the contract text with INSERT HTML, but I don't know how to add expressions from a form. (I made a stateless form to choose the client and I've added this to the contract page). Can I get some help,please ? :)
Details on the working ?
Hi, I am very new to the Zoho, so I came across many doubts in the same, 1) Whats an application ? with the forms created in application how can I gather data from my customers ? 2) Can I create a single form with 135 fields ( 25 Dropdowns, 70 text, 20 Checkbox, 20 Date ) in one form ? 3) If not how can I do it with multiple forms ? 4) Ho can i implement the multiple form application to get data, if single form is used we can embed it to some of the web page and get data, in case of multiple form
Upon Duplicate - open the Edit form for the new record
When duplicating a record, the user has a very hard time knowing which one is the new duplicate, making it too easy to continue from there with the *original* record, assuming it is the new duplicate. Also: I'm able to duplicate a record multiple times where there is a name field that is both mandatory and unique. The records sit in the list with a blank name! Yet the UI would never have allowed their posting. To improve this: Upon Duplicate: always open the new record for Edit. Or at least
Add person capable of making changes
I want to add a person who will have the capability of making changes to the database, while keeping the general public only able to view and print. Did it once, but can't find that section of Creator now. I want that person to have same ability to change as I do.
Update records using Function
Hi, I am trying to create a function that will update the respective fields when it meets the respective criteria . see below form screenshot , there you can see the Coverage-01 and Coverage-02 are blank. I want to input "Full" in the coverage fields if respective MVPD fields is not null. like - for station : TV1 , the MVPD-01 is not blank so Coverage-01 field should be updated by "Full" but Coverage-02 should be blank since MVPD-02 is blank. I was trying to use below Script but not working **********************************************
Ingreso de fecha desde zoho creator app iphone, (error en formato)
Desarrolle una forma para ingresar información, en donde el dato de fecha es importante, no permite el registro desde la app de zoho creator en el iphone, inicialmente se capturaba sin problemas, ahora esta generando este error con varios usuarios.
other not working in drop down
Hi, I have added the other option for some of the drop down fields in the form. They all show in the report view except in the case of 'spread sheet view' but while I export the data none of them are shown in the exported data. Am I missing something ?.
'clear' can be used only in on load actions (deluge error message)
But In the following page: https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html you say: Example Below is an example code that can be specified in the On User Input action of a subform picklist field. list = Product [Category == row.Category] sort by Product_Code ; clear row.Items; row.Items:UI.append(itemlist.Product_Code.getall())
pdf page 2 print view won't print
In the Zoho creator program we made, we recently added a second page to our print view, but it won't print. Now says loading on page one and will not download page two to print. Zoho support was unable to fix this issue and i am extremely frustrated. Any advice would be greatly appreciated.
Page with embedded form requesting login but shouldn't...any workaround?
Hi All, I have a form embedded in a page using the script builder embed form gizmo: <div style='border:2px solid rgb(125,186,0); margin:4px;' elName='zc-component' formLinkName='DataEntry' params='zc_Header=false&zc_SubmitVal=Next&zc_ResetVal=Reset'>Loading Form...</div> Accessing the page via its permalink, I am asked to log in in order to see the contents of the form. How do I get the form in there without login request? Do I have to scrap the Embed format and insert the public access
Finding out the logged in user's role and/or profile from within Deluge Script
is there any easy way to determine the role and/or profile of a user that is currently logged in, in a similar manner as we can find the zoho.loginuserid - can the role and profile of the user be retrieved in deluge script at all ? thanks in advance, Jennine
Form Actions > Validate > Uploded File Missing
Hello, Since I cannot set hidden filelds as Mandatory, the only option I have is to "Notify on Validation". How can i write this on the Workflow? I need to write that: if field1 is "Yes" then field2 must contain an uploaded file how do i write this? Thanks, Tor Vergata University
Adjust editing in report
Hello, Can I change the order of the edit options in a report: Edit Delete Duplicate Print View record See attachments for a print screen. Greatings, Erwin
Unblock outgoing mail please
Please can you unblock outgoing mail for account questionario@bcc8453.it ?
choose first 4 characters in a string
How do I choose first 4 characters in a string please
Column Menu hide help
Hi On a file view there is a menu that has Sort Group and Hide Column When in the view I hide 3 columns that I don't want to see in the view but want access to when I edit the record. When that page is refreshed the view unhides itself. How can I set it so a column hides perminately. Thanks
ZOHO SMTP Servers
My application's emails are being blocked by our email filtering service. My IT department wants to know what IP address or range to add as a filtering exception to allow email from Zoho's SMTP servers. So far, the only one I can see from email headers is 72.5.230.66 and 72.5.230.67 Are there any others?
addMonth Built-In function in a formula field return an error message in the form
Bonjour and thanks for your reply. I setup a formula field adding a number of month to a date field. The Expression in the formula field ("TermDate") is : Date.addMonth(Periode) Where "Date" is a date field in the form and "Periode" is a numeric field in the form The formula field work great but after a moment, before finishing the input of the record in the form an error message popup tellng : "Invalid value found Field Name : TermDate" Anyone to explain me what I did wrong ?
Help with some coding Please
Hi and I hope you can help OK here is what I want to do... I have 2 fields for this task 1 is Post Code (Simple Field) 1 is Agent (Drop down box) In the Agents section it lists what post codes the agents can cover When I input a post code into the post code field I only want the agents that cover that post code to appear in the drop down field for the agent. Hope this makes sense. Nigel
update formula when script updates fields druring edit
I have a formula field that sums the total value of several decimal fields. Example: Formula 1 = Decimal field 1 + Decimal field 2 + Decimal field 3 I have some on edit scripts that update the decimal fields with certain decimal values when a user changes certain fields. My question is how can I get the formula field to update / recalculate its value when an on user input script is triggered and updates a decimal field with a new value? It seems that when an On User input script updates one of the
Quick Access to Forms and Reports (right sidebar) questions
Maybe someone can help: 1. The titles (bold font) of the respective apps don't change although I changed the report and the form names. See attached image: The word 'Qualifikation' should not be there anymore. How can I change the titles or is it a bug? 2. Can I change the order of the quick access to apps and forms? At the moment it just places the forms and reports I added last at the bottom. I would like to move some up... 3. Can I make this sidebar stay there forever? Because everytime I acces
Maximum amount fields in form
Hello, What is the maximum amount of fields in a form? Greatings, Erwin Fennema
Sending emails from multiple users on Zoho Creator
Can someone assist. I have been using Zoho creator for 5 + years, I am on one of your older plans that costs $15 a month and includes 3 users and unlimited apps. I am trying to set up different apps that will allow me to send from different emails depending on the relevant user. I have managed to set this up so everything is working fine, however when I go and create a 4th app using the 2nd user it says that I have a limit of 3 apps. However the plan that I have clearly says 3 users and unlimited
Main form sub form question
I have a two Main forms and 1 subform Form A Subform A (embedded in A) Form B I have data stored in multiple rows in the subformA of Form A ex. Form A SubformA record 1 record 2 on success of Form A, I would like to insert 2 new records into Form B that contain information from Subform A Any help would be greatly appreciated
Zoho security
Hi Can you tell me if it is possible to store my creator Data on a secure dedicated cloud. Thanks Nigel
Compiling Error
I am trying to create a script that will take the Grand Total of a Quote and update the Amount of the Potential to match. I am starting with the example script provided by Zoho to update a amount field in a company based on Won potentials. The issue I am having is that I am getting compiling errors when I try to Save and Execute my script in the builder. I don't understand why I am getting the error and as you can see in my attached pictures if I change some formatting the exact error changes to
No access to application
I have been shared an application through my gmail account. I have downloaded Zoho creator from the App Store and can log in and access the application on the mobile app using my gmail credentials. However, when I access the Zoho online, and log in with Google, I'm told that "You are not allowed to access this application." There are currently only two users for this application, myself and its creator. The creator can access the application through a browser or the mobile app. She tried logging
Public form/record editing
Hello, I'm building an application in ZoHo creator. Now in the application someone can make an assignment for a supplier. After making an assignment the application sends an e-mail to the supplier with a link which opens the record in editing mode. The supplier should put his comment and whether he aggrees with the assignment in this record. He only has to fill in two fields. The supplier will not get his own login (user). The problem is when I open a public record in editing mode, I can change every
speed application
Hello, I'm making a functional design for building an application in Zoho. Now I'm wondering if the following effects the speed of the application: Amount of databases Amount of scripts Amount of records I really need to know this because if these do effect the speed of Zoho Creator I have to think about combining some databases. This is not something I prefer. I've asked this question serveral times on the support desk and I tried to contact the support center by telephone, but I doen't get any
Stateless Form Not Updating Correct Record
I have a simple test application where I click on my custom action button displayed for each record. This custom action lunches a stateless form that contains a drop down menu to make a selection. Upon clicking submit on the stateless form a new record is created instead of updating the record that was selected from the custom action button. It looks like the custom action is not being properly being tied to the record where the custom action was selected. Can someone offer some assistance? - Thank
Anyone having problem with Send mail script? Not receving emails from ZC app
Hi for some strange reason, the send mail script in my ZC is not acting as expected. The mail frm ZC app is not reaching my inbox. #isitjustme? -Deepa Govind http://homepreneur-online.com/
Lookups of lookups
I have four forms: Form B has a lookup field based on Form A; Form C has a lookup field based on Form B; Form D has a lookup field based on Form C. Now when I develop a view based on Form D, I can display fields from forms C and B, but not A. There is no way I can link the forms to display any field Form A, though Form A is used in Form B, and B in C, and C in D.
Custom action view not working for shared user
I'm using a "view" custom action function in a report to dynamically generate a page. void Release.viewRelease(int recId) { openUrl("#View:Generate_Release?orderRecId=" + input.recId, "Popup Window"); } When accessing the report as a shared user, I click the "view" button for the record and the popup does not generate the page correctly. All that displays is the menu bar for the app and no error messages. Also, the popup overlay doesn't close correctly on X icon. In the Firebug console, it's
Lookup of lookup
If I have a lookup field on a form, it can only be set to a standard filed on another form; but it cant' pull any "lookup" fields on the other form.... how can I overcome this?
How to aggregate or concatenate text field content in multiple records
Review of Book A , Book B etc with a varying number of reveiwers. Records are grouped under Book A, Book B etc Reviewer 1 enters a record with a Review Field and submits: "A very good description". Reviewer 2 enters a record and submits "I enjoyed the plot analysis" Review 3 enters a record and submits " Yes it was suspenseful" How can i combine all the comments into a single review commentary of Book A so that it reads: A very good description I enjoyed the plot analysis Yes it was suspenseful
Creator with Google Analytics Web Tracking
Can we use Google Analytics Web Tracking in Zoho Creator? We would like to measure how users interact with our content and marketing initiatives in Zoho Creator. Thanks.
Rental Check in and out with Time calculations
Hi I'm trying to work out a way to get a form for my Ski and Snowboard Rental department up and running. I'm stumped on how to calculate the number of days the guest will have the rentals out. The part that is tricky is that we also calculate what time they take the rentals from the store and when they return them. Let me use a weekend as an example. Rentals can be picked up after 3 pm on a Friday, used that Saturday and returned before 3 pm on that Sunday. I do not count the pick up day (Friday)
null fields when sending data by email.
Hi all I have a simple for with a date time field. The default is the current datetime by using an On Load assignment to that field. So far so good, works great. *However*, if I send the form data by email, with a blank date date time, Zoho inserts the record with a datetime of null. Is there a way to make Zoho set this field to current date time (like it does on form input) when the data is added by email?
Next Page