Export report to email?? Possible or not?
Can i ask if this is possible??
Formula data type doesn't show up as Currency
I have a formula field (Revenue) that is calculated from multiplying a Number field times a Currency field. The result is not showing as a Currency field. Details: Qty is a user-input field, data type is Number Price is a user-input field, data type is Currency (USD) Revenue is a formula field, (Qty * Price) -- it should be shown as a Currency type, but it's showing up as a decimal field. How can I make Revenue show up as a currency data type in my views and reports??? Thanks.
Cannot iterate all values of a subform in HTML view. Only the first one appear
Dear Zoho team, I am working on an HTML view (page) add it to a custom function in a report and it works fine. It is a "Product_Offer_Sheet" HTML. It will fetch data from my Form "Create_Product" No problem about that but in this HTML view, there is one table where I must display the composition of the product which is in a Subform "Composition" of the Form "Create_Product" I did the following code but I can only see the first record of the subform htmlpage Product_Offer_Sheet(id, hidePrint) displayname
Newbie needs expert advice PLEASE!!! :)
Hi All, I have two forms, Job Enquiry and Customer List. In the Job Enquiry I have a dropdown box field that selects if the client is new or existing. If new is selected I want to be able to automatically open the customer list form and complete the add new customer data entry. If possible I would like to be able to select a client company name from a drop-down list in the job enquiry form and the other associated fields from the customer list (I.E. Contact name, telephone number, email, address,
How I get the content of lookup field rather than record ID in NEM?
Hi, I need to make tips according to the lookup field contents, such as : if ( lookup = "male" ) { alert "You're a man"; } else if ( lookup= "female" ) { alert "You're a woman"; } But now I get ID from lookup field, should I need to search data using ID from another form like this ? var = form[ID=lookup]; if ( var.sex = "male" ) { alert "You're a man"; } else if ( var.sex = "female" ) { alert "You're a woman"; } Is there any way to get it convenient? Looking forward to your reply.
Zoho Creator Mobile Version
Hi guys, Still quite new to Zoho and how it all works. We have previously used Zoho Creator as an entry form - as it's a great way to get a database of people that Opt in. This is the old site we did and integrated Zoho Creator: http://www.adlab.com.au/promo/ The only report back we had it the site didn't work well on Mobile Devices. We now have a new promo starting and they want it mobile savvy. Just wondering can you use Zoho creator generated code to work properly within a mobile site? Please
openUrl vs record-edit
I use my ZC app in a Google App window (i.e. thin border, no back forward button etc.) When I use: openUrl("#Form:... , "Popup window"); to open a form and populate it with data ready for any additional editing then when I use 'Popup window', the form opens in a true popup in the original app window and when I click Submit, the popup closes leaving the original window as was. When I use: openUrl("https://creator.zoho.com/.../record-edit/.../", "Popup window"); to open a form for editing
Adding Data From Email (Disclaimer, Signature, Images)
Hi has anyone found a way to get Zoho Creator to ignore footers at the bottom of an email when adding data to a form through email? I have setup an excel file that uploads to our database however I have found many of my clients have a Disclaimer, Signature, Images etc at the bottom of the email. I am getting excel to generate the email as n HTML file however any text after the form information causes Zoho to generate an error. I contacted support and was told the is no work around. This is a huge
please help for this
hi, our Organization basic requirements needs enlisted below 1) Authorization:- Admin assign roles to user then same roles will be approve or reject by Manager , according to that user can access forms. In case if Manager reject role same will be informed to Admin. 2) Sending Mail:- In case there are errors while importing data ,send respected errors as attachment to Manager and user. Then Manager will check data and approve or reject data. 3)Data Import:- When user import data ,same
Can we upload images from zoho creator to zoho Crm
we have a feature to add image in Creator and can we get the same image into the zoho CRM invoice ,like i want to create a customer Catalog and when a purchase is happened i need that image to be on the invoice.invoice contains ,Cus name,phone,collection name (image),model no and price.....
Making report based on existing report instead of table/form??
Hi All, I have two forms. Form 1 contains Product related details and form 2 contains stock related details. I linked both the forms to get product-wise stock related details. Now, if I want to link another new form to this report. How can I link it in Zoho creator? Please help!! Thanks! in Advance.
Adjust column widths in record view
Hello All, I am attempting to create a record view containing a table where the column widths vary. I inserted a table into the view with 5 columns, which creates equally spaced columns spread across the width of the view. I then edited the code for the column %'s. The column widths adjust as expected in edit mode. However, when you go to the record view in the application, the columns are still equally spaced. I am experiencing the same issue width the border weights for the same table. Any
Cancel Delete if there are records in another form that are related to the form I am trying to delete
I think this is simple. Basically if someone tries to delete a PO that has a single or multiple time records associated with it I want it to cancel the delete. I am not sure if I need to count and then create a condition off of that count for it to work? For example, rec = Employee_Time [ID == PS_Work_Order_Purchase_Order]; if (rec != null) { alert "There are Labor / Equipment / Material records in the database you cannot delete this PO / WO!!"; cancel delete; }
business rule.
Hi, I am trying to add following business rule. Please let me know how can I do this. Check box1 Check box2 If the check box2 is checked we have to make check box1 as mandatory. Can this be done by creating creator rule or do I need to do this by java script. Thanks in advance.
How to Make HTML Content Editable without JavaScript / jQuery?
Dear Colleagues, My question is general and I do not know if it is possible to do that in Creator. Let's say that I have an html page with a simple table like <table> <tr> <td contenteditable="true">Hello!!</td> </tr> </table> As we know, HTML has an attibute called contenteditable, in which we can edit the data in our page. The problem is that if I change the text and then click the Print button, it returns 'Hello!!' and not the text which I last inserted. I think that this is because
You have reached maximum number of rows. You can not add further.
Using an funcion, and adding a attachment in subform, Zoho is telling me that I have exceeded my maximum number of rows (110,000). Does anyone have any idea why that might be the case? Thanks Mike
Publish app to client and relinquish ownership
I want to publish source and data to a client and then allow that client to publish the app as if he were the creator. [What I am really trying to do is "give" the app to this person to develop and use as they see fit.] I can publish the app and the client can use, edit, and share the app with his users, but when he goes to Developer Zone, it shows he has 0 apps developed and there are no apps that can be published. The only things there are the apps I shared with him, which are under "My Installed
Problems in sharing my applications
I have tried to share my application as public. It didn't get shared, neither did it show any messages to me about why it did not get shared. But making a form as private from public is happening successfully.
Issue Uploading Logo
I'm sure a ton of you will pass this post right up, but that is alright by me. I've been winging it through trial and error and answering most of my own questions. The embarrassing thing is that I cannot seem to upload my logo. The diminsions are exactly 90 wide X 55 long, and the file type is a .png. When I go to upload, the upload status bar just keeps going and going. Am I missing something?
Is there an easier/better way to create a script that repeats n number of times?
nline = List:Int({1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}); cntLst = List:Int(); num = input.n; for each integ in nline { if (!(num == 0)) { cntLst.add(num); num = (num - 1); } } for each ent in cntLst { some proceedure } Any help would be great!
How to restrict users from exporting
Hello, I need to be able to restring the people who have access to my database from being able to export. Right now when users access my database they are able to export to PDF and CSV as well as other options. Is there any way I can stop this? Thanks.
Application Domain Mapping
Is it still possible to map a domain to an application without using the customer portal feature? Cheers, John Whitney
Expiration policy... specific number of days
I see in the Terms of Service a mention of account expiration due to inactivity, but it doesn't say how many days. Can you tell me how many days of inactivity will trigger account (or application) expiration? http://www.officeswap.com
Trouble with function to update field with current date via custom action
The custom action button in my report runs and displays the success message. However when I check the Quote Sent Date field it is empty. Here is my function code void SentRFQ() { rec = RFQ [ID == ID]; rec.Quote_Sent_Date = zoho.currentdate; } Any ideas
How to determine if the lookup dropdown does not have a selected value
I have a master form: Branch Master - ID - Branch Name Another form - Account Name on Account Branch (Lookup from Account to Branch Master on ID column of Branch Master) On the Account form, when I write this code input.Branch != null to determine that the lookup dropdown has a value, I can't even save the script. How do I determine if a selection has been (or a selection has not been made) made on a lookup dropdown?
Access database from iphone app
Hi, I'm creating an iPhone app and wish to populate my remote database with zoho creator. I wonder if it is possible to access my zoho creator app's database from this iphone app like one can access a random remote mysql database. If so, how ? I didn't find any documentation on zoho's api's... Thanks.
Public Access and Login
Hi, I've built an application that I wish to make public and commercialize. Is it possible to customize the registration for my App that combines with your login registration? ie I want to ask additional questions and log them plus send login confirmation with username and password. Key reason is I use the login variables within creator throughout the App and if I make the app public with login I think I lose this variable use, I'm not sure how to get round this. Also want to change the Home option
Duplicates/launching same application multiple times
I'm creating an application that I would like to launch to all students on campus. I would like to relaunch the SAME application every semester to update the students file on which classes they have taken. How can I do this? Also, how can I make sure that every time they fill out this application, their information will automatically update their previous report and not add a duplicate student with the same name? Thanks!!
Zoho Creator Accessibility
I'm interested in raising the awareness of web accessibility concerns within the Zoho Creator community. Some people cannot use a mouse, including many older users with limited fine motor control and users with impaired vision. According to the World Health Organization 285 million people are estimated to be visually impaired worldwide; 8.3 million in the US alone. All U.S.government and most educational institutions are required to have their IT systems meet minimum accessibility guidelines. Zoho
System Fields Missing from Report GUI
I wanted to create chart displaying a running total of sign-ups but "Added Time" and "Last Modified Time" are missing from the report builder GUI. Where did they go? Cheers, John Whitney
hi with sendmail functionality is below stuff is possible
hi, using send mail is it possible that 1)After successful upload of data it send mails to respected user and manager 2)In case there are errors while importing data ,send respected errors as attachment to Manager and user. 3)Then Manager will check and approve data. hi if above stuff is possible tell me how?
What is the Easiest Way to Exchange Registration Info
I am a newbie and have successfully created a "Student Registration Form" within ZOHO Creator. Since students contact me to register – I would like to just send them a link that goes straight into the registration form – Once they complete the form and submit it – I would like to get the notice (back to my email) their form is complete. I want to be able to insure that a student can only see their form and nobody else’s. Can you please advise the best way to do this or direct me to a on line tutorial
Subform Bidirectional lookup
Hi Zoho Team, I have the following problem: I have 4 forms (Supplier, Product, Quotation, Order) Supplier has a bidirectional link to Product (One Supplier, Many Products) Product has a bidirectional link to Quotation (One Product, Many Quotations) And now I am working on the bidirectional link between Quotations and Orders (One quotation, Many Orders) But I'm stuck, I want a subform in my Order Form because it allows users to create an Order including several Quotations I can create the lookup field
Zoho Creator pages are not accessibble to some users
We have found that some content in Zoho Creator is not accessible to our visually disabled users or users with limited dexterity. For many users the only way to access web content is through a screen reader or other assistive technology. There are a few simple things that can be done to make Zoho Creator accessible to everyone: Images should include alt tags Form labels don't reference the form fields, The Labels the "for" attribute like so: <label for="FirstName">First name:</label> <input
Fetch data from another app
I have two apps, Warehouse Database and Pricelist Master Database. In Warehouse Database I have a form called Orders and in Pricelist Master Database I have a form called ContactForm. I have created a Lookup in Orders called input.Company which fetches the Customer name from ContactForm. What I want to do is then using this link fetch the remaining data such as address / customer no. etc and populate fields in Orders. I know how to do this in the same app between two forms, I use something like:
auto fill field in sub form
Hi I have tried following other posts about auto filling fields but cannot seem to get it working, here's my set-up: Main form: quote_system Sub form: areas Price list form: master_price_list In the sub form, users will fill out rows of data completing a quote, they start by selecting an area (which populates from a lookup field), based on this selection a new lookup field gives them a type from the master_parts_list which in turn gives another dropdown with possible parts (again from the master_parts_list).
Identification of Duplicate Records
What is the most efficient way to identify duplicate records for a large number of records? It does not seem efficient to compare each record to all others because of the maximum number of executable statements per deluge action. Note: I did not enable one record per user due to the type information being gathered. Cheers, John Whitney
Addition of values not working as expected
Hi, I have a form1 with fields say Id,Name and Type and Quantity, Quantity available then form2 with fields say ID,Name,Type,Quantity,Quantity Sold and Quantity in stock. Based on the type given in form quantity available will be listed. What i want to do here is , On success of form 1 i have written a code to fetch the form 2 field with current form1 fields, If their type and name is equal then add Form2.Quantity =Form1.Quantity+form2.Quantity. rec = Form2[Event_ID == input.Event_ID.toString()
Consolidation of stock tables
Hi! I am new to Zoho Creators. I am having 5 different tables for stock count. For example: Table 1: Chennai Stock Table Table 2: Delhi Stock Table Product Model Stock Count Product Model Stock Count A 10 B 20 C 20 C 30 Simillarly, there are 3 more tables for different locations. I want t consolidate all
No duplicate values in two or more forms within the same application
Hi... I need a little help. I have an application with more forms inside. I would like that a field become unique in every form (i don't want that a student duplicate a value). For exanple: A student must book for an activity for the days 6 and 7 May but he can't book himsle for the days 10 and 12 May because he already booked for the days 6 and 7. Ho can i coul do it ? Thank you in advance for every suggestion.
Next Page