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
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!
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
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!
Update Subform on load
I am trying to find a workaround since Zoho has yet to give us a time only field or a way to completely remove the seconds from time. Hopefully someone can provide an assist. I have a main form with start and end date-time fields. I have a subform with one date-time field. When I click "Add New" on my subform, I want it to be populated with the start_time field. This would at least save my user the time of having to put in the date and 00 seconds again.
Basic relationship matter
Hello there, I would like to add in a form the name, family name, date of birth of a client and after that I’d like to add, if he’s looking for a house, the terms of its research and if he’s an owner who would like to sell its house all the details of that (Address, sq meter, price). So i created 3 forms. the 1st one is for the datails of this client. This form has 2 subforms that are show separately if the person is an owner or he’s looking for a house. The subforms are made with the 2 other forms
String to SHA512 -> Base64
Hi There We have need to convert a string to SHA512 first then convert to Base64. However the zoho.encryption.sha512 converted to Hex first, once converted to Base64 is not what we want. anyone got any suggestion? Thanks a lot!
Is export data to csv file in dropbox possible using automation in Zoho Creator?
Is export data to csv file in dropbox possible using automation in Zoho Creator
Disable delete on subform
I have a Form "Invoice" that depending on its status, when loading I disable all fields so they are not editable. The issue is that I have SubForms within that Form. I can disable the fields of the SubForm, however, the red "x" button still shows at the left of each line item allowing the user to delete the entire line item. Is there a way to disable that delete line item button (red "x")? Thanks, OV
Code for printing record using a Record Template
I have a Form named "Invoice". On the Report "All Invoices" I created a Record Template to print it out nicely in an invoice format. Is there a way to automatically print 2 copies of an invoice (not generate a PDF, but send it to the printer) using that Record Template whenever a new record is submitted on the Form "Invoice"? Thanks, OV
Loop through days -- more looping limitation
I need a workaround for Zoho's lack of conventional looping functionality. I have a form that asks for a start and end date. The success function will create a record in another form for each day from the start to the finish. I cannot figure out how to make it loop through and do an insert for each day. If I could do a for-next type of loop, I'd simply do: numDays = days360(startDate,endDate) for ( i=1; i <= numdays; i++ ) { insert into ... blah, blah ... } But Zoho doesn't allow you to
Hide entire subform
Hello there, I'm creating a db for real estate. I created a page "clients" with some general info... I also created 2 subforms. One should be used for the terms of research of a client who is looking for a property (Max price, Min sum ....). The second one for the owners who would like to sell their property (Sqm, floor, bedrooms, floor). When a client is an owner, the system should hyde the subform for the research. When a client is looking for something, it should hyde the Owner subform. I'm using
Custom app Realtor
Hi there, I'm a realtor and I'm actually used a dedicated crm linked to my website. I'm not really happy since it has predefined functions and it's not 100% suitable with my needs. I'd like to know if it's possible to connect the db of my website (It's been populating with my properties and properties of my colleagues with mls system), matching these properties with client requests and send mails in case of matching (If certain conditions happen) with a custom app. I also do need to send mails ie
Calculate Total Revenue according to Branches in Zoho Creator Pages
Hey there, How can I calculate (Sum) total revenue generated according to different branches in Zoho Creator Pages. Any help would be appreciated. Thanks in advance!
Add subform rows to another subform, based on Date
I've a pretty complicated flow to build, hope someone want to help me. I have 2 forms, the New_Retail_Order (form1) and Credit_Card_Expenses (form2) and 2 subforms, Products (sub1) and Orders (sub2). Every time I add a record in form1, if Payment_Method = "Credit Card", a new record in form2 has to be created, and all the products added in sub1 have to be added in sub2. Moreover, when I add a second record in form1, the process repeats, BUT, if there is already a record in form2 for that given month,
Maintenance Schedule
Hello everyone, I am very new to this and I have been tasked with creating a maintenance schedule. I work for a printing company with quite a few printers. We want to make a calendar that shows daily/weekly/monthly maintenance tasks for each machine. I have the generic forms built to input the data, but I am having trouble figuring out how to automatically apply future dates without manual entry. Thank you.
Add field if click a button
Hello, I'm a new Zoho creator use so my question might be very basic.... I need to create a button called " Add link" that, when clicked, shows me an url field. For some records I might need just 2 url fields but for other records also 5/6...so every time I click the button it should show me a new url field. Thanks in advance for your precious help
Custom Function - using Lookup across two apps
Hi all, Looking for some help. We have two apps (Planner and Works) In works I have a form that uses a lookup to get a list of places from Planner. I've created a custom function in planner that will pull the address. But when I am trying to get the address to populate when the right address is selected from the lookup it keeps saying expecting string but encountering BIGINT. I've searched for an answer for a couple of hours and can't find anything that helps. Please let me know if you know how to
Add Subform Data to Main Form for Visualization
Hey there, How can I add subform fields to main form for the purpose of visualization in pivot charts and pivot tables as zoho itself has some limitation for subform data on reports as given on url: https://www.zoho.com/creator/help/general/known-issues-or-limitations.html#Reports_Limitation. How could I get this to working? Any help would be appreciated. Thanks in advance!
How to update record without creating a new one?
Hello I want to update the fields of Test1 and Test2 of an already existing record in the form 'Form1' when the same input of Scan is submitted. So far the existing record is update but a new record is created as well. Is there a way to stop the creation of a new record but only update the already existing one? This is how far I got with the script on success: Variable1 = Form1[Scan == input.Scan]; Variable1.Test1 = input.Test1; Variable1.Test2 = input.Test2;
Next Page