Add data to a view using Custom Actions without having to select a record
Hi, I need to load data in a view using custom actions. So for that i don't have to select any record. Is there any workaround to achieve this??? Thanks
Mapping DNS for Custom URL
Hello, I have set up my domain account, created my custom sub-domain, and tried to map my DNS. My domain is hosted by Bluehost and this is how I attempted to map the DNS. Let me know if this is wrong: 1. Went into DNS zone editor. 2. Added DNS record: Host Record: mysubdomain.mydomain.com Type: CNAME Points To: customer-creator.zoho.com 3. Waited 24 hours and tried to go to mysubdomain.mydomain.com, but it only brought me to mydomain.com. Am I doing something wrong?
Problem with fetch
I have an employee database and puting in employee information in another form. So obviously i am looking to autopoulate ID field automatically when a name is selected from a dropdown. So after watching a few fetch and set variables tutorials i am still unable to find out what the problem is with my form. I am unable to give the condition employee name==input.employeename because employee name is in numeric field. I am not sure why this is the case because it is a string field. Please help. It
Translate formulas from Excel to Zoho
So I have this excel file with some formulas. I was wondering if there is a way to translate them into Zoho. Not really sure if they will be a calculated fields or a script...I'm guessing a script. Formula 1 - Cuts text at character 80. If string exceeds 80 characters it is cut. Excel: LEFT(IF(A1),80) Formula 2 - Combine two fields into one. Text Field and Numeric Field. Excel: "TEXTFIELD1"&A1 Example: TEXTFIELD1 = Forum A1 = 13 Result: Forum13 Thank you for any suggestions. I really like Zoho. Mike
Saving & recalling MAP variables
Is there any way by which a map variable defined at any stage of form can be saved and later recalled for use ? For example on load a map variable is created and saved. The same map variable is recalled in form when other function such as submit or any custom button script is evoked.
Zoho.currenttime 1 more day??
How to use zoho.currenttime 1 more day to a field in the form? Thank you! ------------------------------------------------------------------------------------------------------------------------------------------- Solved! Used as follows: data_fim = (zoho.currenttime + '0W:1D:0H:0M:0S') It worked perfectly. Thanks to all!
API Name for subform rows
Hi From where do we get to know the API names for the fields of different rows in a subform. For example, if there is a subform called "Items" and it has fields "Item Name", "Item Price" and "Quantity", how can i assign the input value of these fields to CRM fields? For example: I have fields in CRM as "Item Name 1", "Item Price 1" and "Quantity 1, "Item Name 2", "Item Price 2" and "Quantity 2", "Item Name 3", "Item Price 3" and "Quantity 3", "Item Name 4", "Item Price 4" and "Quantity 4"? How
captcha/verification code not working - Firefox & Safari
Hello - I'm testing a form I created and embedded into my webpage using the following browser applications: Firefox 3.0.7 Safari 3.2.1 On neither one am I able to successfully submit a form because the form returns the message "Please enter the correct verification code." I can't find a resolution to these problems on your forum. Please reply with a current solution. The verification code capability is the reason I chose your service.
Creator timeout
I asked this a while back have had no reply. Come on folks, it can't be that hard! I just need to know how long it is before Zoho Creator logs you out or drops the connection, if you load a form and then wanter away for a cup of coffee. Is it half an hour? Ten minutes? More importantly, can this setting be tweaked anywhere? I have some people that need to run training courses, and the last thing we want is for the system to time-out before the clients click Okay!
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?
Next Page