Issues in implementing email processing within Zoho Creator application.
Hi Zoho folks, I have a client who needs to automate his processes, which are primarily based on incoming emails. Each of these emails represent a Request which needs to be added to the Zoho Creator database and tracked to Completed status. These automated emails come from an external source, but are in some standard format. So the emails were added to an email-inbox and data processing was done in the On Add --> Validate, parsing out the data. This is okay until there are no issues in the email
Help with Decision Box Display
I am not sure how Zoho Creator treats true and false. Are they 0 and -1 or 1 and 0, or what? I have several decision boxes which when displayed in Form View show either true or false. Is it possible to display either a box with a tick or (no tick or cross) or a Yes or No (true and false are too similar to be easily distinguished by eye).
Failure in emailing to add a new record - "Error occured while adding record"
Hello, When I send an email to add a record into a Form, I may receive an error email, subjected as "Error occured while adding record"; and the email content suggests "The Following error has occured while adding this record: 50". I created a new form to test this. The form has only one single-line field named "ZC_Subject" and one multi-line field named "ZC_Content", and no other deluge statements are involved. I noticed this may occur for long emails only. Please help! Thanks!
In View Sorting After Group is applied
Hi I have a view for which i have set up grouping in the view definition When i look at this view it is grouped as i expect. BUT I cant seem to apply any live sorting to this view , seems like any view sorting functions are now disabled Is this the way it is meant to be ? Thanks
error when entering Creator [ServletException in:/jsp/newhomepage/newhomepage.jsp] null'
We were using a very slow connection this weekend and all of a sudden we got the error above when entering into Creator. Any ideas what we can do about it?
Creator runs very slow
Creator runs very slow at me now. Does anybody have a similar problem with Creator?
Separating multiple items from a Lookup field in a view
My app uses a lookup field to a form with the paragraph text box (long text?). When a record is linked to multiple records in another form, the view shows the other records separated by commas. Is there anyway to separate them by new lines/carriage returns? For example: Col 1 Col 2 Record in form a This is a long sentence in form B, This is a long sentence in form C. want to change to: Record in form a * This is a long sentence in form B.
How to connect form with database?
I have created a database with Zoho Creator in order to house pertinent information for our organization. This database includes basic contact information of members as well as fields that we will use internally for our own use. I have also created a stateless form that I would like to use for our members to submit their contact information. If the field names and designations are exactly the same, is there a way that the member who submits the contact information form (a new record completely)
Help with database
Hi Everyone, I am very new to this but I am hoping someone can help me. I am trying to create a database where people can select the items that a dog may be allergic to and it will spit out the brands. I have created the form but do not know how to reference the mutl-select to a databse. Basically the idea is say someones dog is allergic to chicken and beef as well as carrots and pea it will spit out say 10 brands and the model of the food they can try. I also need an easy way of importing this
Can the More Actions button be made visible in the embedded view
Can the More Actions button be made visible in the embedded view ? Is there a alternative for printing the data in a embedded view ? Thanks, Ken
How to import Filemaker Pro database including photos?
Obviously, when exporting an Excel file from Filemaker Pro, the images are not carried across. Is there any workaround for this or do we have to go through and manually re-upload an image for every entry?
I Cant ... Gues this? please Solve this problem
An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home
"More Actions" drop down menu not visible in List View embedded in HTML View
I do not see "More Actions" drop down menu in List Views when they are embedded in HTML Views Is this a bug or am I missing a configuration? Harpal
How do I remove dropdown grouping
The dropdown grouping filtering on a view is very useful for my end users but once the view has been grouped, the grouped column disappears. How do I remove the grouping and go back to normal ungrouped view? Peter
How to search (or make a report) that searches ALL views?
I see how to make a report / view based on a single form / view, but how can I easily search across ALL data in the application (i.e. just a simple, broad database search)? Thanks everyone.
Dashboard of Apps Very Slow
I have been reviewing Zoho creator for building a new app for myself. While viewing demos of various apps i notice the dashboard loads very slowly. Is this common ? What is the issue and is this expected ?
How to create a view for a form with multiple subforms
Hi, I have read through the few topics that cover this question and still haven't found what I need for help. I have form A, with subforms B,C,D, and E in it. I need the veiw of A to show information from the subforms. I've imported data and it come through w/o any errors and is showing in it's perspecitve forms but when looking at the view of from A, no informationa at all shows up in the columns for these forms. I'm getting a java error when I go into column properties (I am running the
return only one record for each match in dropdown
Hello, How can i return only one match for each different record found instead of all. I am sure it has something to do with the "getall()" function but I do not know how else to code it. if (count(Pulser_Serial_Numbers[Pulser_Size == input.Pulser_Size]) == 0) { clear Pulser_Serial_Number; } else { mpseriallist = Lifetime_Hours [(Description == input.Pulser_Size && Job_Number == input.Job_Number)] sort by Serial_Number ; Pulser_Serial_Number:ui.add(mpseriallist.Serial_Number.getall());
Google's verification email, to enable automatic email-forwarding, not received within Zoho Creator
Hi, I am working with a client to enable email-driven add/edit. The app works fine when emails are forwarded manually. Now, we want to enable automated email-forwarding from Gmail, but it seems the verification-email from Google does not reach the Zoho Creator form's records. I see that this is the expected behavior as is detailed in the following forum post.. You can use Gmail forward option if you are using Gmail / Google Apps, refer this help document to know about Gmail email forwarding. Note:
Search Query
Hi, I have a database and one of my categories is what phones people have. So I have a list of loads of phone makes. I would like to pull out people on the database who don't have iPhones and Blackberry's just leaving everything else. Is there a way to put that into the search query with the 'Not contains' or 'Is not' section? I have tried it but it wont work. Is there a special way to separate them and make it work? Like........ Is not ---- "Blackberrry", "iPhone" Many thanks Gill
Need help creating a simple database with search capability
Can someone point me to a tutorial how to create a simple database with search capability. I want to make a list of 100-200 home properties with different qualifying criteria and to be able to search for the right properties once I type a certain criteria in the search field (age for example)??
Calc / Functions
Good night, I'm building an app that requires some calculations, with four int variables that should return a int value that would fetch the field "Prioridade". I've tried to do this operation using the "Function" new option, and even calculating the variables directly into the events code; neither worked out, thought the script deluge didn't pointed any flaws at the syntax. I'd really appreciate if you could take a look at this functions, I've shared the form with support at zoho dot com - please,
How to gather form data into the script of another form
I have created a fee schedule form where I store the values for fees we charge. I also have a form that is used to send a billing notification of fees owed. I am trying to include the fees from the fee schedule form for use in the form that sends the email - I have pasted the script below. The ExternalFormFullWebFee variable is supposed to be gathering the fee that I want from the external form data. The script does save but when I run the form I get a 'variable cannot be updated' error and the email
Confirmation email
I have created an application for jobs to our university. I have completed 2 scripts for email confirmations, one is "on load" the other is "on success". When I apply for a job using the application, I am not receiving a confirmation email back even though I have completed 2 scripts. Could you tell me: 1- How quickly is the confirmation email suppose to be generated 2- Am I doing something wrong? Is there another place in Zoho that I am supposed to complete to make sure that the person applying
API issue, using REST to delete
Dear all, under Known Issues and Limitations for API's there is The user cannot delete/update the records for a shared application. What does that mean exactly, so any application I share I can not use APIs to delete or edit records from it. If so how come under REST API, Under Deleting records there is: When accessed by the application owner: https://creator.zoho.com/api/<format>/<applicationName>/<formName>/delete/ When accessed by a shared user: https://creator.zoho.com/api/<format>/<applicationName>/view/<viewName>/delete/
Critera using an "or" statement
Currently my criteria is saying "if field 'XYZ' is blank", like this: (XYZ is null) But now I want to say "IF field 'XYZ' is blank OR if field 'XYZ' equals 'Yes'" How do I write this? Thanks in advance. Jon
For Each statement creates duplicate emails
I have a function that is supposed to collect records of our agents who have not paid a certain bill. For some reason when I invoke the 'sendmail' routine using a for each statement it will send 2 notification emails to each address. I have only 2 records that match the criteria for testing purposes right now and the view I created to match shows just those 2 using the same criteria. Here is the function I call from that view to send the emails: void agent_management.getunpaidfullwebsite (string toaddress )
How can I have 1 form or field update 2 fields in 2 separate forms.
My ultimate goal is to have 2 form field put data into 2 fields in 2 separate forms. Here is current code: if (input.Completed == TRUE) { lastWorked = Checkout [Checkin_Date]; } I get the following error: "Error in statement at line number 3A Boolean expression is expected in the where clause. and but an expression of type TIMESTAMP is specified here" I want to fetch the Checkin Date and input it into a different table. This could happen when someone clicks the "Completed" checkbox. What
Limit Submit per User [field] per a sepecific Date [field]
Dear all , i have a form containing 10 fields , i need to restrict the submition to only once per day , the rule should check the following fields to see if they are already submitted. e.g.. Name: (drop downList) containing names. Date: (Date of submition) thank you :)
DATE fomula challenge. really need help
Hi , I'd like to have user enter a StartDate, then specify a duration (1 w, or 3 m, or 1 yr, kinda like a subscription plan). I need to get back the ExpDate, and the count down in days to it. This way, I can sort data to lets say 3 days notice before expdate. I really need help. Thanks so much.
Can you change the order things display under the Home menu?
I love this tool - but there's one thing I can't figure out - can you change the order in which forms and views appear under the Home menu? I'd like to group some things together but they are in the order I created them... Can anyone help? Thanks
Imported data in subforms not showing up in application View
I'm importing data into an application that has 4 subforms. The information is going directly into the separate subforms, but then it won't display in the actual application view. I've tried modifying the column properties in the application view, the subforms show that they are linked, but when I try to choose the field to display, I get a little yellow triangle error on the bottom, left of the page when I click done and no changes are made. Any ideas?
While in application the forms and views are not sorted
I noticed that when designing an application the forms and view are presented in alphabetical order in the drop downs but when actually using the application they are sorted in some other order. I would like them to appear alphabetically on the application like they are when editing. How can this be done? Thanks! Parker Byron Network Administrator Kansas City Regional Homes, Inc.
SmartPhone problem on the form
I create a contact form and embed it successfully to my website. The problem is when I use my android (2.3.3) phone browser to access to the form, The captcha field doesn't display. Try with Firefox and Opera browser on my phone, The captcha field is Ok, but when I click on submit, the screen stops forever at "Please wait...." text. There is no problem when accessing by desktop computer. Any one is facing this problem? Your help would be appreciated.
Should Reports be This Complicated?
Hi - I don't know much about Pivot Tables but I want to be able to share a report with my team that basically looks like an Excel spreadsheet (but not showing all the data I have gathered). The pivot table seems very complicated and way more than I need. I would like the column headers to essentially be row 1. And then all the other rows would be the records that I have built in my database. How is this done? Can it be exported? Can it be printed? Thanks so much! Jon
Justify the data in a column.
I have a view and all the data is justified to the left in the columns except just one column of numbers. How can I make this column of numbers be left justified.
Update fields from external forms in creator.
Hi, I´d like to know how can I get data from fields from a form wich is in my App? This is the case: I´m building an app for Aircraft Maintenance so I have an Acronym, Brand, Serial Nº, Model, etc... I´d like to get this data in a different form only when I insert the Acronym. Is there a tutorial to get the data? Thanks. Antonio Rodríguez.
How do I edit once contact is created??
I have created a contact, and cannot figure out how to get back to the contact to edit more fields.
Dollar sign in currency fields give error.
Does it makes sense that we cannot include a $ in a USD currency field? I think it is common sense that a $ could be a valid character in USD currency field. What is the point of a currency field if the server is not smart enough to handle a dollar sign? This is very frustrating to my customers. (not to mention it cannot even handle a comma ,) Seriously, why would you use a currency field?
Send email depending on status
I have a field in my form "Status", and depending on the status I want an email to be sent to the customer to let them know what the status is on their order. The problem I am having is that every time I edit a record, it sends an email, even if nothing was changed. For example if the status of an order is "Completed", I can open and close the record many time and an "order completed" email is sent each time, even though I haven't changed anything. How do I set it so that the emails are only sent
Next Page