PHP form sends data to Creator
Hello everyone! I have a problem that I can't solved. I have a PHP form on my website and I want to add a record by this form to Zoho creator. Now the action for this form is to send an email (by mail() function) and I need some additional function which will send all information from form to zoho creator. I was searching on the Web but I didn't find any idea - maybe because Im a beginner in API and I dont know what exactly I need.
"Failed to submit data. Please contact application owner."
I'm using the free version of zoho creater and have created an extremely simple form. However I cannot add any date to my database. When I try to submit the form I get the error message "Failed to submit data. Please contact the application owner" There are no fancy validations or anything on the form, it's simply a zohocrm look up (I'm using the enterprise edition of zoho crm) and 3 date fields. Grateful for any help and advice.
Script error when evaluating old field value
Becoming frustrated with ZOHO Support Found that you can't apply an IF or SET statement against any old values (any old code still works) For example if you create a new form say ZOHO TEST and create a single line field called TEST In the Workflow Script, On Edit Validate if you create an IF statement to look at the old content of the field TEST this error occurs Error at line number : 1 Variable 'old' is already defined of datatype '1013228000006314713' but trying to update 'zoho_test' datatype
Cannot duplicate applications
Hi, I'm trying to duplicate an application, but every time I click duplicate it says "duplicating" and then nothing happens. How can I fix this?
can you key data into a date field?
can you key data into a date field? I have several employees who find it easier to key a date than select it from a date box. is it possible to key the date?
search not allowing decimal entries
Form A has a lookup field <diameter> <diameter> is defined in Form B as as 3 decimal with max 10 digits when in view of Form A, and I search for a diameter with a decimal place, I get error "please enter valid number to search". but I can search for the decimal in FormB no problem. What is the cause? How to fix?
Filter a Lookup
I'm new to Zoho and have tried to do this ... https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup However, I'm getting an error - In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid Here is what I have build. 3 Forms Leases - Lease Name Tanks (multiple tanks per lease) + Lookup Lease Name - Tank ID Gauge Form + Lookup Lease Name + Lookup Tank (only want
Fetch record in Subform with criteria
How to fetch record in Subform with criteria in script? I try same with fetch record in Form, but not working: x = From[ID = 0001]; for each x.Subform[Active == true] { } ---have error x = From[ID = 0001].Subform; for each x[Active == true] { } ---have error Criteria cannot be applied over fetch object
Must be missing something
Have created a simple form. Data is organized by item number 01 to 99. I want to open the form view, & when a user enters an existing number into the item number field, I want to display in the form and have available to change the data associated with this item. Submit button at bottom. Not rocket science, I know but we all have to start somewhere. I have chased around help and forums and can see all sorts of good stuff but cannot get a handle on where to start with this simple function. Any pointers
Allowing external access to just one data record - possible?
We have a membership database with about 750 records in Creator. We would like to enable members to access just their one record in order to make personal information updates. Is there a way to create a view that would allow a member to look up his/her information, and then make updates to just his/her record without having a Zoho account? When we talked with a Zoho pre-sales consultant, he assured us that we would be able to share direct links to records in order to do this, but we have not been
Email download link of uploaded file.
I want an email sent with the link to an uploaded file (say input.uploaded_file) to go out when form submission is completed. I see a several forum posts about this but none of the code suggested seems to work, seems like code is outdated. Can some one please suggest what I put in the Sendmail funtion to create a link for the uploaded file so the person can download the file.
File download url
Dear Users, Creator support uploading of files through the file upload field in the form. Once a file is uploaded, you can download that file through the view. And each file download link in the view will look like the one below http://creator.zoho.com/DownloadFile.do?filepath=/1248931841640_dsc00007.txt&sharedBy=user1&appLinkName=SampleApp&viewLinkName=Sample_View The url contains file id (filepath), user name, application link name (appLinkName) and view link name (viewLinkName). We had certain
Rest api access of zoho creator
I have a free account on Zoho creator. I have one form developed in creator. When I am trying to add record through rest api access, I am getting redirecting to Zoho home page. My rest url is - https://creator.zoho.com/api/skagrawal10/xml/copy-of-mtech-database/form/registration/record/add/ Post Parameters are authtoken scope NAME Please guide me in this.
Autonumber field cannot be used in the formula field?
Tech support told me that Autonumber field cannot be used in the formula field. However, my formula field was working fine with autonumber. Did they change the change the setting? My formula field is very simple. It shows "Last Name - autonumber." ex) Smith - null Of course, it shows "Last Name - null" when I save the record. But, when I edit the record, it surely showed "Last Name - autonumber." ex) Smith - 5930 I wonder why thousands of records were working fine, and it stopped working recently.
Place to write common business logic using multiple forms in Zoho Creator.
Hi, I am trying to write some business logic that involves multiple forms in Zoho Creator. I tried with functions but it does not allow to provide input /set a value from/to a form through a function. Sample code is mentioned below. int test.test() { input.Trainer_s_work_details.Number_Of_Account_Opened = Beneficiary[((Trainer == input. Trainer_s_work_details.Trainer && Bank_Account_Opening_Date >= input. Trainer_s_work_details .From_Date) && Bank_Account_Opening_Date <= input. Trainer_s_work_details
New to Creator
So we have an app, call it App A. Inside of App A we have 2 forms/tables. The first is more of a data form that our customers will fill out. The second is a form we will use in house to manage/track the project. The first field in the data form is *Project Name. Once the data from is submitted by our customer we would like to have this field *Project Name also appear as the first field in our back end form/table. What is the best way to do this? Would it make more sense to use a subform? Hope
is it possible to change form design at run time?
I want add or remove button, or field at run time. meaning change the current form design. is it possible? thank you
Zoho creator generated Emails are not longer received at Gmail and at Yahoo accounts
Hi, We have a form when upon new record additions an email is generated to recipients at Gmail and Yahoo. This used to work as of 3 months ago and has now stopped working. The intended recipients are complaining that they no longer get these zohocreated emails. After spending some time on phone with Zoho support and experimenting I narrowed this down to the fact that Gmail and Yahoo are not delivering these emails. An email box hosted on hostmonster however is receiving below. So it seems Gmail/Yahoo
Pie Chart from a Formula Field?
How can a pie chart be created to show the percent of On Time Quotes vs Late Quotes? Form Fields Due Date Sent Date Formula Field On Time / Late if((Quote_Due_Date >= Quote_Sent_Date),"1","2") Thank you in advance
Formula
I need to use this formula but the formula field does not calculate this in the correct way ex. (Lunch_Number_3_5 *Serving_Amount_3_51) + (Lunch_Number_6_12 * Serving_Amount_6_121) (10*1.5)+(1*2) = 17 but this is not what Im getting. Im getting 32. Any help Thank you
Error Message with the "Delete Duplicate Records" Code
This is what I was told to put in to find duplicate entries in a a data base and delete. But when I do I get an error message. myList = list(); duplicateRecordIDList = list(); for each record in myForm [ID != 0] { if ( myList.contains (record.Email) ) { duplicateRecordIDList.add(record.ID); } else { myList.add(record.Email); } } delete from myForm [ID in duplicateRecordIDList ]; This is the error message Error at line number : 1 Improper Statement Error might be due to missing ';'
Creator API Rest access is redirecting. No error codes are shown just showing Moved permanantly
I am calling rest api to add a record with authtoken, scope and NAME field in post request. But it is not showing any error codes but redirecting to zoho home page. I have free account. https://creator.zoho.com/api/skagrawal10/xml/copy-of-mtech-database/form/registration/record/add/
System is Responding Slowly
Hi, Do you know why the system is responding so slowly today? Please let me know. Thanks! -V
Photo upload not working
Hello. Anyone else having issues uploading photos into zoho? I've been using same app for months and today I can't seem to get photos uploaded....didn't make any changes to app or form... Checked my usage/quota and no issues there. Thanks
Date not changing, multiple submits required, eternal please wait
We are having an issue that is now ongoing for about a week. The date box requires you to select a date at least 2 or 3 times before it actually changes. When you hit submit, it will not register the first time. We have waited to see if there is simply a lag, but nothing happens. When hitting submit again a "Please Wait" message begins circling and never stops. We have left it alone for a while and it still just keeps circling. If you go to reports the data was not entered.
sms automation
I have a mobile number field (number field) in the delivery form I constructed. I went into settings, then automation and created a rule such that if the field in my form status of delivery is equal to "second delivery unsuccessful" an sms is sent(task). The task is below. sms input.Mobile_Number We tried to deliver your items twice and unfortunately you were not at home so please could you collect the items or phone us if you want to reschedule a delivery I added clickatell as a connection and used
Customer Portal
If I build a customer portal app in my account, can it be later moved to another account? PS: How many customers can sign-up per the old and new enterprise plans? Cheers, John Whitney
Getting an unknown error when trying to add a user to the portal.
I am trying to add a user to the portal. I get this error message "An error has occurred. Please contact support@zohocreator.com for assistance." I have sent an email to support, but I am curious if anybody else has seen this message and knows what it means. I have attached a screen shot. I am stuck until support gets back to me, so if anybody knows what it means let me know.
Lookup an email address in another form based on dropdown selection.
I have 2 forms. Form 1 is a Sales_Rep form with 3 fields: Name, Email, and a checkbox for current employee or not. Form 2 is a Job form with many fields. One of these fields is a dropdown lookup of Sales_Rep.Name. In the "Form Actions, On Success" deluge script of Form 2, id like to send an email to the Sales_Rep.Email of the selected Name. Im unsure of how to declare this variable.
how do i open a specific stateless form in edit
I have a form 'A' which when submitted saves the data in that forms 'A' report. Now i have a stateless form 'B' with some selected fields from form 'A' and when submitted saves the data in Form 'A' report. But when i click on edit in the report to the data of form 'B'. i am not able to open that stateless form 'B' in edit mode.instead it opens Form 'A'. So, i just want to open that stateless Form 'B' in Edit mode of Report A.
Coding help
I'm trying to learn the basics of writing this code. Can you recommend a book or website for a beginner? What's the name of the code? Where can I do some research? Thanks, Steve
Language of public forms
Hi! Is any way to control user language in Public form ? User of public form always the same, so is any way to set/change user language?
Creating a user submitted query
I have been looking for some time for a relational database solution for a simple membership app and I'm hoping this might work. I used to be a database admin years ago but was not a programmer. I did a lot of SQL and some simple scripting but don't have a lot of coding experience. I would like to create a relational database with I think 3 simple tables, a member table, a registration table, and a merits table. The master table would be the member table and contain all pertinent data about
Import form with lookup fields
Hi, I have 1 form which has customer data, and another which has employee data. Now I have created a third form which stores installation data, which (in addition to other fields) has 2 lookup fields: 1. One for the customer form (as company name - city - state) and 2. Second for the employee form (as First Name - Last name - Location) Now I am trying to import some data into the installation form, but what is happening, its creating new entries in the customer form and the employee form. I want
Option to import for sharedusers
Option to import is not available for shared users. I saw a a topic tow years ago and it was advised to use zc_ShowAction=import at the end of url which only works for developers. Is this feature still not available? Thanks Reza
Upgrade Entries on CSV import
Hi, I need to upgrade entries on my list once I import a CSV file. Normally I have to choose one key field. But I cannot do this in Zoho Creator. Right now the entries duplicate instead of update. If this is not possible. Then are there any other options? Can I maybe create a script that says something like: if new entry field xxx already exist => delete old row. ?? I don't know how to do it. Help, please.
Finish Date formula??
I have a date field that holds a Date and a number field that holds a number of days. How do I configure a second date field to show the original Date value plus the number of days thus calculating a Finish Date based on number of days duration? Thanks
Email link to file when file upload is used
Can you tell me how to get the file path to show up in the email notification based on the form on my site here: http://www.franklindocs.com/pages/quote Austen orders@franklindocs.com
Hide values in chart
Hello, I am trying to hide the values in y-axis of my charts. I could hide the values that appear under the axis title setting the color to white, but there is still a balloon contatining the values that appear every time you pass the mouse pointer over the bars. Does someone know if i can hide these values? Thank you!
filtering lookup fields
Hi, I am having real trouble filtering a lookup field for patients according to the pharmacy branch/shop they go to. I used this code on load. However, there is some kind of error with the last line, because when I added it in, the form stopped loading when I wanted to access it and it said "error occurred on loading this application." User_Email=zoho.loginuserid; getShopAt = Users[Email == input.User_Email]; Shop=getShopAt.Branch_at; Patient_List = Patient_Details[Shop == input.Shop]; Patient_Details:ui.add(Patient_List.Patient.getall());
Next Page