Zoho Creator Down
We have lost connection with our zoho creator applications. We get errors on all forms saying ther eis no such form in zoho. We cant access anything in our application. What is happening. Status for zoho creator says it is up. Anyone else having a problem?
Fetch record using Lookup Field?
I'm fairly perplexed by this issue.. I have a form Called Task This has a field called TestLook which is a Lookup of a form called Contractor. The lookup field is Token_Secret. I have checked and there is definitely a record in Task that has TestLook set to a Contractor record that has the value for Token_Secret match input.Token, I am trying like this in my page: tasks = Task [TestLook.Token_Secret = input.Token]; Is the way I am doing the fetch not correct? I'm perplexed as everything seems
Convert html view in PDF landscape
I created a new html view and as you can see in image1.png I added the two buttons (Print, PDF) which are available in the header option...So, in my free flow script now shows print = true pdf = true My question is, how can I change the code to show me the page in landscape mode? Because now it opens the pdf as portrait. I found this one Example PDF link with orientation value as landscape: http://creatorexport.zoho.com/sampleapps/customer-support/pdf/Most_Recent_Solution/&zc_PdfSize=Letter but I
Bug in filtering on Mobile App
Hi! The mobile App can not show any UTF8 char displayed in the filter section. Just cuts them off. /V
Upload image with API
Hello, is it possible to upload image with API ? If yes do you have an example ? thanks you
multiple addressees for sendmail?
Before upgrade to Zoho 3.0, my script was working fine to sendmail to multiple individuals selected in a form. I concatenated their email addresses together to form the "To:" using the format: email1@here.com, email2@here.com, email3@here.com Upon upgrade this feature broke and I am just now trying to debug. I've tried commas with no spaces, semi-colons with spaces and no spaces, making sure there is no trailing punctuation... everything I can think of. I can have concatenated email adresses
[Feature Request] Please can we get more than 1MB file size limit on the image upload field
My clients are almost exclusively using mobile, and all pictures taken on newer cell phones will always be larger than 1MB. I know the file upload field is higher, but images are easier to deal with when printing and viewing record summaries.
Distinct Record View
I want to create view that displays the unique (SQL: distinct) values from a text field? how?
Display "Title" of an image field on the record view
Hello, I want to display the "Title" that can be entered when making the entry for an image field on the record view as a headline of the image. I'm also confused that the functions of the "Alt" text and "Title" for an image don't work at all as it is explained on the "creator help" website. I couln't find a similar post and look forward for any recommendations. Thanks. Best Hans
Publishing page does not generate authtoken at end so can't access it without being logged in
I am absolutely perplexed by this issue and have been going back and forth with support on this already. I am trying to publish a page but it does not publish with an authtoken at the end. Support told me that it should, I am trying like in the screenshot I have attached. It just gives me a Permalink like this: https://creator.zoho.com/rickdane/stacksavings/view-perma/test2 So whenever it is accessed without being logged in it prompts for login. Is there something wrong with my account as to why
Report Display Criteria
I'm creating a report that I want to have the records display the results based on a criteria of starting 3 days before today and prior to that. Is this possible and how would I do it? Thank you in advance.
Having trouble with email rule
I have a checkbox set up, I will give an example of 3 options for a field called "Drivers" Jim Sue Thad I want each selection to email a notification to the specific person included. This works if you only select 1. Unfortunately if I select more than one it seems to break my rule and doesn't detect it. For instance....If I set up a task for emailing Thad when it is selected and the form is sent, if Thad is only selected it will work but if I have Sue and Thad selected it wont. I'm sure I'm just
Idea: A system-maintained table (or export) with all fields and their properties (for all forms in the app)
A special table, maintained automatically by the system, that has 1 row per field, for every form in that app. The columns would be all the items in the "Field Properties" tab. The admin can view this table, and filter it (such as to show the fields for only 1 form) but of course cannot edit. This data is of course already stored somewhere in the system, so it would be a matter of surfacing it in a nice list for analysis by the admin. Or at minimum: offer an on-demand EXPORT of this info -since
zohocreator.exe upload authentication issue
Hi - in running an established daily csv upload with zohocreator.exe, we are suddenly getting an "Username or password is incorrect" error message. We have not changed anything at our end. Please advise, further details on the issue have been forwarded to support.
Is it possible to have validation on insert of record that checks if field value exists in another form?
I want to do something like have a validation that on insert of record into a form of field for email address checks if the email address value exists in another form. If the same email address does exist in the other form, I don't want it to consider inserting the new record. I've been doing some research but still not quite clear if this is possible? Would appreciate any insight. Thanks
create sections in a creator form
Hi Guys New to this. I am trying to add a section to my Zoho Creator form. I am collecting data like a survey which is broken into 5 different sections, with questions in each section, answered by a drop down. How can I add a section with a heading. I don't want to create a new form, just a heading and section break. Thanks in advance.
Update File Update Field in Another Form
This script is not working for updating a file upload field in another form. What am I doing incorrect? if (input.File_upload != "") { sd.Shipping_Document_Scan = input.File_upload; }
Page is pubished and so is the report that it uses but can't view it without login
I've been struggling with this all day, I have a support request open too but haven't gotten any traction. I have a page here that can't be viewed without login even though it is published: https://creator.zoho.com/rickdane/stacksavings/view-perma/testpage The report that is in the page is also published. What is the issue?
Is there any problem with the Sendmail and HTML?
Dear All, Is there any problem with the sendmail in Zoho Creator and the HTML? One of our HTML templates is shown like plain texts in all our mail accounts clients. We test it with a simple <div>Hello World</div>...It shows it as plain text in Zoho mail. Please check it URGENTLY!!!!
Responses from Creator API Changed in the past 8 hours
Hi There, From what I can see, the responses from the API have changed recently. The following example should illustrate. If I make a request to the api that does not validate I get the usual response see: curl --data "authtoken=<yourtokenhere>&scope=creatorapi&First_Name=test&Last_Name=test&Email=test@test.com&Mobile_Phone=1234567890" https://creator.zoho.com/api/zoho_beth3/json/talent/form/Appointment/record/add/ response: {"formname":["Appointment",{"operation":["add",{"values":{"Email":"test@test.com","Last_Name":"test","First_Name":"test","Mobile_Phone":"1234567890"},"status":"Failure,
Email notification on success
Hello, I would like to send an email notification for the Sales Person Assigned, once a new Quote Request is submitted. The email notification would be with the Customer Name, Project Name, Job Type, Additional Information data, as well as link to the relevant record view in the App. I tried to wrote a script on the New_Quote_Request Form Actions > On Add > On Success: quoteURL = " https://creator.zoho.com " + zoho.appuri + "#View:All_Quote_Requests?quoteRecId=" + Quote_No.ID sendmail
Decimal fields that are transformed into number fields
Hi. I have forms containing decimal fields. However, after sometime, they are no more decimal fields, but number fields. Is there a way to solve this issue and keep my decimal fields working? Thank you!
[SOLVED] Send Report Summary not possible anymore?
Hi, I tried to follow your instructions, but it seems as the function to send a report summary has been removed? I have a Record Summary (on a list), I should be able to select it as a template. I dont even have a template button. When I try to add it manually it wont allow me to add templates on edit, function or as a schedule (even though the instructions seem to say it should work). Has Zoho removed the function of sending a report summary by email that is not on create? /V
[SOLVED] Create a report based on form and subforms
Hi! How do I create a PDF report from a form with several subforms. Do I use a HTML view with "for each"? Or is there a better way? /V
Moving field data?
How can I move data from one field to another? Specifically, we want to move the email addresses that are currently in a single line format field into an email field so that we can use their links. Is there a simple way to accomplish this without having to do each record one at a time?
Using Google Forms with Zoho Creator
I have a client that has created an extensive Google Form, with many fields consisting of radio buttons or drop boxes. Currently the data goes to an Excel spreadsheet, but I have convinced them to use Zoho Creator instead. My question is whether i can use their existing Google Form and have the data go into a Zoho Creator database. Would appreciate any feedback on this. Thanks, David
Forms that contain Subforms will not save on Edit
I have contacted Zoho by phone and email regarding this issue, but still have not received a response (despite having an Enterprise subscription!). When I try to Edit a form that contains a sub form, i get the error message "Invalid Entries found. Please correct and submit again." The form does not have any mandatory fields and I can create new records using the form just fine. I spoke to the gentleman at the Zoho Helpdesk who was able to reproduce the problem and confirmed that this is a back-end
Can I display record summary "On Success"
Hello, Can I display record summary after clicking Submit button? I have Auto Number field which is basically tool serial number in the system. Unfortunately it is not visible in ZOHO form, only later in report view. I would like to display that field with tool description after clicking Submit button. Or is there other way to display auto number field in form view? Thanks, Pawel
Update row in subform
Hello, I have a form "PRODUCTS" with ID and Text i have a subform with 2 fields, ID and Text and NewProduct. How can i update my specific row when i change the value of NewProduct on the second row by example ? My test change always the value on the first row ? thanks you
Dynamically fill subform
Hi, I'm building a rental system. In this system orders are created of the rented items to a customer. Each order also has a project. One project can have multiple orders. When the items are returned, a project is selected and then a subform should be filled with all the items on orders in this project. In this subform the returns will be entered and saved. How can I dynamically build this subform? Kind regards, Johan
OpenUrl called from a web link
Hi I have an HTML page which displays records from my database. I want the user to be able to edit individual records by clicking an 'EDIT' link alongside each record. I would like the form view to open as a popup/modal window above the HTML page. Once the edits are done I want the popup to disappear and the HTML to reload (updating the data). To this end I am trying to display a web link which will trigger: #Script:page.open(url, popup) I have a function which generates these weblinks for each
How Do I Upload a File from an HTML Page?
I am struggling with how to upload a file through editing a record from an html page. I have a page called: Driver Dashboard. On this dash I want the driver to be able to edit one single field on a form called Order_Form. That field is a file upload. Here is what I have tried so far that have not worked. Stateless forms. Doesn't work as stateless forms don't support the file attachment field type. Embed Report: I have not been able to embed only the field I need from the form. I can only get it
Populate subform field from On Add Row event does not work unless value is selected manually
1. I have a form, MyMainForm that contains a subform MySubForm. 2. The lookup field, Application_Number_Text in MySubForm is a dropdown. 3. A script in the MySubForm's On Add Row event populates the Lookup field in MySubForm field: row.Application_Number_Text = [blah blah blah] 4. When I add a subform record, the Application_Number_Text field appears to be filled. 5. When I try to save the subform row, I receive an error. This is because Zoho Creator thinks that Application_Number_Text field is empty.
Decimal number of a letter
Is there a function to get the decimal number of a letter? For example A is 65 and a is 97.
Count lines in a Multiline field
Can anybody tell me how to count the number of lines in a mulitline field? I have a subform (B) within a form (A) that has a string field (row.Unique_ID) that I capture in a Multiline field (input.UID_List) as a summary of the unique field records using the following code: 1. if (!input.UID_List.contains(row.Unique_ID())) 2. { 3. input.UID_List = input.UID_List + "\n" + row.Unique_ID; 4. } What I want to do is then count the lines in the field to calculate the number of different entries in
Error - There is no such view in Zoho Creator
I have a application that is created in Creator: I would like to use the REST API's to download from the view/report. It keeps giving me the following error: <!-- $Id$ --> <div style="text-align: center;vertical-align: middle;font-size: 14px;margin-top:150px;">There is no such view in <a href='/'><strong>Zoho Creator</strong></a></div> ****** end of error The URL that I use: https://creator.zoho.com/api/zoho_bob191/json/t3/view/GoldMine_Web_Import_Report What I send to the URL: <input type="hidden"
Unable to add record via API
Hi, I'm trying to add a record into a Zoho Creator application i've created from a Zoho CRM custom function. Here's the call i'm making: paramsmap=map(); paramsmap.put("authtoken","my correct auth token that i know works"); paramsmap.put("scope","creatorapi"); paramsmap.put("Account_Name","My Account"); url = postUrl("https://creator.zoho.com/api/myuser/json/planx/form/Account_Marketing_Stage_History/record/add/",paramsmap); info paramsmap; info url; ** I'm replacing "myuser" in the call and "my
[SOLVED] Create new subform entry from main form
Hi! So, I want to do the following. Form A = Missions Form B = Messages Form B is the subform of form A Im trying to create a function in form B (not as the subform, but as the "add" form) which allows you to answer a question which was generated in the subform. Basically, when the user clicks on "answer the question" button on form B, it should be seen in Form A as a subform entry. I have managed to create the following function (and it doesnt complain, but wont work). Form B has a lookupfield (exisiting
Lookup Field - Column missing
I have two forms in my application "Harmony Rescue". CLIENT Client Name Client Species Client Breed / Type CONSULTATION Client Name (Lookup) I would also like to bring in the Client Species column, but it is missing from the list. I'm not sure why I cannot select it. Can someone please assist? Thanks!
Migration tool - Please specify valid criteria field name
I'm trying to use the Zoho Migration tools to upload a CSV into a form, but everytime i run the command i get: Please specify valid criteria field name the command is: zohocreator.exe upload.csv -authtoken *********** -e AppName -au FormName Asset_Serial Asset_Serial the first Asset_Serial being the deluge field name and the second being the CSV column name. at this point i'm stuck because the documentation on the migration tool is mediocre at best so any input here would be great. Thanks.
Next Page