Display HTML page of user data
I want to create a page that displays the information that a logged in user has entered using the Add_Student form. Each user will only have 1 record. Assuming that I need to use a parameter to pass the id of the logged in user, I created a parameter named user_id_param and set it equal to zoho.loginuserid. I also added a collection variable named s (s = Add_Student [User_ID == zoho.loginuserid];). How would I display the embedded Add_Student form already populated with the user's information on
Can't Restrict Records by Role
Previously I was able to set reports up so that a User could only view the Records of people with the same Role. That no longer appears to be the case, and support is saying that feature never existed...but it has been like that for the past 6 months.
[Question Update a field in function of other field in real time
Hello, How we can update a field (Look up) in function of a radio button input in real time ? Thank you ! :) Josselin
Get most recent ID entered?
Hi Zoho, I have a script adding records to a form. in this script, after adding the record to the main form, I need to get its ID in order to insert data to its subforms using bidirectional lookup. Since the records are inserted automatically, it happens very quickly, so a fetch that is sorted by Added_Time does not work. I don't want to use fields entered by the user since they can be identical. Any idea how can I get the last added ID? the script look like this: for each EachIDforImport in Vals_for_Import_ID_List
delete record doesn't always work
Hi Zoho, I have a form with a subofrm in it. When I delete a row from the subform and submit the form, the row is deleted from the main form entry but stays in the subform report. To fix this, I have added a "delete record" script on "on delete row" for the subform under the main form, so on delete row it deletes it from the subform report too. But - this only works is some of the cases. If I delete a row, and than add another row or change data anywhere in the subform before submitting the main
customer portal
hi, in my creator i have a form "QUOTES" with the email of the company. The company has an access to the customer portal with the same email. i create a view on QUOTE with criteria (Email == zoho.loginuser) but when the company is connected on the portal she can see all quotes and not as his own. Other problem, if the profile CUSTOMER can have an access on QUOTE, the company can view all quote's reports Do you have a solution ? thanks you
How do you update a subform picklist, with values from rows in another subform?
I have created one form to gather information when on-boarding customers - one subform gathers information pertaining to user-groups, another gathers information about individual users. Each user can belong to several user-groups, which are created by adding rows in the user-group subform. How do I dynamically populate the picklist on the user subform with the information gather from each row in the user-group subform? I've tried a variety of solutions that haven't worked - the most logical one to
Need developer for Member Directory Project
Need to create a membership based directory. 2 member types (Basic and Premium). Multiple member characteristics fields. Basic membership is Free and member can only add and update their own profile. Premium membership is chargeable on annual subscription and can perform searches for data in any field in the Basic member profile. Basic member profile must include links to member social media sites as well as incorporate custom code to retrieve the members social media follower counts for each
Add commas to the display of numbers in input fields in forms, once they are input
This seems straightforward enough - all spreadsheets do it! When I have entered a number in a numerical field of any sort, and hit tab or click in a different field, the number I just entered should display with commas, so I can easily see that what I entered is correct. The only way to get this kind of functionality now is to put a lot of code and additional fields around a single-line text field to make it pretend to be a numeric field for input purposes.
[Help] Decrementation of variable
Hello, I've create a form to save date. It's for administration, In new form client can select a date from save data of first form. I want create a field "Quantity" in administration form. And in the client form i want decrementation the quantity and if she is"0" the date is hide. Have a tutoriel or an idea of it will work ? Thank you, Josselin
Email
Would it be possible to set a "send mail" "on submit" and the somehow from a response change a field in a report. E.g- The statless form contains- Badge Number(look up field), First Name, Surname( both autopopulate on user input, Accept or Denny drop down. When click submit it sends an email to the person who has been selected, in this mail the person recieving it has the ability to respond accept or denny. from there it would show what they chose. Any suggestions on otherways to do this would be
Updating a Status Field
Hello there I am trying to get my <Status> field to automatically update to [Historical] after a selected period of time - taken from the <Date of Next Check> field. Does anyone have any ideas ?!? Many many thanks. Karen R
Urgent: Uploaded File Download URL / Link
Hello, Can someone please help me figure out how to construct the link for an uploaded file through a zoho form? I have found the following but it will not work for me. More specifically I do not know what the ViewLinkName is http://creator.zoho.com/DownloadFile.do?filepath=/input.File_Upload_1&sharedBy=zoho.adminuser&appLinkName=zoho.appname&viewLinkName=yourViewName I just want to email the link to public users (not logged into zoho) and allow them to download the file. Thanks
Update a record with subform?
Hi Zoho, I'm trying to user the "Update record" command. How can I update a subform? it is not listed in the fields list. Ravid
Programatically update multi-select lookup field
Multi-select lookup fields are represented by bigintlist. However, there is no add() or insert() function to programatically update the list. How am I supposed to modify the list? There is a intersect() function on list but not union(), which would allow me to merge two lists together. That's another useful function. Help please!
Zoho Creator emails not working well (50% hit rate)
Hi, I have a Creator app which send about 200 emails a day to various parties. For the last 5 days the emails have simply not been sent - about 50% of them. This may relate to a black listed server?? Do anyone else have similar problems??
Fully authorized user can't see certain reports!!!
Notice in the screenshot there are two users. lexshan8 (me) and andrew.raymond they both have the same access Role and Profile. I specifically shared the entire application (Settings->Share->Invite, selected the root component, all sections, all reports and all forms) to andrew.raymond How come he still can't access the Orders - BO report? It's not showing up on the navigation menu at all. In fact, none of the Order related reports are showing. However, he can create new Order form. Totally weird.
Call export to spreadsheet from a function
Is there a way to call the export to spreadsheet command, based on criteria, from a custom function? I have a form with a field called Print_Label that is either True or False, default being set to True. I need to export all records where Print_Label is True to a spreadsheet, then set the Print_Label field to False. The later is easy to do with a function, but I don't see a way to trigger the export to spreadsheet option, or to do so based on criteria.
zoho creator errors
zoho creator is poping up errors in the Line -1 can any one help me out as i dont know where is line number -1
Can we bring data into creator from a Zoho CRM custome field or module?
We want to use a form for reporting on our English classes. We would like to pull the information from CRM. Is this possible? We curerently are using the contacts for our students and accounts for the customer but we want to create the classes with their details in a custom module and then have a pick list in Creator to pull the info over.
Error- Stateless form submit auto populate
Error details: Error in executing On Click script of the Submit button. Error. Error in executing Add Record task. insert into Bay_Booking [ BB_First_Name = input.BK1_First_Name BB_Last_Name = input.BK1_Last_Name BB_Customer_ID = input.BK1_Customer_Information BB_Models = input.BK1_Models BB_Make = input.BK1_Models BB_Date_Time = input.BK1_Time_In null = zoho.loginuser ] openUrl("#Form:Bay_Booking", "same window"); Have a stateless form that i am wanting to enter details
Button width cannot be set?
Hi Zoho, In my html I have a button. I am trying to set its width to be 150px. the following script is not working (all other attributives are working great - just the width is not working)... will appriciate assistence: <style> .ProjectButton { background-color: #748772; width:150px; font-size: 18px; padding: 15px 15px; vertical-align: middle; white-space: nowrap; border-radius: 10px; cursor: pointer;} </style> <a class='ProjectButton' href=<%=CurrentLink%> target="_blank" ><font color=#f0f0f0><%=CurrentName%></font></a>
creator aerospace background developers wanted
need skilled aviation background developer to create a marketplace for business jet transportation hub. like Uber of the skies. contact me if you are at the genius level with this package
Bi-directional explanation
I am a novice, so this is probably a basic question - what does a bi-directional relationship do? I have read the materials & asked zoho (who directed me back to the materials) but i still do not understand what it does.
Duplication records on demand
Hi Zoho, I have a form ("Mainform"), that takes data for different projects (project name is in "Project_Name" field). I have a second form ("Importform"), that allows me to "import data" from one project to another - meaning, on the ImportForm I have "Import_From" field and "Import_To" field - both state project names for the data to be fetched from / added to. On the ImportForm on add -> on success, I have a veryyy long list of updateing a record in Mainform, that fetch for every field its data
Fill dropdown with google sheet
Hallo, is it possible to fill a dropdown field with data from a google sheet ? Thank you
Form image not show in views
Hi, On our Zoho Creator system we get candidates to upload a photo to their registration form. Originally I set it up so that on views, we could see the images. It worked with this formula: (("<img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/" + My_Pic + "&sharedBy=" + zoho.adminuser) + "&fieldLinkName=My_Pic") + "'/>" For some reason along the way it stopped working. Please help me get the images showing on my views again. One example is the 'CURRENT CANDIDATES' view. We
How to REMOVE a RELATIONSHIP (values in a LOOKUP field) using a STATELESS FORM
I have a stateless form to add records to "Tasks" form and a separate stateless form to edit records in "Tasks" form I do not want to allow users to have edit access to the actual "Tasks" table, so all edits must be done via the stateless form. "Tasks" form has lookup field Contact_ID which links to "Contact" Form. IF a contact has been added into a record in "Tasks", i.e Tasks.Contact_ID has a link to Contacts.Contact_ID, how can I remove this relationship on edit, using a stateless form? None of
Can't find the organization contacts
I think my account is totally out of wack. I tried to add users to to Groups and manage sharing using Groups. The screenshot shows I have 14 contacts in my organization but none is shown. This is not the only thing wrong with my account. I submitted multiple posts this afternoon about various inconsistency across the board. Also, how do I change the organization ID? right now, it's using "lexshan1" as organization ID, which looks like a personal ID. Very confusing again.
Can a Zoho developer create a customer portal for me?
I am looking to create a customer portal that has the following: Client's past invoices from Zoho Books, see remaining balance on invoice, pay with credit card (already configured in Zoho books) Client can upload their multi-media assets (this could be tied into my dropbox or another storage program) Submit support ticket (could be linked to Facebook chat) See available product upgrades and request account manager to contact them See available promotions See news and updates Written instructions
OpenURL not working "On Add - On Validate"?
Hi Zoho, I have the following script on the "On Add -> On Validate" of a form: Current_Ins_Amount = (Insurance_Insured_Amounts[(Project_Name = input.Project_Name && Ship_Name == input.Ship_Name)].Insurance_Type).getall(); if (!Current_Ins_Amount.contains(input.Insurance_Type)) { alert "There is no amount entered for this insurance type. Please update the amount in the following dialog box"; openUrl("#Form:Insurance_Insured_Amounts?Project_Name=" + input.Project_Name + "&Ship_Name=" + input.Ship_Name
Edit Record from Search Interface HTML Page
I am essentially building a html search interface similar to the one here: https://www.zoho.com/creator/help/tutorials/advanced-app-building.html However, I would like to be able to select the records displayed in the results table to edit. So in the example, I would like to be able to click on the email address for Tina and be able to edit this record. I have almost managed to do this by using <a href="<thiscode>"> where thiscode = http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname>
Accessing Multiselect Field from another Form?
I have a user information record (setup by Form A) that has a multiselect field (Fielda) that is set by doing a lookup to another form (Form B) Now i need to access my user information from Form C to verify correct access. So, i can easily access the Form A information that is "native" to Form A - but how do i access the multi-select field in Form A that was set by the lookup field from Form B. (they were string fields originally setup in Form B) hope that makes sense thanks
Having Reports embedded in email to send out to clients
I want to be able to send certain records out to our clients in an email (embedded in the email) It must look nice. How can I do this?
Google Earth, GPS coordinates in Creator App
Hi all I have created a report that our managers must fill in when they respond to incidents (crime and investigations) I want to have a Google Earth map embedded, i.e if there is coordinates that they supply, for it to be pinned onto a map. Then at the end of the month I want to be able to see all the incidents that occurred in that area and if you click on each pin, it should bring up the record for that incident (the report) Is this a possibility with creator? How can I do this, or is there someone
Access Creator Table
I am trying to define a workflow in CRM that needs to lookup a table (to get the approving manager). I would like to use a simple lookup table in Creator which I would access from a deluge script in CRM. But I have having trouble accessing the Creator table from the API - it returns "permission denied." I have a subscription to CRM but not to creator. Will the free account work for what I want to do?
List of records in Multiline field
Hi, Say that I have several records that complies with the same selection criteria. The content of these records I would like to show them in a Multiline field. Example: The table have the following entries Company1, Name1, surname1, age1 Company2, Name2, surname2, age2 Company1, Name3, surname3, age3 Company3, Name4, surname4, age4 Company2, Name5, surname5, age5 Company1, Name6, surname6, age6 In the Multiline field when selected Company2 I would like to be able to display; Name2, age2; Name5,
setting <style> for all html pages from one spot?
Hi, Is it possible to define a style in Zoho that will effect every html page I write? In a function maybe? or anywhere else? Thanks! Ravid
Push and pull data between Zoho and FileMaker
Hi There, I need to find out how I would go about setting up a push/pull environment between a Zoho Form and a FileMaker Pro database. I have had a look at the integration tool, but I see that it is only for Windows, so I can't test it as I am currently on a Mac and I don't have access to a Windows machine. I would like to use Zoho Forms for my users to enter in data, and then be able to query my FileMaker database to either create/update/delete records. Is this possible?
Cross table pivot chart
Hi, I have a table of Orders and each Order has multiple Task and a Order_Total currency field. each Task is assigned to one Staff. How can i create a chart like the following X-axis: different Staff Y-axis: the Order_Total of all Orders of the Staff on x-axis. My difficulty is, when I create a chart base on Task, i can't reference the Order's Order_Total field. If i create a chart based on Order, i can't set the x-axis to Staff.
Next Page