Customer Portal, open url passing logginguser
hi, Using the portal, I want to have a stateless form where depending on a picklist selection, the user will be redirected to another form in the same customer portal application. The issue I am having is that by using the openurl function, when the user is redirected to the new form, the loginuser is no longer recognized and is being asked to log in again... how can I direct the user from one form to another in the application without loosing identity? Regards Luis
Rotation on larger mobile devices
Is there no rotation feature on mobile devices? If I use a docked ASUS Transformer, the screen doesn't rotate. I can no longer use a full keyboard for data entry. Is there a way to enable rotation through the Zoho Creator mobile app?
using Formula Field for Totaling or ??
I am trying to use a formula field on a form to total up 9 currency fields to generate a total that the user can see and then I can use to initiate a Payment. I can't seem to get it to accept all the fields? Is there a limit on the number of fields the formula filed will accept. Is there an easier way to do this with a currency field? I am new to Zoho and trying this out for the first time, so any help is appreciated. Thnaks
How do I bring the price from my product/service form to another form linked by a look up field?
Hi, I am trying to figure out how to get the price from the parent form into the child form. I am kind of new to this and haven't been able to figure it out. Any help would be appreciated. Parent Form Form Link Name: Add_Product_Service Fields: Product_Service_Name, Price Child Form Form Link Field: Kit_Sub_Form Fields: Product_Service (Linked by lookup field from parent form), Price (NEEDED FIELD FROM PARENT FORM) Note: The Product_Service and the Price of the child form will be used by a subform
Show summary on submit
I want to show the summary of the inputted data on pressing submit so that users can review it and print it. I tried redirecting the On Submit to the report page, but no success. It just lists all submission.
Column Width for Rich Text Field
In a report it seems that setting a custom column width for a rich text field has no effect. My users type a lot of text and the reports are getting cumbersome to navigate.
Conditional Formatting Not Working
Hi, I am very excited about conditional formatting, but when I applied it to my calendar, and a few reports, Nothing happened. I followed the directions very closely. In this example, the formatting is applied to a report in spreadsheet view, where I want the field "case" highlighted when the date due = today. Can anyone see why this isn't working? Thanks, Amanda
Help With the Right Path in Zoho
Problem: My wife runs a charity, and I'm thinking about using Zoho to capture requests for her product. The product is free, but there is a shipping fee. The charity only helps people that meet certain requirements (income level, number of children, etc.) and the user must submit attached documents proving they meet these requirements. These are then reviewed by staff and, if approved, they are invoiced for shipping and then sent to another group for fulfillment. My Struggle: My issue is that Zoho
How to not save null records from a subform when I click submit
Dear All, I would like to ask you, if a have a subform in which I have set 20 as default entries-records but I only use 3 records, how can I save only these 3 records and not the other 17 which are emty-null?
zoho ed platform
Hi as an educator who uses a variety of blended options to reach and interact with my students and tutors, it would be great to have an integrated Zoho platform something like Wiggio (perhaps). Anyone else interested in this? (Isn't it counter productive to need to choose a forum for such ideas? By definition, they don't fit anywhere!!)
Create a table based on two or more forms.
I would like to create a table from two different ways using columns expenses (Ganancia Bruta,Ganancia neta, etc) in two different ways, for example. Do not know if I explained wellI want use what they I show in the following pictures: want to create a single table with a lot of data from different periods, different columns, different form and think "Auto view" limits me to only what is in that Form Thank in advance!!! Happy Holidays!
Custom function
Hi, I am trying to create a custom function or something like a button that when user execute this function it will input a specific text (URL) into a specific field. please see below screenshot where in the "Update link" field I want to input below url link when user execute the custom action. input.Update_link = "https://creator.zoho.com/mikekokernak/across-platforms-web-proxy/#Form:Update_TV_Station?Update_TVStation=" + 798107000000666628 where 798107000000666628 is the corresponding ID number
Access value of a lookup field
A simplified version of a problem I have: I have two forms Projects and Clients. Projects has a lookup field Client which looks up field Client on form Clients. I want to access the value of Client. In a Field Action on Client on User Input I have the Deluge command 'alert "Entered: "+input.Client' . The message box shows "Entered: 2440810000000112935". How do I get the value of Client. Thanks!
attach a pdf document to a form
hello, I have a service app that I'm working on. It has come to my attention that the end user needs to be able to attach a PDF document. Is there a field type that will allow a PDF document to be uploaded as part of a new entry? Happy New Year, Alan
Embed & controls
I am embedding my databases into my web pages, and all seems okay, except I do not get the "tape recorder" functions at the top right of each page, which allow the viewer to move thru the records a page at a time, instead of individually. Backwards one page, forward one page, first page, last page. What do I need checked "SHOW or HIDE" in order for those functions to appear at the top of every page ?
URL parameter using Equal OR
I would like to know how to pass a parameter in a URL for a view in the form of " variable=A or B or C" in other words, take this URL: https://creator.zohopublic.com/yaxche/catalogo/view-perma/Fotos_2/aYh5B2kTxt3NX2AF4GnaMbPqfeb3qGUy7en5YYeZa1O0DzyRkhkbwq0B2kmfrSQ3juTUf2TDK3mrezZuv7zvBj5p5ksuK3TPheYF?Numero=2 here I am passing the parameter Numero=2, which works fine. The view shows the record where the value of "Numero" equals 2, the issue is that I want to display more than one record, for instance,
Scroll to bottom
Hi, I have a stainless form which have really so many fields (around 50 ) .Usually user does't have to fill up all fields or doesn't need to interact with most of the fields except some fields which might be first 10 fields that user frequently update. So what I am looking for is if I can input a button or something like HTML tag ( Scroll to Top or Scroll to Bottom) so user can go directly on the position of "Update" button of the form which is on the final portion of the form. This way user won't
Extracting information from an email.
Im creating a booking system for a hostel. We receive regular emails every time a booking is made through hostelbookers. Everytime a booking is made an email is sent. What i would like to know is how extract data from an email, every email is written in a set format. I know how to forward the email to the zoho email address so that i can import the message body. But is it possible to tell the database where to extract information from that message body, such as number of people, date?, because the
Conditional Pick list
An elementary building block for databases is to filter a Lookup field by the value of a previous lookup field. Some common examples are: Countries filter for States, States filter for Cities and so forth. This is billed as a very easy database to use any yet there are countless descriptions on how to achieve this tiny task. We should not have to spend hours grubbing through old forums to find an answer! Can someone point me to a simple method, clearly explained, with perhaps two or three examples
How to modify mobile views
Hi, I asked this yesterday, but maybe something goes wrong because I can't see my question in forum, so I ask it again: How to modify mobile view of the report? I have 2 fields in my report and I would like to see them both in same row. 'Edit' and 'delete' commands should also place in same row. -Toni
Send automatic email
I wish to send automated email when you register operations. if(Proyecto1[ID == input.Proyecto1].count() > 0) { x = Proyecto1[ID == input.Proyecto1]; //input. refers to fields in current form Email=x.Email; sendmail [ from:zoho.adminuserid to:input.Email subject:"Subject of the email" message:"Your message" content type:HTML ] } I have done different methods used en the same a fetch mail, etc. I could not send mail. I want to know as how to send an email to a client of a lockup or fetch.
display particular name's profile
i am creating a member details management. in view it displays all members details. if i click a particular member name i wnt to display his profile alone in the page how to do it?
The Creator API is Broken... Again.
I think your API is broken again. Test data1 = postUrl("https://app01.nutshell.com/api/v1/json","{\"method\" : \"getApiForUsername\"}"); input.ResponseBox = data; So what this tells us is that the postUrl method is broken. Can you guys fix this on your end?
Update lookup field using Script Builder
Hi, I need to update a lookup field value based on the value selected in another field, how can I do this? Thanks.
Creating events in Zoho Calendar using Zoho Creator.
Quiet simply, how do I do it? I am having trouble finding the information. Any help would be greatly appreciated.
How do I copy the data from another Application
I use the lookup field to get the data from 'another Application' so how can I copy to new form -new field. (Like the pic) I need to get data '8' in cavity field?
Fetch oldest dates
Hello Zoho Creator Users, I have a question for a report functionality. I have build an object list for vehicles. Each vehicle must be periodically inspected for various points. The dates of inspections are known and are located in the future. I would like to make a report which shows the upcoming, most recent, inspecting date. I tried to filter the report, but I can only filter one column. I think I have to make a blanc field, and this field must always fetch the oldest date of all the fields with
Embed database in webpage
I am trying to embed my databases into several webpages. Seems to go okay. I note that although all of the databases are marked (or not checked) to prevent anyone from making changes, when I embed in the web pages and publish, some will only have the SEARCH option for viewers (which is what I want), but a few will also include the ADD option, which I certainly do not want . And this ADD function will actually add to the information. I don't see any thing different in the makeup of those databases.
Count of new rows in menu
Hi, can i do this? in my ZC dropdown navigation menu, is it possible show last new added rows in view? for example ORDERS New (2) Completed (0) Canceled "2" - the count of new rows in the table view. When i click the table view an then close, the count return to "0"
Formula field format
Can I format a formula field in the report? The field value is the subtraction of two currency fields, but the result is show as long.
Transfer Form Data to External Form
Hello, I have a typical form, where I add my student's data: name, email, phone address etc. In an external website, I have to copy-paste the above student's data one-by-one in a form, in order to apply to an organisation to acquire exam date for my students. Imagine that I have 50 students with 10 fields = 500 copy-paste actions. Is there any way to bypass this procedure through a function (maybe) or another action I can't think of. Thank you!
Launch view with search criteria
Is it possible to launch a view with a deluge statement with search parameters? For example, I have a view with Contacts and want to launch from a custom action in another view only those contacts that comply with certain criteria (coming from that othet view). can this be done? thanks Henk
Sum when add specific value
Hi, I need create the script to sum $5 every $50 added to the field.
Search Engine vs. Web Page
I want my databases to be seen and found thru search engines. But they don't seem to appear or if they do are way down in the relevance order. Will I have better luck with them being found as stand-alone databases or as a part of a web page ? My web sites all score high in the search engines.
User privileges vs admin privileges
So far, We are using Zoho Creator with 1 same login I would like to set User Privileges 1) admin can do anything 2) Users - see, add and edit info 3) if possible : each user has access to his records (sales orders) depending of a code in a "user" cell in the form (example : the sales rep called LF can see only the records were LF is put in the "sales rep" cell) Is it possible ?
How to add a total ?
How to add a total down on a list with numeric field that changes depending on a selected records ? (dynamic total)
Custom Customer Proposal
Hello I currently have created a Form that collects information for a proposal (Customer Name, Address, Products, Price, etc). I want to create a customized Page that allows me to present that information to the customer. The goal would be to make it so that I can email the proposal to the customer for them to review what we will be doing. I can easily create a custom Page using either Rich Text or HTML but I am struggling on how to populate it with the information from a single record. Do I:
Record Level Security & Permission
Why I already upgraded to ENTERPRISE USER still can not use this fuction ?
Transfer data to and from web site
Can someone help with some logic please This is all an example of what I am trying to do So my web site has a line that says "hello I am a x" On my database I have the following fields Number Hello I am a Code in on user input in Number is if(input.Number = 1) { input.Hello_I_am_a ="Dog"; } if(input.Number = 2) { input.Hello_I_am_a ="Cat"; } if(input.Hello_I_am_a = "") { Number=1; } if(input.Number = 3) { input.Hello_I_am_a="Mouse"; } if(input.Hello_I_am_a = "") { Number=1; } if(input.Number
how to autocopy files from entry to dropbox?
hi how can i automate copying files from creator app's entry to my dropbox account?
Next Page