500 internal error
basically I use zoho creator & try to use API data write but after follow the instruction as per zoho instruction, when code try to the connect the zoho server that time server ( Or Code?) give the response 500 internal error. please give resolution for this problem.
Record Summary View: left-justify data in linked tables
Hello, How do you set data to be left-justified in the columns of a linked table in a Record Summary view? I set both the label and value formats to be left-aligned, but it still comes out centered (see attached images of edit and view pages). Additionally, is there a way to change the column widths, or is that only set automatically? Thanks for your advice. Cheers, Elizabeth
The form created with Zoho creator does not paster entire number in indic fonts
Hello, I have created a form when I can enter a telephone no. The max digit is set to 10. when i pasted the number using indic fonts i see only ५ १ २ ८ ५ pasted. What am i missing? Thank you
Scrip Builder Freezes
In creating a new function, when I select to add the aggregate record function, the screen freezes and it grayed-out. Cheers, John Whitney
Edit record URL not working
Why would it be that, as an Admin, I can view this: https://creator.zoho.com/zoho_admin58/obm-system/#Form:Contracts?reclinkID=1526298000000741045&viewLinkName=Contracts_List (which allows me to edit record, and shows all the Zoho headers), but I get an error message with this URL https://creator.zoho.com/zoho_admin58/obm-system/Contracts/record-edit/Contracts_List/1526298000000741045 The message is "You are not authorized to edit this record." I'm sure this WAS working before.... Alex
Can't even get a simple fetch data to work
Why is this so hard? I have two test forms: Form1: Name Age Form 2: Name lookup dropdown from form1 Age I just want the age field on Form2 to auto enter the age from the selected name in the dropdown. Essentially looking it up from Form1 It keeps telling me the name is an integer. What EXACTLY do I need to do? thank you.
Real time search filtering available?
Is real time search filtering available in zoho creator? i.e. where the results narrow as you type in the search field. See link for video demonstration: http://youtu.be/wfNIK-nhySc
print attached pdf files record summary
Hello, I would like to know if it is possible to have an attached PDF file print from a custom Record Summary. Thanks,
Field Value validation
Hi, I have a form where users enter in a unique coupon code to enter a competition. At the moment the only validation is that the length matches, so a user can enter any X digit number and it will work. I need to be able to compare the entered field value with the unique coupon codes and if there is no match the form doesn't submit.. Any pointers? Thanks
Lookup field in 'Record Summary View' shows ID, not value
Hello, I've got a Record Summary View to summarize customer data. Some of the fields on the source form is are lookup field, such as from a list of technicians or service operations. However, in the view, it displays only the ID of the lookup selection(s), not the value, as shown in the attached image. Is there a way to correct this? Thanks, Elizabeth
Zoho Creator issues importing files
Every time I try to upload an excel file it takes me to the page where it imports the data but even when I name the label and click Finish this error message pops up "Please provide label name for database form."
SubForm edit
I try to connect records from subform into main form. I make 2 simple forms and joined it as a subform. I build simple code: Record = Availability[Date_field =="12-Nov-2013"]; Subrecords = dt.SubForm; info Subrecords; The result is: Time_Schedule[ ID in (1581254000000652651) ] Then i build next code: IDList = Time_Schedule[ID !=0]; Record.SubForm = IDList; info IDList; The result is: Time_Schedule[ ID in (1581254000000652639,1581254000000652647,1581254000000652651,1581254000000652743,1581254000000653527)
automatic data uploading?
Hi. I'm trying to build a web page around an embedded zoho creator application. I need the data to stay up to date for the application to be of any use. This needs to be an automated process. Is there a way to upload data from a server to my zoho creator application? For example, in .csv format?
Lookup field in a subform
How can I detect if a lookup field in a subform does not equal "-Select-" please? I'm sure others must have hit this same problem but I haven't been able to find the answer as yet! I have tried null and even ID=0 but no joy so far. Many thanks for any advice
Creating a form which filters out projects that don't have assignments
Hello - I'm trying to create a report that will show me only projects for which I have no one assigned. Assignments is a separate Form from my Projects Form. The Assignment Form references the project that it's for, so there must be a way to filter just projects that don't have any assignments, but I'm not sure how. Probably involves creating some kind of flag when an assignment is created. Can someone help? and talk me through it? I'm a newbie at this, so I need baby talk... :) thanks in advance.
Extremely poor and unprofessional services from ZOHO Creator
Hello All I may be the only person experiencing this, but since the middle of August, the services provided by Zoho Creator has gone to the dogs. Case in point being unresponsive and dodgy customer service, who among the many ills include unresolved ticket issues and a case of speaking from both sides of the mouth. Additionally, for the last two months, I have had a persistent problem with schedule execution, which despite numerous calls and emails, has remained unsolved. To add salt to an injury,
how to embed a specific form entry on a web page
Hi, I am building an application for real estate, and it has one record per property, with all the property details needed for that property. The data is filled in by the company staff when they are logged into zoho creator. I would like a way to then embed the record view on a web page for a particular property so that our customers can view the property details and make a purchase decision. Of course, the embedded details are not editable. How do embed only one record onto a web page? Thanks, David
Email Notifications
How do I include an uploaded document in an email notification on Creator?
Sending a notification to all users
This must be an easy on, but I can't figure it out myself. How do I configure the form notification in order to send an email to all users of the database each time a new record is successfully added. The only available variables in the To: field are "zoho.adminuserid" and "zoho.loginuserid" but there seems to be nothing to send the mail to all users, regardless their current login state.
Set project status to pending as long as current date is before start date
I'm Trying to create an automatic status for a project that will say "Pending" until the Start date of the project is reached. I tried creating a formula field called Status and tried to use an if statement with zoho.currentdate, but it didn't work. Can someone help?
How could zoho forms be integrated in my website?
Hello! I what to know how could zoho forms be integrated in my website? For example, I created a registration form. I want my clients to register with your Name and email. Then, I have an email verification form to be sent to the client to confirm their email. And when/after they click on the email confirmation link their account is created/added in my database. I created the sample form using the "Creator" app and added the "CRM" app in the form (have the CRM app as invisible for other users).
Simple Calculator with Zoho
Hey there, I have created with Excel a simple calculator. The topic is a plastic specification called MFI. There are three different kinds of MFI: MFI 2, MFI 5 and MFI 21 I have created the calculation between these three. The aim of the calculator is to calculate the other MFI´s if you have got one of them. I.E. you have got MFI 2 and you want MFI 5 / MFI 21. MFI 2 MFI 5 MFI 21 Input 1 Output 1 4,5 100 As I said I have got all the calculations in all directions, but I can't implement this into
database sort issues
Why will my database not sort alphabetically. I only get 90% to sort using the sort and save feature. Please help
Try Editing Records via Record ID
I have tried to editing Records via Record ID(https://creator.zoho.com/jeremy.nagel/copy-of-teacher-database1/#Form:Teacher?recLinkID=<%=ID%>&viewLinkName=All_Teachers).It work fine and takes to record edit mode. But once I click on update button it redirects to this https://creator.zoho.com/appcreator/jsp/successpage.jsp page and wants to redirect to All Teacher view Any help appreciated.
Import multiple entries to stateless form
Hello, I've created a stateless form to update certain values in a selected record. However, I thought that I would be able, as with a non-stateless form, to import/upload a file with multiple data entries to have them all update automatically. However, there does not seem to be a way to import data with a stateless form. So, my questions are: (1) can you import data into a stateless form to achieve the goal exemplified below, and if not, (2) how do you change a stateless form to a non-stateless
can i insert data in subform by insert expression
Hi, I have a Form "Create_Invoice" with sub form "Product_Details". I want to insert data into the by a Create_Invoice data which ID I have given. I use following codes: invs = Create_Invoice [ID == input.invId]; insert into Create_Invoice [ Added_User=invs.Added_User Subjects=invs.Subjects Itemline_Products_Type=invs.Itemline_Products_Type Due_Date=curNewDueDate Discount=invs.Discount Sub_Total=invs.Sub_Total
Filter Zoho CRM Field and change columns?
I want to use a zoho crm field in my form. Its easy enough to use the drag and drop method of this but this seems to leave many issues. 1. When using the form and adding a value to the zoho crm field, how can i control what columns show in the popup window? The columns that currently show up when using the invoice module is the Subject, Status, and Grant Total. I want to change these columns and add a couple additional ones. How can this be done? 2. How can I filter out certain records from showing
Function to Look-up User Name or Email
I recently imported a bunch of records from one table to another and lost all the zoho.loginuser names. Yea, I know...should have been more careful. What I'd like is a function that can lookup Zoho's SSO usernames based on zoho.loginuserid or vice versa. This would allow me to run a script to update all the unique usernames, since these are essentially the keys for each record that determine who can view them. Cheers, John Whitney
Problem with using the "select" task for a multiselect lookup list - data won't be saved.
Hi there, I'm trying to pass values in my form from a text field to a multiselect lookup-list (on user input). When a certain string is entered in the text field, the exact same value should get selected in the lookup-list. This works fine while I'm adding data to my form. The values in my lookup list get selected. BUT: When I submit the data, the selected values in the list won't be saved! (In the second screenshot, the data from the list should show under "CRUs" - but it's just empty...). My simple
Field check and validation
Hello people, I'm new to this Zoho Creator and I'm developing my very first on line form. You can find it embedded here: http://www.suezo.it/iscrizioni-on-line (sorry ... it's in Italian!) This may be a silly question, but since I'm new to this it's causing me some trouble! I added a few "number" fields (quantity of tickets) but I need to check and validate numbers. Example: one field needs to be "20 or more" so I would like not to the form to be submitted if that field is 19 or less. One other field
Setting an end date 1 hour later than the
What's the simplest way to have the end date 1 hour after the start date for a calendar view? I tried adding a variable field and setting it to have an expression of Demo_Date_Time.addHour(1) which works but then on the calendar page, I can't set the end time to be that variable (it only shows fields with a date/time property, not variable fields): http://ge.tt/85F7Jmy/v/0?c
Not getting download request
Dear Sir, One of my client is asking to download my apps but I am not able to find his download request for approval. Please guide, how can I get it. Awaiting for an early reply as the customer has made payment but I am not able to approve his request. Regards, Abhinandan Sharma 8010855550
Employee Management system announcement link on homepage
in the employee management template, it seems when i create an announcement, that it appears on the home page but not as a link just as a listing. that you physically have to go to the announcement form to see it. How can I create a hyperlink to that view?
Syntax errors don't show on correct line
Hi Zoho, I've noticed that I get "improper statement" errors with unhelpful line numbers. E.g. try compiling some code like this: //send out editorial writer emails for each booking in input.Edition_Bookings { //check whether an email has already been sent to this writer writer_obj = Editorial_Writer[ID == booking.Editorial_Writer]; writer_email_address=writer_obj.Email; email_sent_to=booking.Email_sent_to_editor_email; if(email_sent_to != writer_email_address) { //either no email has been sent
Return value type from a map
Hi i'm confused about the map's 'GET' function return value type form the tutorial, it seems not have to do explicit casting https://help.zoho.com/portal/en/community/topic/map%28%29-tutorial-%28intermediate%29 but when i try the following codes (firstly, create a "num_val" number field) vars = map(); vars.put("Num", 123); num_val = vars.get("Num"); i got error message like this Variable 'num_val' is already defined of datatype 'BIGINT' but trying to update 'STRING' datatype so
Sales Rep Call Cycle Template
Is there a template that can be used by sales reps that would allow them to populate a few key data points that could be captured and roll up into a database / report. Key fields required being - Store location - XXX Manager name - XXX Store ranking - A / B / C Date - DDMMYY Inventory level - Nil / L / M / H Display standard - L / M / H Staff knowledge - L / M / H This data would then be displayed as a dashboard which would show the rep coverage of stores in their territory each month, benchmarking
Bug with capitalisation of variable names in new builder
See screenshot.
using the URL field with no URL
Hi All I am a newbie both to databases and this particular method of creating them. I have made a form with the main primary field being the identifying name of an item. What I would like is that the name is clickable to an associated URL path, if there is no link I would still like to see the identifying name. I have used the URL field but it doesn't like a blank URL field and if I use just http:// it brings up a blank page (not very elegant). The important part of the URL field for me is the link
Pass Record ID and Variable to a From via URL
I am trying to pass a record to a form and also a variable from a URL Link in another table field. I can't get this to work. Has anyone done this successfully or is this even possible? https://creator.zoho.com/tamyett/saleamp-services/#Form:Infographics_New_Form?recLinkID=1593428000001105925&Step_ID=57&viewLinkName=New_Infographics_Form_Report2
Form data formatting
Hi, I have a form which sends user input data to me via email notification but I want to know how to format that data in a presentable for in the email that I receive. For instance, one of the fields is a text box which can contain several hundred characters and I want to be able to condense that into a text box on the email, rather than just one long line of text. Anyone know how please?
Next Page