Service aplication
Hi all I need some help. Our company services printer and we need to create an application where our clients can log a serive call online. The application then needs to send a mail to our service department and to a technition to start the job. Every day the application should send a list of all the service calls that needs to be done on that day. We also need our technition to log on to a new application and states of the job is finished and what parts has been replaced. That application should
Is there any onload event for a view just like that for a form???
Hi, Is there any onload event for a view just like that for a form??? If no, is there some workaround for the same ??? Thanks
New Zoho App Builder
I was creating a New Apps, when i tried to change my Apps name disappear for my Apps List, i don't know why, I was searching in my explorer historial, I saw the link when click in this link send me a message like this You have logged in as eylin.cedeno. You are not allowed to access this application. Please click here to login as a different user. Click here to go to your Home Page. Can someone help me!!!
Access restriction by IP address or range (urgent!)
Hi I seem to remember having seen somewhere that access to Creator apps can be locked down to specified IP numbers. However I can't find this feature anywhere now, and can't find any reference to it in the documentation. Has this been disabled? Anyone got a reference URL or some advice for me??
Can ZOHO......?
Hi, I'm a regional manager for a Hotel management Company and I'm hoping for an online data solution for the following goals: 1) Each hotel can login to a central system and enter their hotel's information (weekly & monthly). 2) This data can be combined to provide a company performance sheet of all hotels. 3) Data can be selectively shared to owners (i.e. 2 hotels may only be shared with one person). 4) Data is stored in such a way that future modifications can be made to present old data in different
Upload and read CSV file line by line
I am looking for a way to upload a CSV file and read the contents line by line. I have the form named CSV_Importer and the field name is CSV_Upload So far I have ... for each row in CSV_Importer [CSV_Upload != ""] { echo row; } I'm familiar with PHP and can script in Python , but I'm not understanding the syntax because the above gives me errors in the script builder.
Help Needed
I am looking at using zoho for my small business. It is just me. I do about 15-20 invoices a month and have about 50-100 or so clients. If I just use the free account, how fast will I eat up that space and size restrictions? I don't know much about all of that. I don't want to end up having to pay $25/mnth when there are cheaper options out there so I don't want to start using zoho if I quickly run out of space.
How to create a button in a custom view, that prints the view?
I have a custom view, that's generated from a stateless form. I'd like to give user a button to print the data. I guess it can be a button in the stateless form?
Show/Hide View Columns dynamically
I think it'd be cool to be able to do this. For example, based on zoho.loginuser, show certain columns to different users. With a database to define user roles, we can even customise whether columns appear according to roles.
how to create a lookup of zoho users
hi i am loving this zoho creator! i would like to create a dropdown menu that contains other users of this same application. ie. all users with access to this application. how can i do this? also would like to filter this list so if i have added the user to a specific group then they should appear in this list. keen to move on this as this prodcut looks good for our company cheers Lathan
Import Connection Error
Hello, I get an error when after giving Zoho Creator access to my Google account. It will not connect when I try to import contacts. Any ideas? Thanks Aaron
HTML inside a list view
Hi! Is it possible to add an html piece of code in a list type view? I am trying to put a green rectangular block in one of the columns of the list view. If yes, plz tell how?
Restore fails. Does backup/restore function?
I'm at a stage of trying to import old data into a newly built app. Not wanting to kill it with dodgy old data I duplicated my project export/imported all existing lists and created a backup of it. Under Backup Apps I now see mandoe-tech-dev v1 2013-05-13 13:59:01.0 Download Restore Seems good! When I hit restore I'm presented with a dialogue in which I can change the name of the retored app if I want, I went with the default "mandoe-tech-dev_new". After the all to brief restore process I browse
URL based filter on lookup fields within a view
Hi Guys, I have tried to keep this simple, I have the following table relationships: Client ----< Properties ----< Assets (i.e client has many properties, a property has many assets). The Assets table has these fields: #Property (lookup) #Asset Name #Asset Number I have a view that displays: #Client (related field to property - Linked) #Property #Asset Name #Asset Number This works fine, except I am not able to include a filter in the URL that filters on the client field (e.g. ...#View:Assets_View?Client=Sorbon)
Favicon
I noticed that in switching between domain and personal accounts the favicon is not transfered over. It seems to take the one from the domain account over the personal account. BTW, I switch back and forth because I have shared workspace apps with clients that disappear in the domain account. Cheers, John Whitney
Inject parameters in string
Hello to all, May be it will be usefull for somebody. Very ofthen I need to construct string values in such a way: some_value="Bla-bla-bla "+thisapp.somenamespace.somefunction(input.ID)+" sdfgsdf:' "+input.someInt.toString()+...... and so on And when you need to change text - you waste so many time to find and change all quotes, to close them. You can use this function to inject parameters in string value like this (f is a name of application with functions) someValue=f.print("User _1 changed value
UI Tab redirect
Hello. First sorry for my bad english i'm russian :) . I use UI tab container for data but basic functional is not solved my problem . I want redirecting to another page by click in navigation panel. Not showing content in tab body. I trying this solution from stackoverflow : $("li.last a").unbind('click').click(function() { this.href = $.data(this, 'href.tabs'); but still not have wanted result. How i can do this ? Thanks for any help.
UI Tab redirect
Hello. First sorry for my bad english i'm russian :) . I use UI tab container for data but basic functional is not solved my problem . I want redirecting to another page by click in navigation panel. Not showing content in tab body. I trying this solution from stackoverflow : $("li.last a").unbind('click').click(function() { this.href = $.data(this, 'href.tabs'); but still not have wanted result. How i can do this ? Thanks for any help.
Group security
My clients are complaining that they can no longer see some forms or views. The PROVISIONING forms and views are shared to the Provisioning group. I have 16 members part of the provisioning group. Users in the group can not see the forms or views that are shared to the Provisioning group. Previously it was working. Is anyone experiencing security problems?
passing 2 or more parameters to an html view
So in the example: https://www.zoho.com/creator/help/views/create-html-views.html htmlpage "Expense Report By Date"(From, To) <%{%> ................... .................. }%>but what would the script for the button be??? openUrl("#View:ExpenseReport?from=" + input.From ???,"Same window");
Script doesn't save properly
I am trying to save the following code to one of my scripts for each schedule_row in input.SCHEDULE { thisapp.udf_ccc.get_ccc(input.CUSTOMER_ID, list({schedule_row.SITE_ID}), schedule_row.ALL_SITES, input.AGREEMENT_ID, schedule_row.SCHEDULE_TYPE, "0", "0", "0"); } for each variation_row in input.VARIATION { thisapp.udf_ccc.get_ccc(input.CUSTOMER_ID, list({variation_row.SITE_ID}), variation_row.ALL_SITES, input.AGREEMENT_ID, variation_row.VARIATION_ID, "0", "0", "0"); } When I click Save Script, I
Defining contents of a lookup dropdown field
Hi, I have an issue with my application I was hoping to fix. I have two forms: - Client (Has fields for "Client Name", and a Multiple Choice field for "Project Name") - Staffing (Has a list of staff names, and Lookup fields for both "Client" and "Project" fields from "Client form" I want to find a way that if the Client is selected in the Lookup dropdown, then the Project dropdown contains only the projects against their name in the "Client" form. Does anyone know if this is possible? Regards, David
Change text color in a view
I would like to be able to have different color text show in my view, or be able to change the background color of the box where the text is. For example, under view, I have a list. One of the columns is STATUS I would like for it to list like this: NONE - Black Arrived - Blue Delayed - Red Finished - Green. I figured out that if I just put HTML code into the drop down menu like <FONT COLOR="RED>Delayed</FONT>, this will work. But I have a lot of other IF statements and other things which will
Add record by post url stopped working
I have been using a post to url with auth token for awhile . Today at 10:30 it stopped adding records to zoho. I have changed nothing please advise
Zoho Creator Regular Standard plan: how many email notifications?
Hello Zoho team, I want to select the correct plan for my customer, who needs email notifications that will be kicked off by Schedules. The Zoho Creator pricing page (https://www.zoho.com/creator/pricing.html) shows the different plans available. For example, Regular Standard has "5 Users; 10,000 Records; Storage - 1 GB; Unlimited Apps; 10 Reports; 50 Schedules; Backup". (Note: it does not mention email notifications) Underneath the plans it lists the Add Ons to those plans, such as "Email Notifications: 500
I cannot use order by clause in select ouery of my html view...... ????
there is always an error of xmlparsing.. i m getting data from reports and showing it through xml parsing but order by rand() clause used in the select query of my html view is not working all others are working....and that orderby rand() is also showing results in reports query table..... can anybody have an idea how to run it ...
modification of email on custom action
If we wish to modify the email before sending on custom action, as per the record in the view .. How is this possible?
Export Dashboard to excel
Dear all, Where is the export to excel option in Zoho ? is it possible to export to excel.
App location? (Future proofing an app)
I have my first app currently being trialed by my company. As I created the app the URL for it is "https://creator.zoho.com/my_user_name/my-app-name" but what happens at the point when I decide to leave the company and they want to kill off my account? Am I better off having the app run from a generic account from the beginning i.e. "support_dept" and setting myself as the developer or can a backup be performed by me and then restored by another user at that time so the URL will change to be their
Script sort by code disappears
I want to show results sorted alphabetically. However, I am finding issues with the sort by code disappearing after I try to implement it. When I try to save the following code c = (CUSTOMERS[CUSTOMER_ID != input.CUSTOMER_ID].CUSTOMER_ID sort by CUSTOMER_ID).getAll() in my form script, I see Script saved However, when I refresh the code, I see c = (CUSTOMERS[CUSTOMER_ID != input.CUSTOMER_ID].CUSTOMER_ID).getall(); Script generated I have tried both in the Script Editor and Free Flow Scripting. It
Place View under multiple tabs
I want to place a VARIATION View under the AGREEMENT and PROJECT tab. When I created the view, the "Place this View under" only allows you to select 1 tab. How can I make the view visible to both tabs?
Email notification on request
I'd like for an email notification only when I decide at time of entry. I created a field "email_notification" of the type "Decision check box" What would be the better strategie for allowing email notification upon checking that field only.
success message - Specify Duration(Optional)
Hi, Please explain the type of input expected when setting on a form its On Success success message. Is it units of seconds? Should it be written 8s? It is not explained in this page: http://www.zoho.com/creator/help/script/success-message.html Many thanks,
Warning prompt on custom action
How can i show warning message on custom action??? Help........
My App is gone
My app I have been I made is gone from the index view. I can't make backups of it. Also If I go to http://creator.zoho.com/home/index it shows I have no apps but if I manually go to the link of my App it still exists, and I can access it that way. Is there any way to fix this issue so I can make it appear in my index and also make backups of it? Many thanks
usage limit notification
I received an email with an alert stating "You have reached the maximum Schedule limit permitted for this account. Please upgrade to add more." What does this mean? On my zoho home page it says ive got no schedules created.
Importing Data to fill various fields in a form
Sorry im a complete NOOB and not sure if the subject has been posted. Sorry in Advance. What I want to do is to do a form in wich you do a lookup for one field and automatically fills all the other fields in the form. Im trying to create a method for planning industrial equipment Maintenance. So I have a form in wich I enter the data of all my equipment, so now I want a form in wich it imports the Data from Form 1 to Form 2 and in Form 2 enter the Maintenance Date. Now you can import data for one
Temporary fields in Forms with store data in Creator
Hello! Very often I need to have some field in Form, which I use only for control of Form behaviour during displaying, and dont neet to store its value in database. It will be great if I can set parameter for each field "Don't store value in database" For example desision box which is used for displaying or hiding group of fields, or auxiliary lookup field, which help to control data in Form while editiong and so on
Adding Sorting in dynamically generated HTML VIEWS
hELLO tHERE.. please help, i am puzzled in a very tiresome task from 2 days, i want to add the sorting functionality in a html view created dynamically by using api mapping with reports..... please suggest me some other way if that's not possible.....
Invalid Entries detected when updating records from the Report view
I am receiving the Invalid Entries error when editing records in the report view of a couple of my forms. This will be a required feature of the application for actions such as administrator approval. It appears when I select Edit on a record and then Update it, even if I have not changed any of the data in the record. Usually this issue does not occur for the first update I make but then persists for no obvious reason.
Next Page