Fetching name based on id
Hello there, i have an app that matches clients services requirements with clients services offer. I created 3 forms: Clients informations (Name, email address, phone) Service requirements (Lookup Name clients, Service type, max price (The max price a client would like to spend for a certain service) Service offer (Lookup Name clients, Service type, price) On service offer form I should be able to see all the Names of clients that might be interested on that service and on the service requirements
Reporting on Multi-select lookup field
Hello, I have a question about Multi-select lookup field in Zoho Creator. I would like to report on each value in Multi-select lookup field. In my app I have 3 forms: Presenters Products ChildSKUs Forms are connected with Multi-select and Single-select lookup fields. How can I create Combined Report on multiple forms and report on Multi-select lookup fields? I have tried following this article but it is outdated. https://www.zoho.com/creator/help/views/create-a-combined-report.html
View uploaded files instead of download
My apologies if this has been suggested as an "idea" before, though I have seen several people asking the question. As a Zoho Creator is a database, we need to be able to view records easily, and part of our records sometimes include uploaded files (particularly PDFs). It is irritating that every time we want to view an associated file for a record we must download that file. There needs to be an option to view in a pop-up window or browser tab. I've seen several mentions that this is possible
postURL Issues and ZOHO auto formatting
I need to POST into a API I created for my own data base using dreamfactory. The format the data needs to be is very specific, it needs to be formatted in a certain way otherwise it will fail. {"resource": [ {"CLIINTID":input.CLINTID,"TRDPRID":input.TRDPRID,"TRDPRTNR":input.TRDPRTNR,"TRNSTS":input.TRNSTS,"TPSUBNO":input.TPSUBNO,"CMTYP":input.CMTYP,"HOSTIP":input.HOSTIP,"HOSTNAM":input.HOSTNAM,"HOSTTYP":input.HOSTTYP,"PORT":input.PORT,"USERID":input.USERID,"PASSWD":input.PASSWD,"ACCOUNT":input.ACCOUNT,"EMAILADR":input.EMAILADR}
How can I make the data from "Add Notes" special field appear in detailed report view for Zoho Creator?
I am trying to produce a report from a form in PDF. I want to show data entered Add Notes (Your notes content will be shown here) to also appear in a Detailed report view, where I can then align the Notes field with the captured data in the form. When I add fields in the detailed view the field name I created for Add Notes does not appear. Is there a way around this please?
Adding contact to Zoho Invoice from deluge not working!
Hey everyone, I've been trying to develop this super simple application that will let clients signup using a form I made in Creator. After submitting, they will be prompted to pay and when payment is successful, I want to send them an invoice using Zoho Invoice. All automatically. I started writing a deluge script to add contacts to Zoho Invoice when the form is submitted, but the only value that's actually getting saved is the "contact_name"... I've tried every single suggestion found on this community
API
First i am stone with this dev tool. Still i have some request Is there a way to access the database over an API XML RPC or SOAP ? from the outside world ? Im using PHP and JAVA. Best Regards Jacques aberstt
if statement and operator
Good day, any idea what I am doing wrong with this bit of script? want to look if line one is true then if it is I want the field Adjusted Input to equal the field Install Torque Value by 6.1 and add that value to the Adjusted Input field. if ( Installation_Type == "TMRS" ) { input.Adjusted_Input == input.Install_Torque_Value * 6.1; }
Zoho Sign Integration
Is there a Zoho Sign integration if not any good links on how to build similar functionality?
How can I calculate a date within a certain amount of days, counting / not counting weekends into the calculation??
Hi, I need to develop a way to calculate a new date from a start date, a number of days (before or after said date), excluding holidays I have in a database (as dates), and make two variations; one that includes weekends for the final date (counts but cannot land in a weekend) and another one that doesn't include weekends (doesn't count and cannot land in a weekend) Thanks.
Report that Includes Dynamic Count of Records from Related Form
I was wondering if there is any way to add a field to a report that dynamically counts records from a related form. Specifically, I have Form A which holds Employee Names, and Form B which holds Tasks, with a lookup to the employee's name in Form A. I'd like to have a report based on Form A which includes a count of the number of tasks assigned to each employee from Form A. I think this can be done with a pivot table, but was hoping to do it in a regular report view. Thanks for your help.
Zoho Creator intergration with Slack ?
Hi Zoho, We're choosing email collboration system. I saw that Zoho Projects can be intergrated with Slack? is it the same with Zoho Creator? how can I reach it? Thanks Ravid
Adding records to subform problem
I am new to Zoho. Attempting to add records to a subform (Lab_Result_Details) after editng a field in the subform. Not getting ID from parent form (Lab_Results) to show up in child form. Here is my code: //Capture form ID number to insert into new subform record as linking field var_ID = input.ID; //Get ID of test name to enter in new record var_TestID = frmTests[Test_Name = "ANA"].ID; //Add record to Details subform and insert ID of parent form into child linking field and test code into test
Sub Form Field Width
I had read that this has been fixed but it's not working for me. When I click on 'Add New' the field widths are way too wide and you have to scroll across to see them all. I changed to field widths in properties to make them smaller but it's not working for me. Is there a way to do it that I'm not seeing? Thanks
Create an Estimate on Quickbooks from ZC
I want to create Estimates with more than one product on Quickbooks from Zoho Creator. However, the intuit funcitons created by Zoho don't support the "Esimtates" module on Quickbooks. Could you help me please? I know I can use the Quickbooks API, but it's kind of confusing specially the part of the Access token expiring every 60 minutes. Thanks.
Execute Function from Rich Text Field
Hi - I was wondering if there is a way to hyperlink text entered in a rich text field so that it executes a function that allows editing of the selected record? I have the function working properly as a button, but would like to execute by clicking on the entered text rather than taking up column space with a button. Thanks.
how to change submit button size and colour?
hi! just made stateless form which embed to my website via iframe. how can i change size and colour of form's submit button?
Dropdown Blues....
Hi - new to creator - trying to develop 2 dropdown's that will change depending on what the user selects. The 1st dropdown is used and then will hide (or other) on the 2nd dropdown. Any pointers would be apprecaited.
Deleting subform row too fast
i script this "input.Sub_Total = input.Sub_Total - ifnull(row.Total_Price, 0.0);" in a subform delete row function. let say i have got 4 rows in the subform and i click "X" (Delete subform row) on the 1st and 2ndrow, the 1st click will not register and it result only 2nd click get the new total. it happens when i click the "X" button too fast with multiple row. any suggestion to prevent user delete row too fast ? do check on the video if my explanation is not clear enough. thanks
Using Templates via Deluge code
Is there a way to use Creator Templates via Deluge code and not by using default way from the Form.As i have a stateless form and can't use template on that !!
send mail function
Hello there, I've got a form in which I add one different invoice (Image) per record, with a little description an a field called "Sent" I'd like the system to send a mail, to a unique mail recipient, if the field "Sent" is "No" and, after sending the mail, change the field to "Yes" That's what I did but does not work Where I'm wrong? Thanks for your help
More than 1 lookup field braking report buttons
HI, We have a form that tracks the progress of quotes. I have a pre-filled box for "current quote status" set to "Sent" and then added in 2 button on the report that change the "current quote status" to "accepted" or "declined". In this form i also have 3 lookup fields for Site name, contact name and contact email. If all of these are filled the buttons do not work, they don't change the"current quote staus" field content. However if i leave 2 of them blank then it works fine. Confused! Does anyone
Calculating IRR
Has anyone had success using an IRR (Internal Rate of Return) function inside of a Zoho Creator app? Trying to set-up a proposal application and this function is crucial. I know it's a fairly simple function within Zoho Sheet (or excel) and was hoping it could somehow be available as a function in Creator. Thanks all!
Fetching Data
Hi there! I'm a new zoho user, i'm doing a project with zoho now, and i complicated how to fetch data. I want to fetch data from pict 1 to pict 3, but the company branch name must be suitable with the company. can u help me Pict 2 Pict 3 Pict 1
offline location
I would like to get a location, latitude, and longitude in offline mode.
Send attachments
hello there, I have a form called invoice in which i add, for every record, an invoice number, the reason of this invoice, the amount, a file upload fieldin which i add the pdf of this invoice, and a flag field called "status" Every record has a different pdf file. I'd like to send, by clicking on a button, all these files that are not "sent" to an unique mail recipient (Always the same one) Could you help me pls? Thanks
How to set up authorization in the application through social buttons?
How to set up authorization in the application through social buttons?
User registration and authorization
Hello. Is it possible to make registration and authorization a user in zoho creator? And where to store the user ID for receiving data in the entire application with it? For example, there are sessions on sites for this.
Embedded Form Layout - Changing the Styling
Hi, I am wondering if there is ANY possible way that the automated layout for 1 or 2 column forms that are embedded in a webpage can be changed. Due to the fact that the embed code uses an iFrame I am unable to style any of the elements via css (unlike the CRM embed code for WebForms). When using the 2 column layout and the iFrame code, regardless of the fact that I can specify label widths - these seem to be completely ignored when the iframe is generated. i.e. 1st column label html: <td class="zc-labelheader"
How to Autofill a Lookup field based on another field?
I have a module called Invoices and within that module I have a field called Service Contract QB Reference and another field called Other Contract QB Reference. Service Contract QB Reference is a lookup column that corresponds to my Contracts module. Other Contract QB Reference is a lookup column that corresponds to my Other Contracts module. I have now created another lookup field in my Invoices module called Commissions QB Reference, that corresponds to my Commissions module. But I want this field
Export Choices in Multiple Select Field
Hi, I've just moved a from from Zoho forms to Zoho Creator. I've just seen that I can't export the choices from a checkbox field in creator whereas you can in forms. Is this going to be updated at all? Matt
Condition to check whether the report contains any records.
Hey there, Is there any method or any deluge task to delete all the records when say Report A (list view) doesn't have any record then delete all the records from Report B (list view). Any help would be appreciated. Thanks in advance!
Reoccurring Frequencies in Workflow
Yes i'm newer to ZOHO, but i'm trying to set up a reoccurring email alert that would be sent to a customer the day before we come out to do the work. Is there a way to set it to reoccur like ever 3rd Saturday of a month instead of a fixed date? My customers don't get serviced based on a specific date but a specific re-occurrence of work.
Correct way to fetch distinct values from a field in a subform
Hey there, I followed the documentation from this url https://help.zoho.com/portal/kb/articles/data-access-distinct#Overview but not able to resolve the issue. Here is my code: courselistype = Courses[Branch_Name = row.Branches_Name].distinct(Course_Type); row.Course_Type:ui.add(courselistype) Where Branch_Name is bigINT, Course_Type is a string, courselistype is a collection variable Any help would be appreciated. Thanks in advance!
Deluge Scripts
I have created an application in Creator with multiple forms that only I enter information into. One form collects stats and data from e-newsletters our company sends out. The other form I use to send our e-newsletter advertisers stats on their specific ad/url within the newsletter. I've been able to create a workflow that sends a nicely formatted email to the specified contact with their advertising results when I submit the form. What I want to be able to do is populate the advertiser form with
Dynamically view filter on function
Hi All, I've follow https://help.zoho.com/portal/community/topic/tip-05-how-to-dynamically-view-filtered-data-on-a-page to create a function to run when user click the button on detailed view in my report The function is void defaultAtom(int Customer2) { openurl("https://app.zohocreator.com/user/app/#Report:All_Calls?Customer.ID=[" + Customer2+"]","parent window"); } It do not filter Call based on Customer.ID which is a look up field Could please help me? Thank in advance
How to show Hour in a html snippet div box with + 1 hour condition ?
Hi Team, I want to show hour in my dashboard but it will be with add 1 hour in current hour. i'm using this to get the current hour in my div box <div class="widgetText" style="color: #61ddbb;"> <%=now.getHour()%> </div> OutPut 13 now i'm trying to add + 1 hour in current hour. i had issue for that Trying this to add <div class="widgetText" style="color: #fc8372;"> <%=now.addHour(1) %> </div> OutPut 16-Jul-2019 14:00:04 But exactly what i need is 13:00 14:00 15:00 Thanks in advance.
Populate Dropdown from Subform
Hi, New to Zoho and trying to find my way around... Have a main form with client details - which contains a subform for different contact persons within that company. In the second main form - to create projects - I would like to be able to use a dropdown to select a contact person for that job, dependent on the client that has been selected. This is what I've been playing around with so far, from looking around other forum answers, but I'm not sure if I'm missing something obvious or just going
Show subform field based on user input
I have a main form (Deployments) and a subform (Incidents). On my subform I am hiding a field on load (Report_Address). I have a checkbox (Discrepancy) with a workflow to show the Report_Address field when the Discrepancy field is checked “Different Report Address”. This works just fine if I create a record through the subform. Discrepancy as "Discrepancy" { type = form form = Incidents on add or edit { actions { on load ( if(input.Discrepancy = "Different Report Address") { show Report_Address;
Send a mail if a condition happens
Hello there, I have a form with an image and with some other fields. One of these is called mail sent. If it's not flagged, i'd like the system to send a mail to a recipient and flag the field If it's not flagged it doesn't send any mail. Thanks!
Next Page