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!
IT asset tracker
Hello, I have problem with Dashboard in IT Asset Tracker. I delete some charts, system tell Saved. But when I back to Dashboard, it still display the old layout. Pls advise. Thanks.
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
Upcoming updates - Feb 2019
Hello App Creators, We hope you're all having a great 2019. Here's a little something from us to add a bit more shine to it. In the first week of February, the Zoho Creator team will be rolling out the following feature updates: Navigational buttons in calendar and timelines reports Ability to execute custom actions after a confirmation Interactivity in the reference-listing popup that appears while deleting fields and components, and enabling/disabling certain properties In addition to our changelog,
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
Record template and page break
Hy, I need to develop a record template with ~ 10 to 20 pages. Anybody knows how to include break page ? Many thanks for your help. Bertrand
Reporting - how to pull records which have two or multi select items selected
I am creating a report and want to show only records where two or more items have been selected from a multi select list. How do I do this? Thanks
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
Updates — May-Jun, 2019
Hello App Creators, It's been quite some time since we interacted on the upcoming updates in Zoho Creator. We very recently got through releasing all but one from the Apr-2019 list of updates ; it took a while to sort out the kinks in them. We appreciate your active engagement, continued patience and understanding in this regard. That said, we're gearing-up for the next set! We'll shortly be posting about the upcoming updates for Jul-2019. Meanwhile, below are the other notable updates that were
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
Next Page