Missing Grouping & Sorting Link in report settings
All but one of my report settings has a grouping & sorting option. Anyone know why this option would be missing in one report? I need to sort it by date Gill
Time (Duration) Question (Data Entry)
I am contemplating adding a feature to my app that will take from 2-8 time entries and add them up. It is important to note that the times entered are not calendar-related but rather, units of duration in the format "h:nn" What I'm looking at is either a form to store the data entries or perhaps I'll just use an unbound form to perform ad-hoc calculations (addition) of multiple time durations. But what I'm ultimately after is this Does Zoho offer a quick and easy way to enter a time as some spreadsheets
Cannot display a form image in a Page
Hi I have a page wants to display a company details. Name and Logo. so in the form Company Name (Single Line) Company Logo (Image) then in my page I fetch the record MyCompany = Company [ID == "333344343"]; then I look to display the name and the image <p>My Company name: <%=MyCompany.Company_Name%> this works great.. but HOW do I display the logo? Is it something like this? any ideas? I cannot find it in the doco. <p>My Company Logo: <img src="<%=MyCompany.Company_Logo%>" alt="" height="42"
Unsubscribe link to pull in email address
I am creating a form for unsubscribing from daily emails. Is it possible to set the Email field to pull in the email address of the person that clicked the link in the email they received with workflow code?
Search Page
I am trying to add a search function based on the instructions at https://www.zoho.com/creator/help/tutorials/advanced-app-building.html I believe the first part is working as it opens the html page with the word that is typed in the search box e.g. #View:Search?searchword=skills However, I cant get any results to be listed. I have copied the sample code as below; //pass the parameter (searchword) from stateless form (Aistear_Links) //fetch the record from "Aistear" form (Aistear), fields = Category,
how to set filters dynamically to pivot chart
Hi, I've to generate pivot chart based on the value selected on the form. For example, After completing survey, I''ve to show survey report for that particular survey. For this I need to set filter value based on selected survey Id. Can I do it. Thanks for the help, Regards, AppAdmin
ZoHo Creator Database newby Question
Hello ZoHo Community, Can someone help me out with my first ZoHo Creator Database? I created a database with a form to submit data on a date base. The data entry consists of 4 columns. For example: Date Value1 Value2 Value3 Value4 01-01-2016 10 15 20 10 11-01-2016 20 20 30 50 I would like to calculate the difference in values on a daily base, based on the datevalues in the Date column. Based on the example above the avarage daily
Populating a fillable PDF with zoho data
I see that there was a question like this about 5 years ago. Is there such a function already
How to update the status of an item in a report
Hi everyone, I'm new to Creator and struggling to figure out the following: I have an order form that my sales person uses to enter orders taken over the phone. Typically an order has several items which he can add to the order by selecting from a dropdown that uses a lookup to pull from a master list. I have created a report that shows my procurement person each of the items in the order so that he can pull them from the shelf. At the item level there are details about where it can found in our
Replicate Xero
I am looking for someone to help me with the design a system within Zoho Support via Zoho creator to replicate the below modules: Book Keeping: https://www.xero.com/uk/ Property management: http://www.arthuronline.co.uk Anyone looking for work and can deivery this please let me know.
Adobe Echosign Links not saving in Rich Text Fields?
Normally the URL that is inserted as a link in a rich text field works fine; i.e. they can be inserted, they save during update and are available in the rich text. However, Adobe echosign links sometimes fail. They get inserted fine, but on updating the field the link gets converted to straight text and only the description text remains.I tried converting the dash and underscore characters per other threads but did not work. Is there a known issue with echosign links in Creator? Link Example working:
Using parent form as a subform in another form but not create a record in back-end
Hi I have a form A which is a subform of Form B. I am using Form A only to fetch records into form B and hence i dont want a record to be created in Form A table when i create a record in Form B. Is there a way around it? As i understand a sub-form will create a record in the back-end and we cant change it. But can we find a way around it so that i can still fetch records from Form A to Form B and not create a record in Form A. I cant use the normal Fetch records because Form A is fetching data from
Getting an error "Invalid entries found. Please correct and submit again."
I already allowed edit access to the support team. To reproduce the error: https://creator.zoho.com/lexshan1/production-manager#Form:Order_form Select the "test customer" and fill int he Address 1 line, click "Submit" I'm still under trial period, if i don't get this issue resolved, there is no way I'll upgrade it.
Auto populate user name in field
I'm kinda new at this and I need to figure out how to auto populate a field with the user name that is currently logged in. There is a mandatory 'Created By' field for all notes, but I want it to autopopulate with the user name that is logged in and adding the note instead of having to choose from a list of users.
Form Field Not Showing up in Lookup
Why is a field on my form not available in the Lookup function when trying to create a relationship with another form?
Update a field based on user input
Is it possible to have a field update as soon as any other field is edited. For example i have a grand total field how do i make it update as soon as any other field is touched for example if i change the product then it will update or when i change the discount it will update.
Multi-Select to fetch prices and apply them to a total.
Okay let me try and explain this the best I can. So currently i have a product table with all my products name and prices. I have also set up a Order form for when orders come in. On the orders form i have a multiselect box so i can select all the products the customer has ordered. Is it possible for when i select the products it pulls the prices and applies them to the total. Example if i select product 1 (£10) and product 5 (£2) from the multi select the total would be £12 on my order form etc.
Record Summary - Customize layout for subform items?
Hello again. I am fairly close to getting my record summary to look how I want it to look, but there's still one other thing I can't quite figure out how to do... My record summary is for a form (Form A) that has a multiselect lookup field. The other form (Form B) which the lookup is connected to contains a multiline text field which I use to store the data I want to show as one long string of HTML code. In the record summary, I added the multiselect field from Form A and select only the big text
Change Value of drop down in a report.
Newbie here. In this report, I want to change the value in the drop down box. When I click on the down arrow, it goes into a "Searching" mode and never finds the other values. (see attached image) How do I make a drop down box in a report editable?
Spreadsheet conversion into a database
We are looking to develop the attached spreadsheet in creator, which we use to take client data to create a UK tax return to HMRC within Tax Calc. I have written a problem statement here: https://www.dropbox.com/s/s9a4vymf8e59qzh/Business%20process%20-%20Problem%20and%20requirements%20statement.docx?dl=0 I have also provided the spreadsheet here: https://www.dropbox.com/s/iugu0u3wnuwlzbt/-%20sa%20-%20client%20fact%20find%20v41.xlsx?dl=0 We need to ensure that: - It may form part of the Zoho Support
generate pdf of customized HTML contents using zoho creator deluge script
Hi Team, I am creating a request to send a set of HTML contents using SendMail function of zoho creator. I can send the HTML contents succesfully in email but along with that I want to do is to create a PDF file of that HTML contents & send it as an attachment from zoho creator's SendMail fucntion. Firstly is it possible.? If yes, how do I achieve this scenario.? Thanks & Regards Amit Thakkar
Add Note field permissions
Hi everyone, Is there any way of configuring the permissions over the "Add notes" field in a form?, because depending on which User Profile I'm using, the field appears or disappears. Thanks!
Schedule a Task
I have created a simple form with a "Follow Up" date field. How do I create a reminder that pops up or tells me that I need to follow-up with a patient on the specified date field? I looked at the Create Schedule feature. While I can enter the date in the When to Do section, I don't know how to enter the What to Do section. My goal would be to create a list showing all the follow ups for that day. I would also like to see the scheduled follow ups on a calendar. Thank you.
Time zone
Hi. I was using wrong time zone before and used add hour to adjust but now when I changed time zone to the correct one it changed all the stored records time as well and they're all showing wrong date or time. How can I avoid it. Your help would be much appreciated. Thanks.
Unable to display images in pdf
Hello. I have an HTML page that is to be used as a "final report" to summarize details about a claim. The result is intended to be emailed to employees and customers as a PDF. I have included images that were attached to the claim by doing this: claim = Claim [ID == input.Claim_ID.toLong()]; claimPhotos = List(); if ((claim.Image_1 != null) && claim.Include_Image_1_In_Final_Report) { photoHTML = claim.Image_1.replaceFirst("/sharedBy/appLinkName/",zoho.appuri); photoHTML = photoHTML.replaceFirst("viewLinkName","Claim/"
pick list
does anyone know how to dynamically update the displayed value of a pick list using deluge script?
Max Size of a Webhook
I need to drive data from CRM to Creator using a webhook. I understand how to do that and it works. The question is - how many different fields can I send in a webhook? For example, I have 55 fields in my Leads module in CRM. Can I send all of them in one webhook? Is there an actual or theoretical maximum to the size of the url that is created by the webhook? Thanks in advance Jon
How can I update the existing data?
Hi, I have created a form with employee data. Now I have changed the data and want to update existing data based on the employee id which is the first field. But when I import again it adds up the rows rather updating existing ones. Please let me know how can I update existing data from a CSV file. Thanks Manpreet
I want to use zoho Creator existing products in CRM module to add the purchase price and selling price, would you help me?
I want to use zoho Creator existing products in CRM module to add the purchase price and selling price, would you help me?
Change the status of a record in a report based on the success of an other form.
Hi Zoho community, I need some help with this case: I have a report (PR_Detail) where the products that are in queue are, the records in this report have a Status field, Quantity field and a Description field. Then I have an other form (PO) that has a subform (PO_Detail, with Quantity and Description fields too) where the users choose the products that they want to purchase, they can only choose the products that are in the PR_Detail report. I would like that On Success, if the Quantity of a product
Checkbox show and hide multiple fields
Hello I am trying to get my form to show multiple fields. When I select one checkbox it works fine but when I select a second no fields show. I have tried using different IF statements and am now using ELSE but it still does not work when selecting multiple options. Here is the code I have. Form Onload sets my fields to hidden on the field that is selected this is the code: if ( (input.Industry_Vertical.toString() == "Agriculture and Mining") ) { show Agriculture_and_Mining_Specific ; } else
Dynamic Drop down list based on import from Zoho Reports
Hi all, Any help would be appreciated! I have this app connected to my database in Zoho Reports. I want to create a dynamic drop down list in my stateless form which fetches all the value from one column in a Zoho Reports table. I found the 5 years old post with similar topic. https://help.zoho.com/portal/en/community/topic/desparate-help-please-reporter-and-creator I tried to use Zoho Reports Export API with the following codes ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=<email>&PASSWORD=<password>"));
Pages Script Editor - formatting feature request
Hi, Would be possible to prevent the script editors from automatically reformatting my code please - particularly the pages editor! I'm sure there may be valid technical reasons for this auto-formatting, but free form on the Pages script editor is only free form until you save and then re edit. With complex interactions between deluge and HTML, the code quickly becomes a visual mess and makes it impossible to do anything other than the simplest of tasks. The syntax is already visually quite messy
Update formula in a subform with a value in the form
Hi, I am looking to update some values in a subform with changes in the forms... I created the formula that multiplies a value in the form with one in the subform. But if I change the value in the form, the calculation is not redone. I am looking something to write in the Action update , but I can't seam to write it correctly Can somebody help me Thanks
New App Builder: Serious Oversight
Setting Report Criteria in the New App Builder I cant believe we're back to this!!!! I posted this months ago and a fix was implemented. Now creating graphs is even more confusing than it was before. Clicking on creating a chart and it takes you to the interface for creating a pivot table. The worst part is that I desperately need to restrict user access to charts using the criteria established in the view which used to drive chart and pivot creation. Using the filter on the chart doesn't do
Can do some other task when cancel button was clicked.
Hi, I've two forms form1 & form2. When cancel button in form2 was clicked, record inserted by form1 should also be deleted. I tried with stateless form. But both forms should contain 'file upload' field which was not provided for stateless form. Please suggest me how can I do this? Regards, Appadmin
Auto populate Text field with a lookup field
I've been looking all over for a solution and can't figure out why this is happening... I want to populate a text field with the value of a lookup field on the same form. I've been using the same fetch script that I've seen everywhere but no luck. I've placed it on the lookup field 'Company' - 'On User Input' within the Real_Estate_Brokerage form in hopes of populating the 'Company_Name' text field. data = Real_Estate_Brokerage [ID == input.Company]; input.Company_Name = data.Company_Name;
Locale in Decimal Separator ?
Hi, notice that the currency can be changed, however the decimal separator remains the same. In the EUR Zone the Numbers have comma as decimal separator 100,00 EUR instaed of 100.00 USD. Displaying is not a big deal, but when exporting data for import to other application it produces considerable trouble. Any plans to fix that ? Google Docs and Excel do an excellent job here. Thanks Alex
Insert record to a specific location
Hi, I want to know if it's possible to insert a record to a specific location. For example, I have 4 records with order like this 1 Book 2 Movie 3 Car 4 Laptop Now, I want to insert a record called Mobile between Movie and Car and it will have order number 3. And the Car and Laptop records will be pushed down and the number will be updated automatically to 4 and 5. It will be 1 Book 2 Movie 3 Mobile 4 Car 5 Laptop I want to know if it's possible to accomplish this. Thanks
relate lookup field with total amount in report.
Hi, I have report where all the requested items are. This report is grouped by Description and I set it to show the total quantity of each Item in the report. I have a Purchase Order form. In this form there is a subform where users add the items to be purchased. The users select the items from a lookup field in the subform. I would like the lookup field in the Purchase Order subform to show only the items that are in the requested items report and to link the total quantity. is this possible?
Next Page