Changed record owner "added user"
I have found that I am unable to use the "users" field in a subform for record owner. I have set the record owner of the main form with the user field. When the user update the subform Project Status,the user field is unavailable and does not synch to the main form. The workaround I believe is to remove the subform et al, and call it with a url but I have already put a lot of work into the application so it is not easy to disengage the subform. Any other ideas? Thanks
Calendar Events Do Not Span Multiple Months
I have created a calendar report in Zoho Creator with specified event START and END dates. When viewing the calendar, each event starts on the correct date. If the END date spans into the next month, the event spans until the end of the month it began, but does not appear in the next month. Has anyone had this issue? Thank you! Steve
Merge email fields from records
Hi, I have in Zoho Creator a lot of contacts emails fields. Is there any function that will allow to create an email to multiple receipients based on this or s function that will consolidate the email addresses in a new field and/or report?
How to create custom formula for shopping list
Hi there - Here is what I am trying to do. I have a business that allows people to shop with us I would like to create an application, that uses Zoho Creator, where users can click a check box and then get a report of the equivalent from our store. So for example If the form had a section called Bathroom supplies and there were a series of checkbox like like Soap Shampoo Mouthwash Shower Cleaner When the user chose a few products and submitted the form it would show our product and price based
Radio Field
Is it possible to have a radio field that eliminates displayed options as they are chosen. For example, I am setting up a form that has multiple date/time selections using the Radio Field, but I want the time slots to disappear as they are chosen. Any suggestions?
aggregate sum on field populated from lookup
Hi, I have a table [A] that contains currency values (€) in the field [cost_A]. the Form [B] has a field [cost_B] that is filled using a lookup on table [A] , field [cost_A]. Now I have to do a query con Form [B] with numerical condition on field [cost_B] and sum on the field [cost_B] to obtain a float (or a currency). It does not work, each field [cost_B] is fetched as 2894241000000618044 !!! any hint? tks, pippo
Setting default value for Lookup Picklist
Is there a way to set the default item from a lookup picklist so that it appears automatically? This option is available when it is just a simple drop down, but is not available from a lookup picklist.
Adding user name
I have a peronal account, which I'm using to try to get a buy-in from management to adopt Creator. When I want to add a ne user I can only enter an email and there is no way to change the name of the user. Is adding a user name part of the upgrade?
Users suddenly cannot access public files
Since today my users cannot access files that are public (both views and forms) WHAT IS HAPPENING??? THIS IS THE 3RD PROBLEM OUT OF NOTHING YOU CREATE THESE LAST 15 DAYS EXAMPLE: https://creatorexport.zoho.com/DownloadFile.do?filepath=/1435610456738_Sistema_CNJ__Processo_Judicial_Digital_-_PROJUDI_.pdf&sharedBy=raffbr2&appLinkName=cjuridico&viewLinkName=Arquivos_View_com_parent_ID When the users click on the file they are asked to login!
turn initial value to null in hide fields
Please suggest me how to set initial value to null in hide fields, if i don't choose them. For example when a rule is triggered form will show me field with initial value but if rules isn't triggered, initial value will set to null and will not show in report.
fetch lookup data in email notification
Hello. I don't understand what's wrong, please help: I have Form1 named "ICD" with lookup field "surgeon" to field "surgeon_add" in other form named "Surgeons_add . So i tried to fetch data to show the actual data in lookup field on email notification form ICD > On Success: surgeons = ICD [ID == surgeon]; test = surgeons.surgeon; then in sendmail I tried all variations sendmail [ from:zoho.adminuserid to:"ill@gmx.com" subject:"123" message:test + "<br />\n" + surgeons + "<br />\n" + surgeons.ID
Multi column responsive form
Hi Guys, Thank you for your work. I try to use form on my site and customize it to match the design. On desktop I need form in 2 columns and I set it in Zoho Creator. But on mobile it should be 1 column. How can I do it? And similar issue - how to do fields full width not fixed? Thank you
Auto populating the drop down
Hi, In My form four drop down fields are there,in that three have some choices and fourth one doesn't have choices.Based on validations i want to populate the fourth drop down with these three drop down choices is it possible?. Thanks.
How to modify default messages?
We set a registration limit on each of our forms. The default message that presents when the max is met is "Maximum entry limit reached for this form" . My question is, how do I go about modifying the message? I would like it to say something different; something meaningful to our users. Thanks in advance for your help!
Zoho Creator select page - form menu bug?
Deal All, I do not know if you face same issues with me but in huge applications with more than 10 pages when I try to select a page then I have the following menu (unsorted pages, some of them are out of the table width, we need to scroll down to choose a form etc). Me and my colleagues have the same problems in ALL the browsers. Is it a creator bug?
Debug
Hi, I am working on a function that has to be called within an html page. The function takes data from different tables and return a float. I am in troubles with this function and would like to know what debug tools may I use. Is there a way to populate a "debug table " with deluge video within the table? Allert or Info work within a function? Can a function return an array and not a single value? Tks Pippo
Why is zoho asking for viewers to sign in to an Zoho account where my contact form should be?
I built my two contact forms in Zoho creator. When I logged onto my webpage, zoho removes my contact form and asks viewers to sign in to zoho as if they have an account with Zoho. How can I fix this? Example is given of what viewers of my website see:
Pubblic page in customer portal
Hi, My application is entirely in Zoho Creator. My Customers use Customer Portal feature, they have to login since the first access. I would like to have a Pubblic page that my prospect customers have to view without login in. Is it possible? Tks Pippo
import - disable deluge controls
Hi, I have a form with a lot of deluge controls in on load, on validate, etc. Sometime I need to export the Table (using the report-export), elaborate it in Excell and import again. When I try to import the import wizard gives me a lot of errors due to the deluge controls. I have to delete deluge controls in on load, on validate, import the table and load again the deluge controls. Is there a smarter and quick way to do it? tks, Pippo
Using Functional URLs with iCal
Note: I had originally posted this as a question, but found the answer and deleted the forum post. I just discovered that one can use a single events-based database to create multiple ical feeds. In the past, I just created multiple new views of the database and then drafted the ical urls. The more elegant way is to use the functionality-based url criteria to filter the view, then draft the ical url. For example, in my event database, I have these fields: EVENT_SUBJECT, EVENT_ORG, EVENT_BODY, EVENT_START,
USERS CANNOT ATTACH FILES
Since this morning my users cannot attach files. We upload it on subforms, the file loads to 100% and the form hangs up "Wating for Zoho" and it does not advance We have a form with subforms, and in these subforms there are file attachments. Users cannot attach files. WHY DO YOU DAMAGE STUFF THAT IS WORKING??????? FOR NO REASON IT STOPPED THIS MORNING - THIS IS GETTING TOO FREQUENT
Creator Workspace renaming/creation
How do I rename a workspace within Creator? Alternatively, how can I make a new workspace and move my application there?
Change value of HTML page variable with function
Essentially I want to declare a variable in an html page then call a function that will change the value of that variable. Is it possible?
Backup Schedule
Hi I'm trying to set backup frequency as weekly in Backup apps section in the setup. When i click "Take a new backup" there is only one field "right away" why is no other fields there ?
Form disappeared
Hello. I was editing another form name and reports name and now the form " Add ICD procedure" has disappeared in view mode, but in edit mode i still see all fields and codes.What's wrong i do ? Please help me. Account name zoho_ill Application : My First Application ill@gmx.com Thanks.
Customer Portal (New User? Sign Up)
The new user sign-up feature does not send an email to the user upon filling out the form and signing up to complete the registration. Why would this be?
Error when attaching files
Since this morning, any user that tries to attach a file to my forms is kicked out of the application. Can you pls do something? Amazing your capacity to create problems out of nothing. My Zoho User ID : 26676849 application cjuridico Raul
search open url new window and headers
I have created a search form using a stateless form with the following on click: openUrl("https://creator.zoho.com/<myapp>/customer-support/view-perma/Customer_Report/Customer_Name=" + input.Search_Customer, "new window"); Three questions please: This works ok if same window is used. Using new window gives no result - how do I overcome? When I use same window and I get the Customer Report results there are no headers (i.e. dashboard tabs) and I need to use the back button on the browser. How do I
My first application in zoho.creator
Hello. I downloaded mail-merge-contacts application but i can't edit this in my control panel. Why ? I need application like this ( https://creator.zoho.com/public/showAppInfo?ownername=fmriorum&callbackUrl=mail-merge ) to realize that idea: User fills out the form and then script produce specific letter with specific blank from form like this and this file we can download in .pdf or .doc. Thanks !
Select from lookup only entries associated with previous lookup
I have a two lookup fields in my Projects form. The first is Customer, the second Customer Contact (Customer Contact is a subform of Customer). In the form definition I have this code: Customer ( type = picklist values = Customer.ID displayformat = [ Customer_Name ] allow new entries = true [ displayname = "" ] sortorder = ascending searchable = true width =
Cannot create new in Admin Panel
hi Zoho, Now, i created successfully 17 email accounts. But now, cannot, it show Sorry , we are unable to process your request, please contact support@zohomail.com when creating new email account
Cannot view images
Hello, We have lost our images- just get this: <img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/1434629830485_Screen_shot_2015-06-12_at_10.30.34_AM.png&sharedBy=rachelogg&fieldLinkName=My_Pic'/> Please let me know asap, thank you
Filters
I have created a delivery tracking application. In the view i just get option of selecting one filter where as i want to filter on 2 parameters. How can i do that? HS link2hs
URGENT! View criteria not saving
Hello, my views have lost their criteria and I have tried to add criteria in both the edit this application and on the main view. I keep getting the error message: FAILURE:Error occurred while saving the view. Kindly refresh the page and try again later. Please help!! Thank you
Wordpress - Zoho Creator Plugin - Loading
When I add a Page in Wordpress - Edit, press the Z button it stucks on loading... any hint? tks
Authorization failed - Adding record by mail
Hi! When I am trying to add a record using mail, I get this reply back. How can I fix this? Authorization failed You are not authorized to add record. ............................................................................................................................. <XXXX@XXXX.no> wrote : Hele navnet ditt : XXX XXX XXX Adresse 1 : XXX Adresse 2 : Din e-post : XXXX@XXXX.no Post nummer : NNNN Sted : XXXX Ledsagers hele navn : YYY YYY YYY ------------------------------------------------- This
Lead is not updating?
here is my code to update leadupdateinfo = zoho.crm.updateRecord("Leads",input.Company ,{ "Company" : input.Company, "Last Name" : input.Last_Name, "Email" : input.Email, "Phone" : input.mobile }); no error but not working. in Id=input.Company is not fetching the current record id?
how to update a record in zoho crm from zoho creator?
help? i am confused where to write the logic?
how to genarate a Account in zoho Crm if user entered details in form(zoho Creator) and vice versa?
i want to entered details(with automated process) whenever a user enter details in form (from zoho creator) that should be added to accounts in zoho crm.
how to retrieve zoho crm data?
i have one statelessform name "search" in which i have username a single line text and one search button. when i entered a valid username it search the data and display in page(html page). but i need to add related field data as well. from where i am searching i have one field account name(ZohoCRM) i wnat to fetch account details as well how?
Next Page