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!
Add record task for multiselect field or multiselect lookup
Hey there, How can I add records for mullti-select field or a multi-select lookup using foreach? Any help would be appreciated. Thanks in advance!
look up field contents don´t show in view
I have two look up fields in a form, but, when I look at the view of this form, the columns with the contents of those two look up fields are not displayed. Does someone have any clue on what is going on ?
Fetch records from a subform to a Multi-Select Dropdown
Hey there, How can I fetch records to a form B from a subform which is a part of the form A which to get the value of the lookup field and store it in form B. The subform is not an inline subform. Any help would be appreciated. Thanks in advance!
Integrating Creator and Backstage?
Are there any plans to integrate Creator and Backstage? We're currently using Creator to manage our submission and scheduling process for our annual conference, but would love to utilize some of the features Backstage has to offer. However, our clients already log in through the customer portal in Creator, and we don't want them to need to log in to a separate service. We also would need to be able to import event data directly from Creator into Backstage in order for this to really be an efficient
Dynamic Form Title
It would be great to be able to control the Form Header Title with deluge, based on whether a record is being created or edited, and based on other field values.
Fetch Distinct values from a column using lookup field in subform
Hey there, How can I fetch distinct record from a column using lookup field in subform? Any help would be appreciated. Thanks in advance!
Endless "Please wait" message when submitting form
We have a stateless form that is embedded in our website (no Zoho HTML view, a regular HTML website). In this stateless form we have checkboxes that open other forms in a popup window using openUrl("#Form:Test_Form?recLinkID=" + r.ID + "&viewLinkName=Test_Form_View", "Popup window"); where r.ID is the id of the record we want to edit. When the user clicks on "Submit" in the opened form, the popup window closes and the stateless form is updated and loaded again. This is done by calling openUrl("https://creator.zoho.com/avsupport/test-app/form-embed/Test_Form_Stateless",
Conditional Formatting
I have an expiry date field which I would like to apply the following conditional formatting to:- Expired = Red 12 Weeks Before Expiry Date = Orange In Date = Green is anyone able to assist with the above 3 conditional formats? Thanks, David :-)
Please help - probably a basic question :-(
I'm writing a database for a volunteer organisation (Being one off the volunteers) I'm almost done, its been three solid days and my brain is fried. I want to add a custom function to send an email to the trustees and the those labelled as Staff with an attachment containing registered responders (Search and Rescue Response) I can get it to send to either Member Type = "WSCCT Trustee" or Member Type = "WSCCT Staff" but I can't work out the syntax to to create a list "Recieve" containig both WSCCT
How to insert String Value to Lookup field
Hey there, How can I insert String Value to Lookup (BigInt) field using addRecord? Any help would be appreciate. Thanks in advance!
Pull data into subform from a Creator report
Hi, I've got a Creator report that holds some data pulled from CRM. I want to get the data from relevant records in that report, and see it in a subform. Fetching it is fine, but how do I get each record to show in a different line in the subform? I usually use a counter for static values, but I would need two counters, one to count the rows, and one to count the records? Is this more easily done with a map or list? Any help is appreciated Levi
Months Between Dates
I am trying to create a function to calculate the number of months between two dates. I was using the getmonth function to calculate this based upon the month of the year; however this logic breaks down when the months cross years. For example: Start Date:November 2, 2009 End Date: January, 10, 2010 Number of months:3 Thanks!
Checking for a new row entry on Subform onSuccess or on User Input on edit.
Hey there, How can I check if a new subform row is been added on edit workflow while on success or on user input as I am calculating subtotal from the subform to main form field total.? Any help would be appeciated. Thanks in advance!
Next Page